What is User Process?
Answer / guest
A user process is created and maintained to execute the
software code of an application program. It is a shadow
process created automatically to facilitate communication
between the user and the server process
| Is This Answer Correct ? | 0 Yes | 1 No |
What is SGA?
How many Dispatcher Processes are created?
What is Shared SQL Area?
When will be a segment released?
What is Cursor?
What is advantage of having disk shadowing/ Mirroring ?
What is Server Process?
What is Database Buffers ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is meant by free extent ?
What is the maximum size of a oracle9i database?
How will you monitor the space allocation ?