What is Shared SQL Area?
Answer / siva.k
A Shared SQL area is required to process every unique SQL
statement submitted to a database and contains information
such as the parse tree and execution plan for the
corresponding statement.
| Is This Answer Correct ? | 6 Yes | 0 No |
How will you monitor the space allocation ?
What is function of RECO?
What is meant by Redo Log file mirrorring ? How it can be achieved?
1.Explain the three levels with the help og a diagram.
what is ORACLE MEMORY STRUCTURES
How to define Data Block size in Oracle?
What is Dedicated Server Configuration?
What is meant by redo log buffer ?
What does LGWR do?
What is the function of Lock (LCKn) Process?
What is an Oracle Rollback Segment?
What are the two types of Server Configurations?