What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Answer / 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 |
What is the maximum number of triggers that can be applied to a single table?
if you update view? where we store the data?
What is the difference between Delete, Truncate and Drop in Oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to define an anonymous procedure with variables?
How to create an oracle database?
Calculate difference between 2 date / times in oracle sql?
What do you understand by a database object?
What is a synonym? What are its various types?
Is primary key indexed by default in oracle?
What happens to the current transaction if the session is ended?
Explain compound trigger in oracle?