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: 46
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
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.
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: 46
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.
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...
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Problem in QUICK TUNE advisor
Next Topic: Limiting the resources for specific User
Goto Forum:
  


Current Time: Sat Dec 03 15:51:33 CST 2016

Total time taken to generate the page: 0.14502 seconds