OraFAQ Forum: Performance Tuning » Question about PERFSTAT Tablespace

Home » RDBMS Server » Performance Tuning » Question about PERFSTAT Tablespace

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

Question about PERFSTAT Tablespace [message #165254]

Wed, 29 March 2006 01:31

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi all,

we just collecting Snapshots in one of our most frequented database. As far as I know the results are written in the tables in PERFSTAT. Now I delete a big amount of snapshots with sppurge.sql, but the used space in PERFSTAT will not go down.
Is there any way to delete the data without deleting from any table ?

kind regards
Uwe

Report message to a moderator

Re: Question about PERFSTAT Tablespace [message #165266 is a reply to message #165254]

Wed, 29 March 2006 02:41

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi,
The tables in perfstat are just like any other DB tables. They have a High Water Mark HWM which is the last block to where data was written. If you have purged data this HWM does not move. This HWM can be lowered by

1 - truncating the table(s)
2 - rebuilding

I think.

rgs

Alan

Report message to a moderator

Re: Question about PERFSTAT Tablespace [message #165269 is a reply to message #165254]

Wed, 29 March 2006 03:00

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi Alan,

I tjhought if you have an Script, which works a longer time (around 5 mins for 250 snapshots) it does something in the tables .... but not really deleting.
Okay, than I humst reor all tables by hand or by scheduled job.

thanks
Uwe

Report message to a moderator

Re: Question about PERFSTAT Tablespace [message #165272 is a reply to message #165269]

Wed, 29 March 2006 03:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Quote:

Okay, than I humst reor all tables by hand or by scheduled job.

Why? So it can expand again? Seems like a waste of time and resources. Accept the fact that statspack-data occupies space.

Report message to a moderator

Previous Topic:	oracle solaris tuning kernel
Next Topic:	Balanced Decision on Index Creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 03:51:21 CDT 2025