Oracle-L: RE: Oracle 101 Performance Tuning comes to the rescue again!

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 31 Jan 2003 10:57:09 -0800
Message-ID: <F001.00540C89.20030131105709@fatcity.com>

Kirti,

well, maybe it doesn't solve the problem of my forehead getting higher and higher every day, but the technique described in your book is always helpful in determining where problems exist in the system.

thanks again

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, January 31, 2003 1:53 PM
To: ORACLE-L_at_fatcity.com
Cc: NDATFM_at_labor.state.ny.us

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-----
Sent: Friday, January 31, 2003 11:52 AM
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 31 2003 - 12:57:09 CST