Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle DBA Interview Questions---Pls Answer them

452236Apr 20 2006 — edited Apr 21 2006
Hi ALl,
Could you please answer the below questions.They have been asked in the DBA interviews:
1)How much memory one should allocate to SGA,shared pool,buffer cache and log buffer out of the total server memory.
2)What will happen to the current transaction if the tablespace containing the object is taken offline.
3)What actually happens in the background after the insert is fired.


Thanks in advance.
Sumit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2006
Added on Apr 20 2006
9 comments
973 views