| Need help with shared pool sizing [message #468815] |
Mon, 02 August 2010 04:36  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
HI,
Could someone please tell me how to increase the library cache size as there is lot of free space in shared pool.
I guess incresing the size of shared pool is one option. Since, there is atleast 180-210MB free space, is the above option a good one?
Please advice.
SQL> select * from v$sga;
NAME VALUE
-------------------- ---------
Fixed Size 52144
Variable Size 346710016
Database Buffers 701235200
Redo Buffers 4104192
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
