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

Thread: Shared Pool setttings in init file

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Shared Pool setttings in init file

    Hello all..

    Oracle 817/Sun 5.8


    I changed my Shared pool settings from 4MB to 16MB in OEM. After making the changes, OEM prompted me to restart the Database which i did thru OEM.

    NExt, i went to Sun Command prompt and opened the init file to see if the values are updated. But init file still has
    shared_pool_size = 4194304

    How do i know if the DB is using 16MB or 4MB ?...also..do i have to make the changes again in init file ?...

    I do see 2 init files ...one in $ORACLE_HOME/dbs/cquest/initcquest.ora and other in
    /opt/oracle/oradata/mnt1/app/oracle/admin/cquest/initcquest.ora.



    Any help is appreciated.

    ron

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    In which parameter file did u check for shared_pool_size. U can also see all the values of the parameter file by login into sqlplus using sys account and executing "show parameter"

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    I checked for shared poo1 size in /opt/oracle/oradata/mnt1/app/oracle/admin/cquest/pfile/initcquest.ora


    there is another initfile for the same instance at /opt/oracle/oradata/mnt1/app/oracle/product/8.1.7/dbs/initcquest.ora.

    Both these places , it shows Shared pool as 4MB, but OEM shows as 16MB. Also Show parameter gives
    shared_pool_size string 16777216


    so i am littel confused...do i have to manually update these 2 init files to make everytthing in sync ?.

    Thanks in advance
    Ron

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Note to Jr. DBA's, this is why you shouldn't use a GUI until you fully understand what's going on.

    Your init.ora has a shared pool size of 4M. Assuming your database was started with a shared pool bigger than 4M, my guess is that OEM used a different parameter file to start your database with a larger shared pool.
    Jeff Hunter

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    when ever u do a startup of database without specifiying the pfile parameter, oracle will use the parameter file in $ORACLE_HOME/dbs/

    Also search for this init file in another location of the system and check the shared_pool_size there, probably OEM might be using this file

    regards
    anandkl
    anandkl

  6. #6
    Join Date
    Oct 2002
    Posts
    284
    I checked for shared poo1 size in /opt/oracle/oradata/mnt1/app/oracle/admin/cquest/pfile/initcquest.ora


    there is another initfile for the same instance at /opt/oracle/oradata/mnt1/app/oracle/product/8.1.7/dbs/initcquest.ora.

    Both these places , it shows Shared pool as 4MB, but OEM shows as 16MB. Also Show parameter gives
    shared_pool_size string 16777216


    so i am littel confused...do i have to manually update these 2 init files to make everytthing in sync ?.

    Thanks in advance
    Ron

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    Your init.ora has a shared pool size of 4M. Assuming your database was started with a shared pool bigger than 4M, my guess is that OEM used a different parameter file to start your database with a larger shared pool.
    Jeff Hunter

  8. #8
    Join Date
    May 2001
    Posts
    73
    Check if you have parameter file under $ORACLE_BASE/admin/$ORACLE_SID/pfile directory.

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