Thanks for everyone's suggestions.
Hopefully I'll get some time next week to look at the figures.
Craig Healey
**
This email and any files transmitted with it are confidential and intended solely
for the use of the
on.com> cc:
Sent by: Subject: Re: Which session is killing
performance?
[EMAIL PROTECTED]
believe you can if you use performance monitor and chart by thread.
>
> Rick
>
>
>
>
> "Igor Neyman"
>
> ptron.com> cc:
> Sent by: Subject: Re: Which
eyman"
ptron.com> cc:
Sent by: Subject: Re: Which session is killing
gt; Or if you have the PID, launch Toad, and get the Trace/Kill view and
filter
> it for the PID, it will show you the SQL in the bottom pane. Much quicker
> with TOAD.
>
> Regards :
>
> Ferenc Mantfeld
>
> -Original Message-
> From: Craig Healey [SMTP:[EMAIL PROTECTE
erenc Mantfeld
-Original Message-
From: Craig Healey [SMTP:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 1:40 AM
To: Multiple recipients of list ORACLE-L
Subject:Which session is killing performance?
Newbie question time:
We have 8.1.7 running on Win 2000 with about 50 users.
One simple, and often helpful, option is to
query v$sess_io
Structure:
sid,
block_gets,
consistent_gets,
physical_reads,
block_changes,
consistent_changes
Look for any big numbers - if they are in
physical_reads, the user may have been
hammering the filesystem, the other figure
Title: RE: Which session is killing performance?
HI Craig, try these scripts
set linesize 200
column username format a15
column idle format a10
column machine format a22
column terminal format a15
column program format a15
select sid,
serial#,
username,
-- process
Newbie question time:
We have 8.1.7 running on Win 2000 with about 50 users. The system has
just slowed down dramatically for about 5 minutes, with lots of user
complaints. I suspect one of the developers was loading data or doing
some DML. But how do I find who it is? I found a small piece of cod