Aug 4 2008, 07:46 PM
I am getting the ora-1555 in alert log with Sql id,Query Duration in seconds & the SCN, with the complete SQL.
Here there are no trace file is getting generated after ora-1555. so is there any workaround anybody can suggess?
Aug 4 2008, 07:58 PM
What information do you need? And what Oracle version? You can use dba_hist_sqltext to look at the text of the sql statement if you have the sql id and Oracle 10g or above.
Aug 5 2008, 04:56 AM
"is there any workaround anybody can suggess?"
See details here:http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm