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 |
What are the components of SGA?
what is the role of archiever
What are the consideration at tehe migration of Oracle 9i to 10G.
What constitute an ORACLE Instance?
How the space utilisation takes place within rollback segments?
What is meant by recursive hints ?
What is a Rollback segment entry ?
How to define Data Block size in Oracle?
Which parameter in Storage clause will reduce no. of rows per block?
What is an Oracle Data Dictionary?
What are the functions of SMON?
What are functions of PMON?