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
Is truncate autocommit in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Is it possible to insert comments into sql statements return in the data model editor ?
How do I uninstall oracle client from windows?
Explain the truncate in oracle?
How to execute the package in oracle?
What are the different types of failures that occur in Oracle database?
What are the differences between number and binary_float in oracle?
What are the various oracle database objects?
Why is oracle database so popular?
What would you do with an in-doubt distributed transaction?
what are the default admin accounts in Oracle 10g ?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to call a stored function with parameters?
What does sharding mean?