Re: Slow Database Aft Upgrade from 8i to 9.2
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: BurtonL@xxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 17:20:41 -0700
Did you do a full stats gathering on the schema soon after upgrade? We
had a bunch of issues in production along similar lines; The first thing
you need to do is to compare the execution plan of frequently used
queries before and after.
hth
GovindanK
On Thu, 21 Jul 2005 13:54:20 -0500, "Burton, Laura"
<BurtonL@xxxxxxxxxxx> said:
> 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
Other related posts:
