DBA Tools

How to Anayze Oracle Performance Data, Lession Two

    Oracle give use lots of performance views, not only for database only, but also some important data about the applications. As a DBA we should analyze those data, and show the data to others. For example, how to...

Posted on May 10, 2009 10:04 PM

How to Anayze Oracle Performance Data, Lession one

    Oracle give use lots of performance views, not only for database only, but also some important data about the applications. As a DBA we should analyze those data, and show the data to others. For example, the SQL...

Posted on May 9, 2009 5:53 PM

Compute statistics when creating index will analyze table in Oracle 9i

    I have a table named "T_OBJECTS" and one index on it named "T_OBJECTS_IX1". They are not analyzed now: TABLE_NAME       NUM_ROWS LAST_ANALYZED -------------- ---------- --------------- T_OBJECTS T_OBJECTS_IX1     Now I receive a task to create a second index...

Posted on October 10, 2007 5:15 PM

Analyze or DBMS_STATS, choose one but don't mix them

    I am not so familiar with the DBMS_STATS procedure, so I always use the "ANALYZE" command. One day I got the following problem. Let's start a demo, first step is creating demo partitioned table. SQL> CREATE TABLE T_PARTDEMO(...

Posted on September 29, 2007 12:37 PM