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 to select the name of employee who is getting maximum sal with out using subquery
what is grid in Oracle 10g...
How to fetch the row which has the max value for a column?
How to convert characters to dates in oracle?
How to call a stored procedure inside a trigger? Give an example.
What is execute immediate in oracle?
Can we create more than one constraint to column ?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is difference between foreign key and reference key
select * from emp what happened internally when we write this query in the sql prompt?
What are the types of Database Links ?
How to pass a parameter to a cursor in oracle?