| Statspack-Urgent [message #65408] |
Sat, 11 September 2004 09:43  |
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  |
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 |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
