DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: shared_pool reserve size

  1. #1
    Join Date
    Oct 2000
    Posts
    22
    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?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select name, value
    from v$parameter
    where name like 'shared%';

  3. #3
    Join Date
    Feb 2001
    Posts
    184
    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..


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width