How to calculate the approximate size of the SGA based on
the size of the block,shared_pool,redo_buffer_cache and
db_buffer_cache?
- 1 Answers
- 2825 Views
- I also Faced
- E-Mail Answers
Answer / Asad Hussain
The size of the System Global Area (SGA) in an Oracle database is not calculated directly from individual components like block size, shared_pool, redo_buffer_cache, and db_buffer_cache. Instead, these components are allocated within the SGA. To estimate the SGA size, you can sum up the sizes of each component based on their respective parameters. However, it's important to note that Oracle automatically manages the sizes of these components, so it's not common practice to manually calculate the SGA size.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is PGA?
What is the significance of having storage clause ?
How to implement the multiple control files for an existing database ?
What is a Parallel Server option in ORACLE?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the function of checkpoint(CKPT)?
What is the function of ARCH?
What is the function of Lock (LCKn) Process?
What is the OPTIMAL parameter ?
• What is oracle Architecture?
Why query fails sometimes ?
What is SGA?
Oracle General 
