From oracle-l-bounce@freelists.org Tue Oct 4 10:35:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94FZKf0016227 for ; Tue, 4 Oct 2005 10:35:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j94FZHvX016210 for ; Tue, 4 Oct 2005 10:35:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AABD21F1E28; Tue, 4 Oct 2005 10:34:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25777-06; Tue, 4 Oct 2005 10:34:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2E291F1D26; Tue, 4 Oct 2005 10:34:32 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Y6YWSeJAEgwATyD8uihgxBXjKCqVZbKBdJe6V0tY6vF/vRG+8mWaXmEu9CM7ZBWfDOrAADnSzfWZdPRpnk/uss5oddIXw23ISCbbdQqgr0dmKUutvohhQaG9gIuhvRjkx3feq1leM6a27YNFoER8YPEYL/ZRv1en3gLV5bovaHU= ; Message-ID: <20051004153232.3119.qmail@web8506.mail.in.yahoo.com> Date: Tue, 4 Oct 2005 16:32:32 +0100 (BST) From: arun chakrapani rao Subject: RE: No data in the sql_address column of v$session To: oracle-l@freelists.org, Christian Antognini In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 26272 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: arunrao_oradba@yahoo.co.in Precedence: normal Reply-To: arunrao_oradba@yahoo.co.in X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Chris Thanks for sharing the info But when u are waiting on a latch free on shared pool dont u think there should be an sql_address to it. When a session is active, in the sense that he has a transaction then i thought he should have an sql_addresss, but based on the below information u can see that there is no sql_address nor hash value. this is what is bugging me sid username sql_address event ------------------------------------ 7507 ODSAPP 00 latch: library cache SID SQL_ADDRESS SQL_HASH_VALUE EVENT TADDR ----- ---------------- -------------- ----------------------------------- ---------------- 5408 00 0 latch: shared pool C00000057511FC78 --- Christian Antognini 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