Home » Developer & Programmer » JDeveloper, Java & XML » BFILE CLOSURE WAIT EVENT (11G AIX 6.1 XMLDB)
BFILE CLOSURE WAIT EVENT [message #605583] Sat, 11 January 2014 03:00
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
INSERT
INTO XML_DEFAULT
(
XML_DOC,
last_updated_date,
last_updated_by,
created_date,
created_by,
static_id,
DOC_ID,
app_id,
requestor_id,
doc_type
)
VALUES
(
XMLType(bfilename('XMLDIR_NEW',:v0), nls_charset_id('AL32UTF8')),
sysdate,
:v1,
sysdate,
:v2,
:v3,
:v4,
:v5,
:v6,
:v7
)

On some days the Tibco Application inserting XML database using the above statement times -out and the wait event that is displayed in OEM tool is BFILE CLOSURE.
It tells me suddenly 99% of the time is being spent on BFILE CLOSURE Wait Event.

I just cant do anything and the only way application returns to normalcy is by bouncing the database.

What can be done to alleviate the wait event of BFILE CLOSURE WAIT EVENT.
My Session_MAX_OPEN_FILES PARAMETER IS 20.
Previous Topic: XML issue
Next Topic: How to start Learning
Goto Forum:
  


Current Time: Thu Mar 28 11:16:17 CDT 2024