Home » RDBMS Server » Performance Tuning » Statspack-Urgent
Statspack-Urgent [message #65408] Sat, 11 September 2004 09:43 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Hi, I have 2 prod instances running on one server. They both share the same ORACLE_HOME. My Question is can i run statspack on both the instances at the sametime. My problem is some of the sql's which run on instance1 connects to instance2 thru dblink. i want to get snapshots of the users(sessions) on both instances at the sametime.
Pls help
Sam
Re: Statspack-Urgent [message #65411 is a reply to message #65408] Mon, 13 September 2004 21:42 Go to previous messageGo to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Can anyone also tell me how to take a snapshot of session, and what if i cant take a second snap shot,cos i dont know when the user session ends.
Can u pls expalin with example or any helpful URL will be much appreciated
Sam.
Re: Statspack-Urgent [message #65412 is a reply to message #65411] Tue, 14 September 2004 20:45 Go to previous messageGo to next message
Deepa
Messages: 269
Registered: November 2000
Senior Member
to gather session statistics and wait events for a
particular session
execute statspack.snap(i_session_id=>3);
Re: Statspack-Urgent [message #65414 is a reply to message #65412] Tue, 14 September 2004 23:19 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
What i understand is u need to have atleast 2 snap shots for a report.
I am not sure how long the session is going to be active. Any other workaroung
Thanx in advance.
Previous Topic: URGET:-Query not performing well
Next Topic: which to tune first
Goto Forum:
  


Current Time: Thu Feb 29 10:02:40 CST 2024