Tom,
Thanks a lot.
I am glad to read that the book is helping you.
I am not so sure about ".. solves all problems", though ;)
Regards,
-
Kirti
-----Original Message-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 11:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle 101 Performance Tuning comes to the rescue again!
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 11:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle 101 Performance Tuning comes to the rescue again!
All,
you
*MUST* buy this book.
I just
got called over by the Warehouse people. Their database was hung. We
could log-on ok, but certain queries would hang.
Ran
the four "wait-state" queries and saw that two queries were hung on library
cache. the two queries were an analyze table and a MV refresh - using the
same table. hung them both out to dry.
killed
the analyze and the MV started up again.
great
book. solves all problems. great job Gaja, Kirti and John. you
guys do the work, and I look like a hero.
thanks
again.
Tom Mercadante
Oracle Certified Professional
Oracle Certified Professional