Oracle performance monitoring tool
-
Hi guys, Anyone aware of any tool using which i could find what kind of scan is performed for a running query and some tips how to improve query performance. I want a pointer to a tutorial on improving oracle query performance. thanks, Venkat Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms
-
Hi guys, Anyone aware of any tool using which i could find what kind of scan is performed for a running query and some tips how to improve query performance. I want a pointer to a tutorial on improving oracle query performance. thanks, Venkat Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms
-
Thanks, But url is not working Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms
-
Thanks, But url is not working Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms
Venkatraman wrote: But url is not working Which one? They're both OK for me.
"Sucks less" isn't progress - Kent Beck [^] Awasu 1.1.4 [^]: A free RSS reader with support for Code Project.
-
Hi guys, Anyone aware of any tool using which i could find what kind of scan is performed for a running query and some tips how to improve query performance. I want a pointer to a tutorial on improving oracle query performance. thanks, Venkat Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms
Unfortunately, all of them are simply glorified versions of EXPLAIN PLAN. EXPLAIN PLAN's output is text based, and is hard to be read for those coming from SQL Server. TOAD has a better view of EXPLAIN PLAN, but you'll still suffer. I saw once a free Java app (sorry, I don't recall the name) that showed a graphical view of EXPLAIN PLAN, but since I got used to Oracle's view, I don't use it anymore. Trying to make bits uncopyable is like trying to make water not wet. -- Bruce Schneier By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
-
Unfortunately, all of them are simply glorified versions of EXPLAIN PLAN. EXPLAIN PLAN's output is text based, and is hard to be read for those coming from SQL Server. TOAD has a better view of EXPLAIN PLAN, but you'll still suffer. I saw once a free Java app (sorry, I don't recall the name) that showed a graphical view of EXPLAIN PLAN, but since I got used to Oracle's view, I don't use it anymore. Trying to make bits uncopyable is like trying to make water not wet. -- Bruce Schneier By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
-
Thanks all for your answers. I have downloaded the same but the License comign with that doesnt allow me to use the app. :( thanks anyway for your help, Venkat Cheers, Venkatraman Kalyanam Bangalore - India Why the US can't win the outsourcing war against India Our advice to US CEOs, governors and senators: come out of denial and switch to curd-rice for dessert; it’s both cheaper and healthier - for bottomlines of the physical kind – than ice-cream http://economictimes.indiatimes.com/articleshow/msid-334938,Curpg-1.cms