Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by sga and how is it different from pga?
- 1 Answers
- 5 Views
- I also Faced
- E-Mail Answers
Answer / Naveen Shukla
System Global Area (SGA) is a shared memory structure in Oracle Database that stores data and control information for the entire instance. It includes the Data Dictionary, Redo Log Buffer, Shared Pool, Large Pool, Java Pool, and Database Buffer Cache. Process Global Area (PGA) is a private memory structure for each server process. It includes the session-specific data like cursor caches and sort areas.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the oracle grid infrastructure?
Where does the clusterware write when there is a network or storage issue?
What is the difference between instance recovery and crash recovery?
What is the difference between media recovery & crash recovery?
Mention what are the tools provided in oracle enterprise manager?
How is incremental backup different from differential backup?
What do you mean by database normalization and why is it important?
What do you understand by row chaining?
What if your ocr (oracle cluster registry) is corrupted?
What is table partitioning?
What are the file systems and volume management techniques used in oracle rac?
What do you understand from cache fusion?
Oracle General 
