Home » RDBMS Server » Server Administration » ORA-01555 (9.2.0.6.0)
| ORA-01555 [message #386520] |
Sun, 15 February 2009 23:45  |
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,
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Jul 05 05:19:02 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
