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 an Oracle SYSTEM tablespace and when is it Created?
What is the function of Redo Log in Oracle?
Why query fails sometimes ?
Diference between Oracle 9i and 10G.
Can a View based on another View in Oracle?
What is meant by recursive hints ?
What is an oracle database schema?
What is an Oracle Data Block?
What is Shared Pool?
When will be a segment released?
What is the significance of having storage clause ?
1.Explain the three levels with the help og a diagram.