Oracle Performance Monitoring in Less than 12 Minutes (Video)
In this two part video, Stephane Faroult talks about “the basics of Oracle Performance Monitoring, and how you can get fancy (and even useful) reports without spending a fortune”. Stephane also demonstrates “how to install the (free) statspack utility and how some web resources can help you generate the reports you need for proactive monitoring”.
Filed in Oracle with 2 Comments | Tags: performance, videoRewriting SQL Queries for Performance in 9 Minutes (Video)
Here is another video from Stephane Faroult about how you can improve query performance:
Filed in Oracle with 3 Comments | Tags: database, performance, sql, videoNorthwest Oracle Users Group (NWOUG) 2006 Fall Conference
When was the last time you did not use a computer for one full day? My last time was yesterday and it was not because I was on vacation. Yesterday, I was in the Northwest Oracle Users Group (NWOUG) 2006 Fall Conference.
I attended six 45-minute presentations. The sessions that were interesting and that I liked most were the one presented by Dan Morgan: The Hidden Jewels in 10g, and the one presented by Cary Millsap: Accountability for System Performance. Dan did not use PowerPoint (which is good because I do not like watching slides while at the same time listening to the presenter reading the slides, I like the “real” thing), he actually fired up his SQLPlus and demonstrated a few really cool, useful and some undocumented Oracle 10g SQL features, which I will be blogging about soon. I also liked Cary Millsap’s presentation mainly because the subject that he talked about was really interesting.
In the conference, I also bumped into Jared Still. Jared and I used to work for the same company before we both moved on to different employers, but still in the same neighborhood. Even though we worked for the same employer, we were not in the same department. After all, Jared is a DBA and I am a developer 
.
How do you use tkprof to solve a performance problem?
In his latest article, Jonathan Lewis uses tkprof to analyse the performance of a query. He concluded that “When you examine the output from tkprof, it often takes a simultaneous cross-check of the block level statistics, the Row Source Operation counts, and some sensible guesswork about the purpose of the query, to be able to understand where the problem is, and how it may be addressed.” Read Jonathan’s interesting article: An example of making sensible guesses from a tkprof output.
Filed in Oracle with 2 Comments | Tags: performance, tkprof, tuning
