Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to trace a session in MTS (8iR3)
Hello, fellows!
First of all, congratulations for the high sound to noise ration in this
list. I've no doubt it's the best one I've ever participated.
My doubt:
I've been working for the last four years with 8i and 9i, always configured
to dedicated connections. Nowadays, in my new job, I'm playing for the 1st
time with MTS in 8iR3.
We have a very big HPUX box (12 CPUs) and during the whole day the top CPU processes are in the format 'ora_sNNN_dbname'. I noticed that these processes have different multiple sid/serial# in different times. How do I trace what these processes are doing to consume a lot of CPU? What do you use to do when facing a scenario like that?
Taking a session-to-processes look, I noticed that the same session (SID) has different SPID in v$processes during its lifecycle. So, when people call me saying that a reporting is longing more than 10 times the usual time, how do I trace that specific session in MTS?
Have you a nice day!
Thanks in advance,
Luis
from Brazil
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 13 2005 - 20:19:16 CDT
![]() |
![]() |