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
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to get the Installed Oracle Version Information ?
How to use like conditions in oracle?
how to join query for one source type is oracle another source type is sql server ?
Can a parameter be passed to a cursor?
How to write a query with an inner join in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How translate command is different from replace?
How a tablespace is related to data files?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
what are archived logs?
How to drop a tablespace?
Can I create users through internet explorer in oracle 10g?
What is a database schema in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?