DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Utlbstat & Utlestat

  1. #1
    Join Date
    Jun 2002
    Posts
    88
    Hi,

    when i run Utlbstat & Utlestat in which directory report.txt is
    there.

    Thanks in advance,

    Regards,
    Iyyappan.M

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Most of the times it is in $ORACLE_HOME/../BIN/report.txt

    If path of the spool file is not altered in UTLESTAT.SQL file

    Sameer

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Usually in utlestat.sql spool file name is mentioned without path, In unix the file goes to your working directory, i.e. the directory from where you invoked sqlplus to run utlestat.sql

    And in Windows it goes to $O_H\bin

    HTH
    Sanjay

    [Edited by SANJAY_G on 07-22-2002 at 12:29 AM]

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If you are using 8i why not try using STATSPACK. It has more functionality than UTLBSTAT/UTLESTAT and it allows you to keep a history of results. See:

    http://www.oracle-base.com/Articles/8i/Statspack8i.asp

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  5. #5
    Join Date
    Jun 2002
    Posts
    88

    How to use StatsPack...

    Hi Tim,

    Thanks for ur reply. We are using Oracle9i.

    How to use Statspack in my database, any step by step procedure is there?

    Thanks in advance,

    Regards,
    Iyyappan.M

  6. #6
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    This is not for version 9i

    But this will give you what is STATPACK and How to use it.. Its for 8i 8.1.6.. just to get to know about STATPACK..

    http://www.oracle.com/oramag/oracle/...ml?o20tun.html


    Sameer

  7. #7
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    STATSPACK is virtually the same for 8i and 9i.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width