Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Statspack

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

March 30, 2009  9:41 PM

Changing Perfstat Job



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

I got a question about how I would change the Prefstat Statspack job in Oracle to run at 15 minute increments during the day when OLTP transactions are occurring and then change it to run only onve every hour during off hours while batch is running. Since the user already had the PL\SQL to change...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

February 2, 2009  4:18 PM

Oracle Statspack Help



Posted by: Colin Smith
Database, Oracle, Statspack

Recently I received an email from Ram. It said the following:

I am ram,I have a question regarding development DBA.I need to Optimize SQL and...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1