HEY, watch those BALD jokes!! *-) Dick Goulet Remember: grass don't grow on a busy street. That "bald" area is an indication of a super highway.
____________________Reply Separator____________________ Author: Stefan Jahnke <[EMAIL PROTECTED]> Date: 2/4/2003 8:39 AM Hi Recommended reading in this case: "Balding 101 Shave the rest off". Helped me too and you also get the neat side effect of "looking meaner" ... which helps in management meetings ;) Regards, Stefan -----Urspr�ngliche Nachricht----- Von: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 31. Januar 2003 19:57 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle 101 Performance Tuning comes to the rescue again! 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2>Hi</FONT></SPAN></DIV> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2>Recommended reading in this case: "Balding 101 Shave the rest off". Helped me too and you also get the neat side effect of "looking meaner" ... which helps in management meetings ;)</FONT></SPAN></DIV> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2>Regards,</FONT></SPAN></DIV> <DIV><SPAN class=489013716-04022003><FONT face=Arial color=#0000ff size=2>Stefan</FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Urspr�ngliche Nachricht-----<BR><B>Von:</B> Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]<BR><B>Gesendet:</B> Freitag, 31. Januar 2003 19:57<BR><B>An:</B> Multiple recipients of list ORACLE-L<BR><B>Betreff:</B> RE: Oracle 101 Performance Tuning comes to the rescue again!<BR><BR></FONT></DIV> <DIV><FONT face=Arial color=#0000ff size=2> <DIV><SPAN class=156005218-31012003><FONT face=Arial color=#0000ff size=2>Kirti,</FONT></SPAN></DIV> <DIV><SPAN class=156005218-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=156005218-31012003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV> <DIV><SPAN class=156005218-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=156005218-31012003><FONT face=Arial color=#0000ff size=2>thanks again</FONT></SPAN></DIV></FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Tom Mercadante</FONT> <BR><FONT face=Arial size=2>Oracle Certified Professional</FONT> </DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Deshpande, Kirti [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, January 31, 2003 1:53 PM<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Cc:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> RE: Oracle 101 Performance Tuning comes to the rescue again!<BR><BR></FONT></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2>Tom,</FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2> Thanks a lot.</FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2> I am glad to read that the book is helping you.</FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2> I am not so sure about ".. solves all problems", though ;) </FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2> Regards,</FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2>- Kirti</FONT></SPAN></DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=682513718-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, January 31, 2003 11:52 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Oracle 101 Performance Tuning comes to the rescue again!<BR><BR></FONT></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>All,</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>you *MUST* buy this book.</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>I just got called over by the Warehouse people. Their database was hung. We could log-on ok, but certain queries would hang.</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>killed the analyze and the MV started up again.</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>great book. solves all problems. great job Gaja, Kirti and John. you guys do the work, and I look like a hero.</FONT></SPAN></DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=651144117-31012003><FONT face=Arial color=#0000ff size=2>thanks again.</FONT></SPAN></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Tom Mercadante</FONT> <BR><FONT face=Arial size=2>Oracle Certified Professional</FONT> </DIV> <BLOCKQUOTE><FONT face=Arial color=#0000ff size=2></FONT> </BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> <BR> <BR> <P><U><FONT SIZE=2 FACE="Arial"></FONT></U> </P> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
