OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ora 01555

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora 01555 [message #273583]

Thu, 11 October 2007 00:56

risy_s
Messages: 44
Registered: September 2005
Location: Mumbai

Member

hi...

i m getting snapshot too odd error....

SQL> sho parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_tablespace string UNDOTBS1

i have seen alert log file it is showing....

ORA-01555 caused by SQL statement below (SQL ID: 2rfuda92ra49h, Query Duration=268 sec, SCN: 0x0000.00fcf3bc):

This error is saying that the abov query is taking only 268 sec to run but my u can see the that undo_retention period is 3 hour...

i have also did this....
SQL> select max(MAXQUERYLEN) from v$undostat;

MAX(MAXQUERYLEN)
----------------
3076
my udno tablespace is still 50 % free.. so there is no space issue...

can anybody tell what is the problem and how can i resolve it

Report message to a moderator

Re: ora 01555 [message #273612 is a reply to message #273583]

Thu, 11 October 2007 01:33

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle version?

Undo retention is not guaranted prior to 10g and is still not by default in 10g.

Regards
Michel

Report message to a moderator

Re: ora 01555 [message #273615 is a reply to message #273612]

Thu, 11 October 2007 01:37

risy_s
Messages: 44
Registered: September 2005
Location: Mumbai

Member

sorry for the incomplite info...

oracle version 10.2.0.2
os hp-ux

plz reply its urgent

Report message to a moderator

Re: ora 01555 [message #273629 is a reply to message #273615]

Thu, 11 October 2007 02:17

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Nothing is urgent in forum but reading OraFAQ Forum Guide
2/ German postal code is irrelevant here
3/ I already answered the question you can easily fix it if you carefully read the answer.

Regards
Michel

Report message to a moderator

Previous Topic:	Long Read Time
Next Topic:	Updaing a 804 million partioned table (for 365 days) from a 67 million table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 25 20:06:06 CDT 2024