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

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?

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

See details here:
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-2015 Invision Power Services, Inc.