Re: How to find out the original SQL resulted the ERROR message?

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

Other related posts: