Hi all!
Query:
1.I have Library Cache filled up and there is no room for more sql statements.
How should I increase/allocate more buffers to the Library cache.
Thanks&Regards,
Amit.
Printable View
Hi all!
Query:
1.I have Library Cache filled up and there is no room for more sql statements.
How should I increase/allocate more buffers to the Library cache.
Thanks&Regards,
Amit.
Yes you should,
add value for shared_pool_size.
Shut down db
Increase value of shared_pool parameter in init file
restart