What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Answer Posted / sawant
The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.
The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the differences between lov and list item?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Why do we need oracle client?
What do database buffers contain?
What is background process in Oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to estimate disk space needed for an export job?
What are the major difference between truncate and delete?
How does the on-delete-cascade statement work?
What happens if you use a wrong connect identifier?
Explain the use of rows option in imp command.
What is a cognitive schema?
Differentiate between post-database commit and post-form commit?