where can I find the alert log?
thanks.
Greg Chang
"Joel Garry" <joel-garry_at_home.com> wrote in message
news:91884734.0406141453.73e88950_at_posting.google.com...
> "Greg Chang" <ychang10_at_houston.rr.com> wrote in message
news:<slPyc.21269$KL2.12212_at_fe2.texas.rr.com>...
> > Hi Folks,
> >
> > I had 2 Oracle 9 Instances installed on the same Windows 2003 server,
the
> > first installed called Production Instance, and the second installed two
> > weeks later called Test Instance. Two instances are identical as I can
tell.
> > Before we installed Test, One of the P/L SQL Procedure run on the
Production
> > took about 1.5 hours to finished, and that is ok,to us, since it handles
> > lots of data.
> > However after we installed the Test Instance, and imported the
production
> > database to the Test instance.
> > The same procedure runs 9 hours in Production database, and runs 1.5
hours
> > in test database.
> > Could any one point me a direction to find what caused the difference?
> >
> > Thanks.
> >
> > Greg
>
> Could it be you are thrashing because someone in production is
> necessitating read consistency? Does this still occur if you bounce
> the machine just before running the procedure? Any strange undo
> messages in the alert log?
>
> jg
> --
> @home.com is bogus.
> What's in your database?
>
http://sfgate.com/cgi-bin/article.cgi?file=/c/a/2004/06/12/MNGOB7598T1.DTL&type=printable
Received on Tue Jun 15 2004 - 23:13:07 CDT
