Automate Statspack
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Automate Statspack

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Question Automate Statspack

    Hi All
    I have successfuly installed statspack and run few report manually. I would like to automate the statspack using dbms_job package.
    I have JOB_QUEUE_PROCESSES =10
    and JOB_QUEUE_INTERVAL=3600 in the init.ora. I am using Oracle 8.1.74. spauto.sql? How can I automate that?

    Any help will be appreciated.
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    The spauto.sql is an example file to automate Statspack. You could run the spauto.sql script as is or modify the script to your specific needs. Without any modifications, the script should gather stats every hour.

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Quote Originally Posted by ebrian
    The spauto.sql is an example file to automate Statspack. You could run the spauto.sql script as is or modify the script to your specific needs. Without any modifications, the script should gather stats every hour.
    ebrian
    Thanks for prompt response.
    You mean, once I run the spauto.sql it will run every hour without me reruning it?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    That is correct. Run the script as the STATSPACK owner (PERFSTAT).

    You can verify the job's attributes by querying DBA_JOBS.

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