OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » configure perfstat

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

configure perfstat [message #266731]

Tue, 11 September 2007 09:01

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

Report message to a moderator

Re: configure perfstat [message #266733 is a reply to message #266731]

Tue, 11 September 2007 09:04

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: configure perfstat [message #266908 is a reply to message #266733]

Wed, 12 September 2007 00:02

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

Report message to a moderator

Re: configure perfstat [message #266974 is a reply to message #266731]

Wed, 12 September 2007 02:31

oso_togari
Messages: 2
Registered: September 2007

Junior Member

THX!!!

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

thanks to both!

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 14 06:48:52 CDT 2025