What are the various ingredients of sga?
- 1 Answers
- 653 Views
- I also Faced
- E-Mail Answers
Answer / Subhasish Madvel
The System Global Area (SGA) is a memory area shared by all server processes in an Oracle instance. It consists of several components, including:
1. Database Buffer: Caches data blocks from the database.
2. Redo Buffer: Holds redo log entries before they are written to the online redo logs.
3. Shared Pool: Stores shared SQL areas (containing parsed SQL statements), library cache (containing shared libraries), and other data structures.
4. Large Pool: Manages large memory allocations for server processes.
5. Java Pool: Supports the Oracle JVM.
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens if the constraint name is left out of a constraint clause?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What exactly does a dba do?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
You have taken a manual backup of a datafile using os. How rman will know about it?
Can you remove an open file under unix?
What is oracle dba role?
What are elements of administration?
What is difference between logical standby database and physical standby database?
What are the five functions of a database?
How can you determine if an index needs to be dropped and rebuilt?
What is the most common database language that a db administrator needs to know?
Oracle General 
