Can I Generate Snapshots Automatically?

1.	Can I Generate Snapshots Automatically?
Answer» Check the files for errors during the installation. sqlplus SQL>connect perfstat/perfstat SQL>@?/rdbms/admin/spauto.sql Prerequisite: job_queue_processes > 0 This SETS up an automatic JOB in the database that generates a SNAPSHOT every HOUR. Check the files for errors during the installation. sqlplus SQL>connect perfstat/perfstat SQL>@?/rdbms/admin/spauto.sql Prerequisite: job_queue_processes > 0 This sets up an automatic job in the database that generates a snapshot every hour.

Answer»

Check the files for errors during the installation.

sqlplus

SQL>connect perfstat/perfstat

SQL>@?/rdbms/admin/spauto.sql

Prerequisite: job_queue_processes > 0

This SETS up an automatic JOB in the database that generates a SNAPSHOT every HOUR.

Check the files for errors during the installation.

sqlplus

SQL>connect perfstat/perfstat

SQL>@?/rdbms/admin/spauto.sql

Prerequisite: job_queue_processes > 0

This sets up an automatic job in the database that generates a snapshot every hour.

Discussion