PDA

View Full Version : track session activity

T
09-14-2005, 03:20 AM
I started Enterprice Manager Console and connected to oracle 9.2.0.4. and
found one session consuming 80% process time.
i didn't found latter data about this process :
Username
OS User
Machine Name
Program
Counsumer Group


Does anybody know what this process is doing, and how can i see what. Is it
oracle backgroud process, and why when i kill that session nothing happens
to database? (Nothing visual)

Many thanks!
IANAL_VISTA
09-14-2005, 05:50 AM
"T" <t@yahoo.com> wrote in news:dg914j$m5o$1@ss405.t-com.hr:
I started Enterprice Manager Console and connected to oracle 9.2.0.4. and found one session consuming 80% process time. i didn't found latter data about this process : Username OS User Machine Name Program Counsumer Group Does anybody know what this process is doing, and how can i see what. Is it oracle backgroud process, and why when i kill that session nothing happens to database? (Nothing visual) Many thanks!

enable SQL_TRACE at level 12

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service