BG process dying-question for pando,tamilselvan,wjramsay - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: BG process dying-question for pando,tamilselvan,wjramsay

  1. #11
    Join Date
    Jun 2000
    Posts
    104
    hi tamil,
    can u tell why the sga size should be in that ratio to my RAM.
    I read in some books that I can give more to SGA and little memory is needed for NT BG processes,I will really appreciate any help.

    this is what i read-

    for optimal performance,u want to make sure that u'r machine has enough memory to accomodate the entire sga and still have some memory left for OS to perform well.pl reply back asap.it will be a great help.
    Share on Google+

  2. #12
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Would it be a good idea to write some FAQ's up or publish some already created faq's on the site? I see a large number of repeated common errors and it seems it would save a lot of postings and such to make them available.

    Joe

    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227
    Share on Google+

  3. #13
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Could you please email me the following:

    1. A copy of your initialization file
    2. A copy of your tnsnames and listener files
    3. A copy of your alert log
    4. Include in the text of your email #CPU's and memory you
    have.
    5. At a time when you have an average load (watch out for
    lunch breaks) run the following:

    SVRMGRL> your_oracle_home\rdbms\admin\utlbstat

    This will run some scripts to create some temporary tables and collect some statistics.

    Let this run for about 2 hours and then run

    SVRMGRL> your_oracle_home\rdbms\admin\utlestat

    Make sure before you do this that the parameter TIMED_STATISTICS = TRUE. Also, when you run utlestat, make sure you are in a directory that you have write permissions to.

    There will be a report generated called report.txt - attach this file as well to your email and send it my way.

    Thanks,

    Joe
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227
    Share on Google+

  4. #14
    Join Date
    Jun 2000
    Posts
    104
    hi wjramsay,
    I donot have your mail address ,pl give that.as soon as possible I will send all that U needed.as per U asked about creating FAQs will definitely be helpful.it will be a help also
    to give the list of bugs each version of oracle have and the corresponding patches available by metalink.thanks for spending so much of time for my queries.

    regards
    smruti
    Share on Google+

  5. #15
    Join Date
    Jun 2000
    Posts
    104
    hi,

    only the snapshot processes r getting dead occasionally.and wjramsay pl let me have u'r email address so that I can give those files as u asked.we donot have oracle support so I cannot avail patches from metalink.any other reply is welcome

    and tamil
    if u get some time pl let me know about that sga size to be 30-40% of RAM.

    warm regards and personally I thank u all for all u'r helps
    Share on Google+

  6. #16
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    I believe it's in my profile but you can email the items
    to

    oracle_8_dba@hotmail.com

    Thanks :)

    Joe
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227
    Share on Google+

  7. #17
    Join Date
    Jun 2000
    Posts
    104
    HI JOE,
    LASTLY i REDUCED THE SIZE OF SHARED_POOL WHICH WAS SET TO 230M TO 200M AND DB_BLOCK_BUFFERS TO 50000 WHICH WAS 60000 AND WATCHING FOR FURTHER HAPPENINGS,

    IF THE PROBLEM STILL CONTINUES THEN i WILL LET U KNOW
    AT U'R MAIL ADDRESS.

    REGARDS AND THANKS

    I AM READING IN THIS FORUM FROM LONG TIME TO SET SGA TO 30-40% OF MEMORY.BUT IN SOME BOOKS i FOUND SOMETHING ELSE,LIKE IF NO OTHER APPLICATION RUNNING IN SERVER I CAN SET SGA TO MORE THAN 50%.

    WHAT DO U SAY?IN PREV VERSIONS OF ORACLE SOME VIEWS LIKE CURRENT_BUCKET AND RECENT_BUCKET WAS THERE TO FIND OUT THE NO. OF BLOCK BUFFERS NEEDED TO MAKE THE BUFFER HIT RATION >90%.IN VER 8.1.5 THEY R NOT THERE?HAVE U GOT ANY OTHER WAY TO FIND THE REQUIRED NO.OF BLOCK BUFFERS TO INCREASE HIT RATIO.OR JUST TO INCREASE AND CHECK THE RESULT.


    Share on Google+

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