Slow Performance During Server Side File Check Out (XFILE_CHK_OUT /SERVER) While Application Server and File Server Are on the Same Host (Doc ID 2012357.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------
On Agile e6.1.3.0

Find slow performance for server side file checkout, in case File Server is running on same host as Agile e6 application server.
Client side check out is up to 20 times faster

EXPECTED BEHAVIOR
--------------------------------
same performance for client and server side checkout

STEPS:
---------------------
1.) Test server side checkout:
  1. Create a document
  2. Check-in a file (for example "test.zip") should be > 4 MB
  3. Write a new LGV procedure BUG/fms_checkout
  Example for the "test.zip" file
  RES=@xfile_chk_out("C/SERVER=#SERVER /DISCPATH=/tmp /FILE=test.zip")
  4. Add the LGV procedure as select menu userexit to the menu EDB-DOC-FIL-RLS
  Userexit: lgv_sel_run
  Parameter: BUG/fms_checkout
  5. Restart the client to execute the customizing changes
  6. Search your document and switch to the file tab
  7. Select the file "test.zip"
  8. Execute the select menu selection which you have created to execute the LGV procedure

2.) Then perform interactive client check out

Compare checkout times - e.g. use file server log fms.log
Check lines like
  Status: Write to socket [10] [15523852 bytes] in 151.233795 seconds.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms