| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack archiving
Steve
So . . . are you going to share the details? Which tables and what order to delete rows? How often are you generating statistics? Are you using the Oracle-supplied "statsauto" command? What are you using to generate reports? What are your goals for the continual monitoring? Thanks for any details you are willing to share with the group.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, August 06, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
I reverse engineered the statspack data model. Using this I just delete rows from specific tables and maintain different retention times based some perceived need. You'll want to monitor and rebuild the indexes often. To keep statspack data maintenance from becoming a resource spike I just delete data daily and rebuild indexes weekly.
Steve Orr
-----Original Message-----
Sent: Tuesday, August 06, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L
Lee - Just in case you were recalling a comment that I made, I'll repeat it.
To clear some or all STATSPACK statistics, I have had good luck deleting
from STATS$SNAPSHOT. It appears that the other STATSPACK tables populated by
taking snapshots are connected by relations such that deleting from
STATS$SNAPSHOT also cleans up those tables. I have also had success deleting
a range of snapshots. You might want to do this to keep the more recent
snapshots while clearing older snapshots. A word of warning: Because so many
tables are related to STATS$SNAPSHOT, deleting can be VERY slow. On my
system it seems to average about a row/minute.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, August 06, 2002 4:23 AM
To: Multiple recipients of list ORACLE-L
Guys,
Oracle 8.0.5
I am sure a short time ago, someone posted a method of effectively archiveing off statspack information in order to keep the tables at a reasonable size and to ensure that the info is removed from the tables in an orderly fashion.
Anyone still got a hold of this mail or is the original author in a generous mood and fancies posting it again.
TIA Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 06 2002 - 10:38:54 CDT
 |
 |