RE: Oracle 101 Performance Tuning comes to the rescue again!
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 AMTo: Multiple recipients of list ORACLE-LSubject: 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
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-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 1:53 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: Oracle 101 Performance Tuning comes to the rescue again! 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 AMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Oracle 101 Performance Tuning comes to the rescue again!
Tom, would a monitor in place have notified the admins as to a locking issue? I usually run Steve Adam's enqueue.sql script to find locked objects. Also have monitors in place that generate an email when locked exceed a specific time. Pretty typical for me to call an app dev and ask him if he forgot to issue a commit, which is usually the case. By the way I second the book recommend. I went to once of Gaja's presentations and got the gist of the methodology but when I bought the book I was able to actually absorb it. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Oracle 101 Performance Tuning comes to the rescue again!
Love the book as well - have used it for tuning various times. Automate...automate..automate... -Original Message-From: Post, Ethan [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 2:43 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 101 Performance Tuning comes to the rescue again! Tom, would a monitor in place have notified the admins as to a locking issue? I usually run Steve Adam's enqueue.sql script to find locked objects. Also have monitors in place that generate an email when locked exceed a specific time. Pretty typical for me to call an app dev and ask him if he forgot to issue a commit, which is usually the case. By the way I second the book recommend. I went to once of Gaja's presentations and got the gist of the methodology but when I bought the book I was able to actually absorb it. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Oracle 101 Performance Tuning comes to the rescue again!
It is an excellent book!!! -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 12:52 PMTo: Multiple recipients of list ORACLE-LSubject: 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