Help - Search - Members - Calendar
Full Version: how to work on ORA-1555 occured with sql id.
Oracle DBA Forums > Oracle > Oracle Forum
parimal
Hi,

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?

Parry.
andrew kerber
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.
aussie_dba
"is there any workaround anybody can suggess?"

See details here:

http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.