Thanks, Jonathan.
- Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
wrote: >
> Either join works:
>
> v$session.addr = v$transaction.ses_addr
> v$session.taddr = v$transaction.taddr
>
>
> Session 165:
> update t1 ... where pk_col = 99;
> select to_char(sysdate,'hh24:mi') from dual;
> time for 4-hour lunch break
> session waits for message from client
>
> Session 266
> update t1 ... where pk_col = 99;
> session waits for TX enqueue mode 6
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick
> Jr
>
>
> Next public appearances:
> March 2004 Hotsos Symposium - The Burden of Proof
> March 2004 Charlotte NC OUG - CBO Tutorial
> April 2004 Iceland
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK___February
> ____UK___June
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Post your free ad now!
http://personals.yahoo.ca
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Feb 09 2004 - 13:26:03 CST