Home » RDBMS Server » Performance Tuning » Question about PERFSTAT Tablespace
Question about PERFSTAT Tablespace [message #165254] Wed, 29 March 2006 01:31 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 09:00:00 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.