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

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

Answer / ashok

from v$sgastat view we can find the size of sga

Answer / acpkp

select sum(bytes)/1024/1024 from v$sgastat;

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

Answer / guest

sql>show sga;

or
sql>select * from v$sga;

Answer / srinu16

in sql show parameter sga;

What are the two types of Server Configurations?

3 Answers  

What is Database Buffers ?

4 Answers  

What does LGWR do?

2 Answers  

What is Dedicated Server Configuration?

2 Answers   IR Consulting,

What is a Multi-threaded Server Configuration?

1 Answers  

How the log writer writes the data into database

4 Answers   Baidu, Satyam,

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?

0 Answers  

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  

What is Shared SQL Area?

1 Answers   Oracle,

When Does DBWR write to the database?

6 Answers  

How can you find the size of a database?

5 Answers   Baidu, HCL,

What is the maximum size of a oracle9i database?

1 Answers   Baidu, HCL, TCS,