-
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.
-
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
-
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
-
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.....=)
-

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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|