Home » RDBMS Server » Server Administration » configure perfstat
icon2.gif  configure perfstat [message #266731] Tue, 11 September 2007 09:01 Go to next message
oso_togari
Messages: 2
Registered: September 2007
Junior Member
Hi all!

i trying to configure perfstat to save stadistics for only the last month.
The tools tablespace is growing day by day.
anybody knowns how?

thx
Re: configure perfstat [message #266733 is a reply to message #266731] Tue, 11 September 2007 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing to configure, you have to do it by yourself.
sppurge.sql and sptrunc.sql are there to help you.

Regards
Michel
Re: configure perfstat [message #266908 is a reply to message #266733] Wed, 12 September 2007 00:02 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Follow Michel Cadot's advice:

Below is an example using "sppurge":
SQL> show user;
USER  "PERFSTAT"
SQL> @?/rdbms/admin/sppurge;


Database Instance currently connected to
========================================

                                Instance
   DB Id    DB Name    Inst Num Name
----------- ---------- -------- ----------
 3523678496 PNET              1 pnet


Snapshots for this database instance
====================================

                               Base-  Snap
 Snap Id   Snapshot Started    line? Level Host            Comment
-------- --------------------- ----- ----- --------------- --------------------
       1  12 Set 2007 01:13:31           6 SERVER2003R2
      13  12 Set 2007 01:15:54           6 SERVER2003R2
      14  12 Set 2007 01:15:57           6 SERVER2003R2
      15  12 Set 2007 01:16:00           6 SERVER2003R2
      16  12 Set 2007 01:16:03           6 SERVER2003R2
      17  12 Set 2007 01:16:05           6 SERVER2003R2
      18  12 Set 2007 01:16:07           6 SERVER2003R2


Warning
~~~~~~~
sppurge.sql deletes all snapshots ranging between the lower and
upper bound Snapshot Id's specified, for the database instance
you are connected to.  Snapshots identified as Baseline snapshots
which lie within the snapshot range will not be purged.

It is NOT possible to rollback changes once the purge begins.

You may wish to export this data before continuing.


Specify the Lo Snap Id and Hi Snap Id range to purge
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Informe o valor para losnapid:


Type losnapid (LOW snap_ID)... then type hisnapid (HIGH snap_ID). This is a range of snapshot that will be pruged. Read the warning below.

Regards,


mson77
icon14.gif  Re: configure perfstat [message #266974 is a reply to message #266731] Wed, 12 September 2007 02:31 Go to previous message
oso_togari
Messages: 2
Registered: September 2007
Junior Member
THX!!! Razz

now, i have to do a modification of sppurge to do a job for drop periods of time, isn't it?

thanks to both!
Previous Topic: Oracle 10g Parameters (Performance related)
Next Topic: ORA - 01000 "maximum open cursors exceeded " error in Oracle9i...?
Goto Forum:
  


Current Time: Mon Dec 05 02:49:12 CST 2016

Total time taken to generate the page: 0.04457 seconds