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 is dual table oracle?
what are the advantages of running a database in archive log mode?
Compare and contrast between sql and sql server and explain its various functions?
Can I create users through internet explorer in oracle 10g?
What is recycle bin in Oracle?
Explain oracle’s system global area (sga).
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to delete a column in an existing table?
What the is the diff between local index and global index. give some example.
How to convert times to characters in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to write text literals in oracle?
Where is the export dump file located?
What are the parameters that we can pass through a stored procedure?
How to install oracle database 10g xe?