|
|
abukta
super admin
profile |
|
Join Date: 29 Mar 2005 21:03
Posts: |
|
|
How to check the size of the SGA |
There are two ways you can check the size of the SGA of your database.
1. select * from V$SGA;
or
2. You can also use Server Manager to do this as well. While in svrmgrl perform the following command :
>show sga
The second one would work in Oracle8i and below. Starting from Oracle9i, Server Manager functionalities have been merged with SQL Plus. So if you have Oracle9i and above, use SQL Plus to issue the same command:
Exmaple:
========
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> show sga
Total System Global Area 109812156 bytes
Fixed Size 453052 bytes
Variable Size 41943040 bytes
Database Buffers 67108864 bytes
Redo Buffers 307200 bytes
SQL>
|
Home 
Forum
