SELECT B.USERNAME, B.SID, B.SERIAL#, A.EVENT,
A.TOTAL_WAITS,
A.TOTAL_TIMEOUTS, A.TIME_WAITED, A.AVERAGE_WAIT
FROM V$SESSION_EVENT A, V$SESSION B
WHERE A.SID = B.SID
ORDER BY 1;
--- Andi Afandi <[EMAIL PROTECTED]> wrote:
> Dear all friends,
>
> Here is the problem.
> My database becoming slow because there is a high
> process as it said on OEM.
> My question:
> How to monitor which process and which sid or
> serial# that running the high process..??
> Please.....
>
> Regard,
>
> Afandi
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them
> fast with Yahoo! Search.
>
> [Non-text portions of this message have been
> removed]
>
>
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
