Home » RDBMS Server » Server Utilities » Statspack report in windows and linux (Oracle 9i/10g)
Statspack report in windows and linux [message #492474] Mon, 31 January 2011 06:41 Go to next message
kumasudh
Messages: 14
Registered: August 2010
Junior Member
Hello Gurus,

I am in need of collecting statspack report programatically in windows and linux. Could somebody please help me with any existing example ?

Thanks
Best Regards
kumasudh
Re: Statspack report in windows and linux [message #492478 is a reply to message #492474] Mon, 31 January 2011 07:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I'm not sure what you mean by "collecting a statspack report". But you can collect a staspack snapshot with statspack.snap, and you can generate a staspack report with code called in spreport.sql,
Re: Statspack report in windows and linux [message #492483 is a reply to message #492478] Mon, 31 January 2011 08:16 Go to previous messageGo to next message
kumasudh
Messages: 14
Registered: August 2010
Junior Member
Hi John,

Thanks for the reply. I am sorry for not putting the question clearly. I wanted to put the following statements into a tmp.sql file and execute this tmp.sql in a *.bat file.

SQL> connect perfstat/my_perfstat_password
SQL> define begin_snap=1
SQL> define end_snap=2
SQL> define report_name=batch_run
SQL> @?/rdbms/admin/spreport

My only concern is how to get the begin snap ID and end snap ID while preparing the tmp.sql file.

Regards
Re: Statspack report in windows and linux [message #492485 is a reply to message #492483] Mon, 31 January 2011 08:22 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why don't you open up spreport.sql and see what query it runs to get the list of snapshots?
Previous Topic: Terminators and datafile of sql loader
Next Topic: Objects gets invalid during import
Goto Forum:
  


Current Time: Fri Mar 29 03:08:03 CDT 2024