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.
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.
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
5. At a time when you have an average load (watch out for
lunch breaks) run the following:
This will run some scripts to create some temporary tables and collect some statistics.
Let this run for about 2 hours and then run
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.
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.
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
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
I believe it's in my profile but you can email the items
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.