| MSB |
Posted: Sep 15, 2008 07:20:31 AM |
Total Post: 19
Joined: May, 2008
|
| How to find out the SGA size? |
|
|
chai |
| Posted: Sep 15, 2008 08:28:14 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
Size of SGA=sum of all components of SGA(shared pool+db cache+java pool+large pool+redo buffer)
SQL>show parameter parametername
Ex:-
SQL>show parameter shared_pool_size
|
|
|
|
|
MSB |
| Posted: Sep 15, 2008 08:34:33 AM | |
|
Total Post: 19
Joined: May, 2008
|
can i use the below query??
SQL> select sum(value/1024/1024) Total_SGA from v$SGA;
TOTAL_SGA
----------
272
|
|
|
|
|
vino |
| Posted: Sep 15, 2008 08:42:47 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
To view the SGA size.
SQL> Show sga;
or
SQL> show parameter sga_max_size;
If you would like to alter the size of SGA. Use,
>alter system set sga_max_size=... scope=both;
Regards.
|
|
|
|
|
vino |
| Posted: Sep 15, 2008 08:52:23 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |