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 disadvanteges of having raw devices ?
What is meant by free extent ?
What is the functionality of SYSTEM table space ?
When does LGWR write to the database?
What is an Oracle Data Block?
1.Explain the three levels with the help og a diagram.
What is the function of Lock (LCKn) Process?
What is PGA?
What Does DBWR do?
What is a Control file ?
What is Server Process?
How will you estimate the space required by a non-clustered tables?