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 the function of checkpoint(CKPT)?
What is the role of PCTFREE parameter is Storage clause ?
What is function of RECO?
Can a View based on another View in Oracle?
What is an oracle database schema?
What is Cursor?
How the log writer writes the data into database
What is an Oracle SYSTEM tablespace and when is it Created?
How will you estimate the space required by a non-clustered tables?
Name the ORACLE Background Process?
Why query fails sometimes ?
How to find the SGA Size