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 is an Oracle Data Block?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is dictionary cache ?
What is hit ratio ?
What are the functions of SMON?
How will you force database to use particular rollback segment?
what is the role of archiever
Can a Tablespace hold objects from different Schemes in Oracle?
What is the function of ARCH?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
List the factors that can affect the accuracy of the estimations ?
What is the significance of having storage clause ?