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 would you best determine why your MVIEW couldnt FAST REFRESH?
How to define a procedure inside another procedure?
What is the use of aggregate functions in oracle?
Whats the benefit of dbms_stats over analyze?
How can I introduce multiple conditions in like operator?
What is translate in oracle?
What is a private synonym?
What do you mean by merge in oracle?
What is the sid in oracle?
How to store only time; not date and time?
What is recovery manager in Oracle?
Give the various exception types.