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
- 2820 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
