OraFAQ Forum: Server Utilities » Statspack report in windows and linux

Home » RDBMS Server » Server Utilities » Statspack report in windows and linux (Oracle 9i/10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Statspack report in windows and linux [message #492474]

Mon, 31 January 2011 06:41

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

Report message to a moderator

Re: Statspack report in windows and linux [message #492478 is a reply to message #492474]

Mon, 31 January 2011 07:18

John Watson
Messages: 8966
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,

Report message to a moderator

Re: Statspack report in windows and linux [message #492483 is a reply to message #492478]

Mon, 31 January 2011 08:16

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

Report message to a moderator

Re: Statspack report in windows and linux [message #492485 is a reply to message #492483]

Mon, 31 January 2011 08:22

cookiemonster
Messages: 13966
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?

Report message to a moderator

Previous Topic:	Terminators and datafile of sql loader
Next Topic:	Objects gets invalid during import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 21:19:12 CST 2025