Oracle Statspack

10 pts.
Tags:
Oracle 9
Oracle administration
Oracle Database
Oracle performance
Oracle statistics
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off and was yelled at quite thoroughly today because of the perceived extra load statspack put on the database. My mgr & director both think it puts extra strain on the database and that I either shouldn't run it at all or that I should wait till lighter load days like Friday or the weekend. I always thought that it did not affect performance at all and was a task that ran in the background. Am I misguided? Thanks for your input. James Wolff

Answer Wiki

Thanks. We'll let you know when a new response is added.

Any task or process could affect your server’s performance because it uses resources from the server, and statspack is not the exception, since it will probably increase disk i/o, memory usage and cpu usage.

How much it will affect your server’s performance depends on available resources and work load, among other things.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following