V$sql_plan did show some pq SQL, but it is very limited. For that SQL listed in alert log, I can't find the corresponding in v$sql_plan. Maybe query v$sql where sql_text like '%parallel%' is also an possible way, though sometimes table degree >1 will use parallel without hint. On 10/5/05, Lou Fangxin <anysql@xxxxxxxxx> wrote: > > Try to query the v$sql_plan where other_tag is not null, this will list > the query that parallel executed, then we need manually compare the sql. > > On 10/5/05, zhu chao <zhuchao@xxxxxxxxx> wrote: > > > > Sorry, pressed enter before finish the email. > > Sometimes we see some error message in alert, saying some SQL report > > ORA-1555. For example, the following SQL is logged in alert. > > Obviously it is not from normal application. I am wondering how I can > > find out the original SQL, so I contact with developer for this. > > Another SQL like: > > ARC1: Completed archiving log 4 thread 1 sequence 9781 Tue Oct 4 > > 22:07:31 2005 > > ORA-01555 caused by SQL statement below (SCN: 0x0000.e3a53f18): > > Tue Oct 4 22:07:31 2005 > > SELECT /*+ Q109000 NO_EXPAND ROWID(A1) */ A1.ROWID FROM > > "BES1"."EXCEPTION" PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1 WHERE > > A1."CONSUMER_ID"='KenanToSiteProcessor' > > AND A1."CREATION_DATE">=TO_DATE('2005-09-29 00:00:00', 'yyyy-mm-dd > > hh24:mi:ss') > > AND A1."CREATION_DATE"<=:B1 AND A1."EXCEPTION_STATUS"=3 AND > > A1."EXCEPTION_REASON" LIKE '3501 DATA_SOURCE_DOWN%' > > Tue Oct 4 22:12:34 2005 > > This is the spawned from some PQ query. If PQ process has exit, or not > > running any more, can we still find out the original SQL? > > Thanks > > On 10/5/05, zhu chao <zhuchao@xxxxxxxxx> wrote: > > > > > > Hi, All, > > > > > > ORA-01555 caused by SQL statement below (SCN: 0x0314.01fa70b6): > > > Mon Oct 3 18:52:31 2005 > > > SELECT /*+NESTED_TABLE_GET_REFS+*/ "FDBK_USER"."TRANSACT_RECORD".* > > > FROM "FDBK_USER"."TRANSACT_RECORD" where trx_type=1 > > > > > > -- > > > Regards > > > Zhu Chao > > > www.cnoug.org <http://www.cnoug.org/> > > > > > > > > > > > -- > > Regards > > Zhu Chao > > www.cnoug.org <http://www.cnoug.org/> > > > > > > -- > Welcome, Fangxin.Lou from China > Home: http://www.anysql.net/en/ > Mydul: http://www.anysql.net/en/mydmp.html > -- Regards Zhu Chao www.cnoug.org <http://www.cnoug.org>