Scott,
I don't understand I have tried to capture a
session, but I need to get a repository up to look at the trace that was
generated.
No mention of Oracle versions or even O/S levels but I am sure you have
Statspack available which should give you a good start.
So have an overall view of
Scott - I would approach this as a standard tuning problem, and try to avoid
making assumptions about what the answer is. Find out what the system waits
are. STATSPACK is pretty good at listing your waits. Otherwise, there are
scripts available that you can run. Make sure the database is waiting
Hi Scott,
I wouldn't worry about the hit ratios. Have you tried to find badly
performing SQL. The chances are the execution plan may have changed for some of
the frequently used SQL. When you doubled the block size, did you halve the
db_file_multiblock_read_count ? The optimizer may be
I have done this before and I always do it
on a test machine first as everything that
has been tuned up to this point is now at step
1 all over again.
Did you import everything properly ? Indexes ?
Make sure your schema objects are analyzed again.
Find out the time of the day where
in addition you could also have
I/O and or CPU problems so check those things
out too.
-Original Message-
Sent: Thursday, August 01, 2002 3:31 PM
To: '[EMAIL PROTECTED]'
I have done this before and I always do it
on a test machine first as everything that
has been tuned up to