Trace files of large sizes are getting generated
Date: Fri, 6 Nov 2009 20:46:18 +0530
Message-ID: <7877ab4b0911060716h5cf76563v77567591c4815075_at_mail.gmail.com>
Hello DBA's,
Good Afternoon!!
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
Permission denied
Current SQL statement for this session:
DECLARE iCount NUMBER :=1;
Status VARCHAR2(4);
BEGIN DB.stp_snr_ne_load_xml('NE_CMPNY_STORY_LINK_ST','200910240444NYT_____NEWS__
___387932_1490.3.xml','NEWSEDGEISSUE.xsl','NEWSEDGE_XML_SOURCE_DIR','NEWSEDGE_XS
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.
Thanks
Nilesh
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 06 2009 - 09:16:18 CST