Home » RDBMS Server » Performance Tuning » PEFSTAT dropped and recreated
- PEFSTAT dropped and recreated [message #243234] Wed, 06 June 2007 10:16 Go to next message
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
Member
Hi All,

I am not familiar with statspack and PERFSTAT. What is the worst thing that could happen if PEFSTAT is dropped and recreated on a production environment?

Thanks

Report message to a moderator

- Re: PEFSTAT dropped and recreated [message #243239 is a reply to message #243234] Wed, 06 June 2007 10:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
bacically when you run spcreate.sql it runs three another scripts internally.
spcusr= this script creates the perfstats user.
spctab=this script creates the table for report and insert some default values to those table using insert commands.
spcpkg=this script create ths package STATSPACK .


So when you run this package it will put some load on database
how when it would create tables and insertion into tables that an extra work.

Report message to a moderator

- Re: PEFSTAT dropped and recreated [message #243244 is a reply to message #243239] Wed, 06 June 2007 10:40 Go to previous messageGo to next message
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
Member
DreamzZ wrote on Wed, 06 June 2007 10:34
bacically when you run spcreate.sql it runs three another scripts internally.
spcusr= this script creates the perfstats user.
spctab=this script creates the table for report and insert some default values to those table using insert commands.
spcpkg=this script create ths package STATSPACK .


So when you run this package it will put some load on database
how when it would create tables and insertion into tables that an extra work.


Thanks, DreamzZ

So aside from the actual load it'll do while recreating the PERSTAT, there is no other bad impact it'll do about the database? I understand that with dropping and recreating PERFSTAT, all perfomance info and snapshots are also dropped... but I don't understand too well what is the implication of losing those information.

Report message to a moderator

- Re: PEFSTAT dropped and recreated [message #243248 is a reply to message #243244] Wed, 06 June 2007 10:47 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
hey read it...

Report message to a moderator

- Re: PEFSTAT dropped and recreated [message #243249 is a reply to message #243244] Wed, 06 June 2007 10:48 Go to previous message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No impact in the database, you just no more can analyze what was the performances in the past.
Before dropping the schema, export it then if you have to analyze the past statistics you can reimport them.

Regards
Michel

Report message to a moderator

Previous Topic: Problem in QUICK TUNE advisor
Next Topic: Limiting the resources for specific User
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 28 06:30:25 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.