How to find the SGA Size
Answers were Sorted based on User's Feedback
Answer / ---
show sga
It shows :
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Is This Answer Correct ? | 39 Yes | 4 No |
Answer / cspriyadba
select * from v$sga;
Fixed Size 72536 bytes
Variable Size 22900736 bytes
Database Buffers 409600 bytes
Redo Buffers 77824 bytes
Total System Global Area : - Total in bytes of all the sub-
divisions that makes up the SGA.
Total System Global Area 23460696 bytes
Is This Answer Correct ? | 29 Yes | 4 No |
Answer / nishant jakkal
To approximate size of the SGA (Shared Global Area), use
following formula: db_cache_size + db_keep_cache_size +
db_recycle_cache_size + db_nk_cache_size + shared_pool_size
+ large_pool_size + java_pool_size + log_buffers + 1mb
Is This Answer Correct ? | 6 Yes | 3 No |
What is use of Rollback Segments In Database ?
Can a Tablespace hold objects from different Schemes in Oracle?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is a Control file ?
How to implement the multiple control files for an existing database ?
What is the maximum number of Lock Processes used?
What is the function of ARCH?
What are Oracle Schema Objects?
What are the uses of Oracle Rollback Segment?
What is advantage of having disk shadowing/ Mirroring ?
What is Server Process?
1.Explain the three levels with the help og a diagram.