Home » RDBMS Server » Performance Tuning » statspack (oracle,8.1.7, unix)
statspack [message #301847] Fri, 22 February 2008 00:12 Go to next message
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 #301857 is a reply to message #301847] Fri, 22 February 2008 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes if you have statspack snapshots.

Regards
Michel
Re: statspack [message #301860 is a reply to message #301847] Fri, 22 February 2008 00:45 Go to previous messageGo to next message
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 #301861 is a reply to message #301860] Fri, 22 February 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, if you have statspack snapshots.
When you execute spreport.sql, it asks you the first and last snapshots it has to take into account.

Regards
Michel
Re: statspack [message #301893 is a reply to message #301847] Fri, 22 February 2008 03:24 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Temp tablespace resizing
Next Topic: Procedure slow in Oracle 10g
Goto Forum:
  


Current Time: Tue Dec 06 02:36:04 CST 2016

Total time taken to generate the page: 0.11069 seconds