Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
- 1 Answers
- 3873 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rishish Mishra
The System Global Area (SGA) is a shared memory region in an Oracle database that contains data structures essential for database operations. It includes the Database Buffer, Redo Log Buffer, Shared Pool, and Large Pool.nnFor mid-sized OLTP environments, the SGA can be configured as follows:nn - Database Buffer Size: Increase to accommodate larger amounts of data for faster query response times.n - Redo Log Buffer Size: Adequate size to minimize I/O operations when writing redo logs.n - Shared Pool Size: Optimal size to manage shared memory structures like SQL area, library cache, and dictionary cache.nnTuning the SGA involves adjusting its size parameters based on workload, system resources, and performance requirements. This may include analyzing database usage patterns, monitoring wait events, and using tools like DBMS_STATS or AWR reports.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
