Q
Problem solve Get help with specific problems with your technologies, process and projects.

How can I prepare an audit report using Statspack?

How can I prepare an audit report using Statspack?
To generate a report with Statspack, you can perform the following action in SQL*Plus:
SQL> @?/rdbms/admin/spreport
This script will prompt you for a beginning and ending snapshot and a resulting output file. After the script runs for a while, you will find the output in the text file you indicated.

The above assumes that you have been capturing snapshots with Statspack. If not, you will have to create a PERFSTAT user and then run the ?/rdbms/admin/spcreate script. That sets up the Statspack repository. To create a snapshot, then sign on as PERFSTAT and execute the following:

SQL> exec statspack.snap;

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close