Trace files of large sizes are getting generated
Date: Fri, 6 Nov 2009 20:46:18 +0530
Hope Every one is doing a great job.
I have a issue in one of my database, Where in I see trace files of 4mb's are getting generated but previous to that it was not like that the size it used to be of 3kb.
Due to this the database got hunged and we need to reboot and delete the contents of dump directories.
I could see in the trace files as
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-22288: file or LOB operation FILEOPEN failed
Current SQL statement for this session:
DECLARE iCount NUMBER :=1;
L_SOURCE_DIR'); COMMIT; EXCEPTION WHEN OTHERS THEN PKG_DEBUG.stp_SetDebugState(TRUE, FALSE, TRUE);
PKG_DEBUG.STP_OUTPUT ('Loading of File Story Cmpny Relation failed');
RAISE; END; Your help will be highly appreciated.
NileshReceived on Fri Nov 06 2009 - 09:16:18 CST