Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select from V$OPEN_CURSOR chronologically ordered ?

Re: Select from V$OPEN_CURSOR chronologically ordered ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 04 Mar 2005 19:49:16 +0100
Message-ID: <9bbh21hqkss3ce5mfnjqmuk6v7ind7milh@4ax.com>


On 4 Mar 2005 03:11:33 -0800, spendius_at_muchomail.com (Spendius) wrote:

>Hi,
>The following SELECT returns me all cursors opened by a session,
>with the string "current" in front of the statement currently
>being executed:
>select
> st.address||st.hash_value n,
> decode(st.address||st.hash_value, sql_address||sql_hash_value, 'current'),
> st.sql_text
>from v$open_cursor oc,
> v$session s,
> v$sqltext st
>where s.sid = &&1
> and oc.sid = &&1
> and oc.address = st.address
>order by st.address, st.hash_value, st.piece
>
>Do you think there's a way to get this displayed with a sort
>on some kind of timestamp stored somewhere in some obscure
>X$Kxxxx table to get it listed in the chronological sense of
>cursor openings ? I spent hours trying to figure out whether
>it's possible but to no avail. (I'm talking about 8i and 9i
>structures as well)
>
>Thanks.

V$sqlarea stores the time when the statement was first parsed. In the majority of third party apps, not using bind variables, this would provide the correct result.
Other than that: just trace the session and you will know.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Mar 04 2005 - 12:49:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US