RE: No data in the sql_address column of v$session

From: arun chakrapani rao <arunrao_oradba_at_yahoo.co.in>
Date: Fri, 7 Oct 2005 15:16:07 +0100 (BST)
Message-ID: <20051007141608.58845.qmail@web8508.mail.in.yahoo.com>

Gurus,

Just wanted to share the information.
this is a bug in 10g which is fixed in 10.2 and there is no one off patch for the current version.

thanks
Arun

• Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:

> Arun
>
> >I am querying the v$session to get the sql_address
> of
> >some sessions who are generating high redo.but
> before
> >even going there i am seeing this weird output from
> >v$session where there is no value in sql_address
> and
> >henceforth i cannot know what sql these sessions
> are
> >running.
>
> According to the fine manual SQL_ADDRESS is "Used
> with SQL_HASH_VALUE to identify the SQL statement
> that is currently being executed". Since those
> sessions are not executing a SQL statement, but
> waiting on the client, this is the expected
> behavior.
>
> HTH
> Chris
>
> New Features Oracle Database 10g Release 2 seminars
> @ www.trivadis.com
> Italiano: Lugano (24-Nov)
> Français: Genève (17-Nov)
> Deutsch: Hamburg (13-Oct), München (20-Oct), Basel
> (25-Oct), Frankfurt (27-Oct),
> Zürich (29-Nov), Bern (8-Nov), Düsseldorf
> (23-Nov), Stuttgart (13-Dec)
>
                

---

Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 07 2005 - 09:31:40 CDT