v$session and ASH sql_id showing pipelined sql or begin..end only
- From: Laimutis.Nedzinskas@xxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Jul 2010 16:58:40 +0300
Hi,
I think I am not alone to get sql_id from ASH or v$session which shows only
PL/SQL block BEGIN....END; or sql from pipelined function select ... from
table(some_pipelined_function);
Is there some work arround for this issue ? One wants to see what sql
oracle is really executing but not this wrapper (kind of)
I personally use v$sql, longops, v$open_cursor etc to get topmost sql'is
but this is far from ideal. Any better ideas ?
Thank you in advance, Laimis N
---------------------------------------------------------------------------------
Please consider the environment before printing this e-mail..
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » v$session and ASH sql_id showing pipelined sql or begin..end only - Laimutis . Nedzinskas
