DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Another init.ora questions

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Question

    Another general question for init.ora files. Let say that I went to interview and interviewer asked me about what is the FIVE most important parameters in init.ora files and why?....I'm pretty sure people would have different ideas and suggestions on this, but I would like to hear from experienced Oracle DBAs....=)

    Thank you.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I he really goes that deep in an interview tell him:

    DB_BLOCK_SIZE
    DB_BLOCK_BUFFERS
    SHARED_POOL_SIZE
    SORT_AREA_SIZE
    LOG_BUFFER

    However, some people might replace one of tjose 5 with

    OPTIMIZER_MODE
    LOG_CHECKPOINT_INTERVAL
    OPEN_CURSORS
    DBWR_IO_SLAVES
    DB_FILE_MULTIBLOCK_READ_COUNT
    LARGE_POOL_SIZE
    LOCK_SGA


  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'd laugh, thank them for their time, and leave. Every init.ora parameter is important. If it wasn't, it wouldn't be an init.ora parameter.
    Jeff Hunter

  4. #4
    Join Date
    Jun 2001
    Posts
    243
    see...that's what I think...I thought all the parameter files in the init.ora are important...and one of my friend had interview question asking about that question.....and I wanted to hear from you guys.....=)

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925


    I really appreciate Julian's time. The first 5 parameters are CRITICAL to the DB startup. I also would include DB_NAME SERVICE_NAME in there.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by sambavan


    I really appreciate Julian's time. The first 5 parameters are CRITICAL to the DB startup. I also would include DB_NAME SERVICE_NAME in there.

    Sam
    Yes Sam, they should be there. It is really an odd task to identify *only* 5 init.ora parameters :-)

    Just for the curiosity, in which country did someone ask that init.ora question at a job interview?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width