Hello,
The sql_text that is there in v$sqltext is only 1000 chars wide, where as the text
field in dba_source is 4000 chars. long. How do I get the text from dba_source, as I
am not able to join that table with any other suitable table.
Any help/comments?
rgds,
raja
--
On Sun, 19 Aug 2001 17:15:30
Jon Walthour wrote:
>To find currently running sql, run the following query:
>
>SELECT a.username AS username
> , a.sid AS sid
> , a.serial# AS ser#
> , b.sql_text AS statement
> FROM v$session a
> , v$sqltext b
> WHERE a.username IS NOT NULL
> AND a.status = 'ACTIVE'
> AND a.sql_address = b.address
> AND a.sql_hash_value = b.hash_value
> AND a.audsid != USERENV('sessionid')
>ORDER BY sid
> , ser#
> , b.piece;
>
>To check out lots of scripts for tuning, look into Steve Adams' website
>at http://www.ixora.com.au.
>
>Jon Walthour
>-----Original Message-----
>Linsy
>Sent: Sunday, August 19, 2001 6:41 PM
>To: Multiple recipients of list ORACLE-L
>
>Hi, all
>
>How to find the currently running transaction,
>including user, sql_text, etc?
>
>Do you have any scripts for monitoring, tuning
>transactions?
>
>Thank you!
>
>Janet
>
>__________________________________________________
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo! Messenger
>http://phonecard.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Janet Linsy
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jon Walthour
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
