Home » RDBMS Server » Server Administration » Old Statspack Snap (oracle 12c Windows 2012)
Old Statspack Snap [message #667197] Thu, 14 December 2017 05:04 Go to next message
muthukrish104
Messages: 17
Registered: November 2017
Junior 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 Go to previous messageGo to next message
John Watson
Messages: 7220
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 #667210 is a reply to message #667198] Fri, 15 December 2017 00:19 Go to previous messageGo to next message
muthukrish104
Messages: 17
Registered: November 2017
Junior Member
Hi John,

Thanks for the reply.

I was trying in the way of.

sql>@C:\ORACLE\ORA12C\HOME\DBS\RDBMS\ADMIN\spreport.sql

So, when I enter, this will show all the lists of snapid.

But, that didn't show all (I had used SET PAGESIZE 999 and SET LINESIZE 999).

But with this STATS$ view, I am able to see all.

Regards
Binoj
Re: Old Statspack Snap [message #667211 is a reply to message #667210] Fri, 15 December 2017 00:28 Go to previous message
muthukrish104
Messages: 17
Registered: November 2017
Junior 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
Previous Topic: which one should be install first
Next Topic: Recovery of deleted table
Goto Forum:
  


Current Time: Sun Jan 21 06:02:28 CST 2018

Total time taken to generate the page: 0.01326 seconds