| PEFSTAT dropped and recreated [message #243234] |
Wed, 06 June 2007 10:16  |
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
|
|
|
|
| Re: PEFSTAT dropped and recreated [message #243239 is a reply to message #243234] |
Wed, 06 June 2007 10:34  |
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 |
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.
|
|
|
|
|
|
| Re: PEFSTAT dropped and recreated [message #243249 is a reply to message #243244] |
Wed, 06 June 2007 10:48 |
 |
Michel Cadot
Messages: 68756
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
