| Old Statspack Snap [message #667197] |
Thu, 14 December 2017 05:04  |
 |
muthukrish104
Messages: 82
Registered: November 2017
|
Member |
|
|
Hi All,
I am trying to get the last month's snapshot ID of the Statspack,
but the spreport.sql shows only the latest lists.
How do we get that snapid numbers.
Thanks and Regards
M.Krish
|
|
|
|
| Re: Old Statspack Snap [message #667198 is a reply to message #667197] |
Thu, 14 December 2017 05:16  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
The spreport.sql script should show all your snapshots, you can confirm this by looking the STATS$SNAPSHOT.
Perhaps you have a job that purges the older ones.
|
|
|
|
|
|
| Re: Old Statspack Snap [message #667211 is a reply to message #667210] |
Fri, 15 December 2017 00:28 |
|
muthukrish104
Messages: 82
Registered: November 2017
|
Member |
|
|
Hi,
One more question,
When I have generated a report with that SPREPORT.SQL, with start and end snapid. It works.
But, if I want to make a report again withe another SNAPID, it gives this error.
Hence I have to quit the SQLPLUS window, then reconnect. Which is horrible, if I want to take more than 10 reports.
End of Report ( Z:\Spool\Hourly_Basis\27nov_5pm-6pm.lst )
SQL> @C:\ORACLE\ORA12C\HOME\DBS\RDBMS\ADMIN\spreport.sql
SP2-0310: unable to open file "C:\ORACLEORA12CHOMEDBSRDBMSADMINspreport.sql"
Is there any way get rid of it.
Regards
M.krish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
