PEFSTAT dropped and recreated [message #243234] |
Wed, 06 June 2007 10:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 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
|
|
|