Home » RDBMS Server » Server Administration » ORA-01555 (9.2.0.6.0)
ORA-01555 [message #386520] Sun, 15 February 2009 23:45 Go to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
Hi,

I received ora error in my alert log file.
ORA-01555 caused by SQL statement below (Query Duration=5093 sec, SCN: 0x0000.9bee4280):
Mon Feb 16 11:05:24 2009
SELECT JE_LINE_NUM,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,STAT_AMOUNT,DESCRIPTION,TRANSLATION_RATE,TRANSLATION_AMOUNT,USSGL_TRANSAC TION_CODE,SET_OF_BOOKS_ID,CODE_COMBINATION_ID,ROW_ID,STATUS,PERIOD_NAME,IGNORE_RATE_FLAG,EFFECTIVE_DATE,REFERENCE_1,REFERENCE_2,REFER ENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3, ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CONTEXT2,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE1 4,ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,CONTEXT3,TAX_CODE,INVOICE_DATE,INVOICE_IDENTIFIER,INVOICE_A MOUNT,NO1,TAXABLE_LINE_FLAG,TAX_TYPE_CODE,TAX_CODE_ID,TAX_ROUNDING_RULE_CODE,AMOUNT_INCLUDES_TAX_FLAG,TAX_DOCUMENT_IDENTIFIER,TAX_DOC UMENT_DATE,TAX_CUSTOMER_NAME,TAX_CUSTOMER_REFERENCE,TAX_REGISTRATION_NUMBER,TAX_LINE_FLAG,TAX_GROUP_ID,CONTEXT4,JGZZ_RECON_CONTEXT,JG ZZ_RECON_STATUS,JGZZ_RECON_DATE,JGZZ_RECON_ID,JGZZ_RECON_REF,JE_HEADER_ID,GLOBAL_ATTRI

Below are my actual undo_size and needed undo size.I noticed that my needed undo size is actually lesser from my actual undo size. Need idea why i received such error when my undo size can accommodate such query?




ACTUAL UNDO SIZE [MByte]
------------------------
UNDO RETENTION [Sec]
---------------------------------------------------------------------------
NEEDED UNDO SIZE [MByte]
------------------------
9216
1800
1123.42969

regards,

Re: ORA-01555 [message #386521 is a reply to message #386520] Sun, 15 February 2009 23:46 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

The SQL reported is the victim, not the cause of this error.

go to
http://asktom.oracle.com

& do keyword search on ORA-01555

[Updated on: Sun, 15 February 2009 23:48]

Report message to a moderator

Previous Topic: buffer cache (DML)
Next Topic: Encrypting passwords
Goto Forum:
  


Current Time: Sat Dec 03 09:54:35 CST 2016

Total time taken to generate the page: 0.07090 seconds