Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Statspack and spreport.sql

    When I run the the spreport.sql and it gives me a name for the output file,
    where does it go?
    I cannot find it.

  2. #2
    Join Date
    Jul 2003
    should be in the directory you logged into sqlplus from
    (assuming you logged into commandline from the host)

    possible other locations: $ORACLE_HOME/rdbms/admin
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jun 2004
    Provided Answers: 1
    Another possible location is within a qpstage directory somewhere on you hard drive.

    Try doing a search for *.lst, as this is the file extension for the reports (Although, of course, if you really have searched for the report you would have tried this already).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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