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 |
How many memory layers are in the oracle shared pool?
What is a cognitive schema?
How to view the dropped tables in your recycle bin?
Explain the use of rows option in exp command.
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
Explain an integrity constrains?
In which language oracle has been developed?
How to handle a single quote in oracle sql?
What is an Oracle view?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
how to find the second highest salary in a given table????
How to create a new table in your schema?