Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Perstat

1
March 31, 2009  4:36 PM

Perfstat Cron Jobs



Posted by: Colin Smith
Database, Database Administration, Oracle, Perstat, Statspack

Here is the update on changing the perfstat statspack job that I spoke of earlier. The question was how can I get statspacks to run every 15 minutes during OLTP and every 2 hours during batch. My thought is a Cron Job that will run the SQL for you. Just make a connection to the DB using SQLPLUS and...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1