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 does Space allocation table place within a block ?
What are disadvanteges of having raw devices ?
When Does DBWR write to the database?
what is the role of archiever
Name the ORACLE Background Process?
What is the significance of having storage clause ?
What is the functionality of SYSTEM table space ?
What is an Oracle Data Dictionary?
What does LGWR do?
What are the uses of Oracle Rollback Segment?
What are the consideration at tehe migration of Oracle 9i to 10G.
Can a View based on another View in Oracle?