| statspack [message #301847] |
Fri, 22 February 2008 00:12  |
sheldon1982
Messages: 59
Registered: February 2008
Location: india
|
Member |
|
|
Hi Experts,
i need to knw that can we know the days before reports of the database or days before statistics can be generated using ststspack report???
Thanks,
Daniesh
|
|
|
|
|
|
| Re: statspack [message #301860 is a reply to message #301847] |
Fri, 22 February 2008 00:45  |
sheldon1982
Messages: 59
Registered: February 2008
Location: india
|
Member |
|
|
|
you mean to say for that day . suppose i need the reports for 2 days before. if i generated the statspack report today then will it possible to get the report for that day???
|
|
|
|
|
|
| Re: statspack [message #301893 is a reply to message #301847] |
Fri, 22 February 2008 03:24 |
sheldon1982
Messages: 59
Registered: February 2008
Location: india
|
Member |
|
|
thank you
i got it
one more question when i fired this command
select snap_id , snap_time from stats$snapshot;
i didnt get any snap id of 14th feb (the day whic i am looking for) that means we will not be able to get snapshot of that particular day.if i want my snapshot should produce automaticallty. i think for this we have to configure spauto.
Thanks,
Daniesh
|
|
|
|
| Re: statspack [message #301911 is a reply to message #301893] |
Fri, 22 February 2008 04:30 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
This is correct, you have to execute spauto.sql (maybe after modifying the frequency as er your need, read the file).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
