Re: Currently executing SQL statment

>
>select t.sql_text
>from v$sqltext t, v$session s
>where s.sql_address = t.address
>and s.process = <client program pid>
>order by t.piece;
>
>
> Alvin W. Law ........................................... Oracle Corporation
> Senior Technology Consultant ............... 300 Oracle Parkway, Box 659305
> Applications Design & Architecture ............... Redwood Shores, CA 94065
> Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294

-- 

Where is the v$sqltext table (view)?  I cannot find it in my instance.  I try 
a DESC V$SQLTEXT as SYS, SYSTEM, ORACLE and nothing.  Where is this 
table(view) created (what script)?

thanks,



Glenn Travis
DBA  (Ingres/Oracle/Sybase)
Circuit City Stores, Inc.
Richmond, VA  USA
gtravis_at_richmond.infi.net
gtravis_at_aol.com