DBA Tools

How oramon track Oracle performance? -- V$SESSION

    When hit database load problems, I always want to know what the active sessions are doing and waiting. On 10g we can get these information from V$SESSION view, on 8i and 9i, we can join V$SESSION and V$SESSION_WAIT....

Posted on December 3, 2007 4:45 PM

How oramon track Oracle performance? -- V$SYSSTAT

    Oracle's system level statistics is very useful for performance track. Oracle keep on add new statistics from Oracle 8, 8i, 9i, 10g to 11g. The key is how to display the statistics value. SQL> SELECT name, value FROM...

Posted on November 27, 2007 8:23 PM

Track Oracle database performance with oramon utility

    I am writing an Oracle performance tracking utility -- oramon. And I have finished the first version of it, to make it more powerful, I compiled a windows version binary for free download. What this utility do is...

Posted on October 15, 2007 10:50 PM