Is there ant way that I can find out if the shared_pool rerserve size has been defined in my database?
May be a select query to tell me that?
Printable View
Is there ant way that I can find out if the shared_pool rerserve size has been defined in my database?
May be a select query to tell me that?
select name, value
from v$parameter
where name like 'shared%';
Always use the Eazy way..
In Oracle 8i
Show Parameter shared ...
or you can give any parameter name to find the exact values.
Like All parameters having word Control
Use Show Parameter Control
Thanks..