RE: Slow Database Aft Upgrade from 8i to 9.2
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <BurtonL@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2005 12:03:27 -0700
Hi Laura,
You might want to try running statspack and uploading the results to
oraperf.com for analysis.
It is typical to require a significantly larger shared pool after an upgrade
from 8i to 9i, so you might want to increase that, but I wouldn't do it blindly
- check your stats first to see if it's necessary, otherwise you might be
wasting space that could be better allocated to your buffer cache or elsewhere.
Most likely, your problem is the result of queries using different execution
plans from what was used in 8i. You can find the top statements in statspack,
OEM Top SQL, or in v$sql and then look at their execution plans compared to
what they used to be in 8i. Or perform traces of the specific slow-running
queries and do a before/after upgrade comparison on them.
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Burton, Laura
Sent: Thursday, July 21, 2005 11:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Slow Database Aft Upgrade from 8i to 9.2
Can someone direct me to a place to troubleshoot your database? Is
there a way to check for 'Memory Leaks'? I have a tuning book and have
been running scripts to find how much is being used, what statements are
the worst, etc., but is there a 'common' size for the Shared Pool, Large
Pool, Sort, etc? I know it depends on the size of the database. I
guess I am just looking for a starting point, i.e. if small blah, blah;
if large blah blah, or large pool is ??% the size of the Shared Pool and
total db memory should not be more than ??% of physical memory.
Thanks, Laura
--
//www.freelists.org/webpage/oracle-l
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
