Interested to Buy Any Domain ? << Click Here >> for more details...
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
- 1 Answers
- 4970 Views
- TCS, I also Faced
- E-Mail Answers
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 a tns service name?
Name the three major set of files on disk that compose a database in Oracle?
Give the constructs of a package, function or a procedure.
How index is implemented in oracle database?
types of indexes and the rationale behind choosing a particular index for a situation.
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Give the Types of modules in a form?
What is the difference between sharding and replication?
How to use fetch statement in a loop?
How to delete a column in an existing table?
what is meant by magic query
What is program global area (pga) in oracle?
Oracle General 
