Trace files of large sizes are getting generated
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Nov 2009 20:46:18 +0530
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
Other related posts:
