Siebel Remote : Database Extract Poor Performance on ZFS (Doc ID 2302762.1)

Last updated on AUGUST 30, 2017

Applies to:

Siebel CRM - Version 8.1.1.10 [23021] and later
Oracle Solaris on x86-64 (64-bit)

Symptoms

Database Extract is taking 6-8 hours to complete and lock is acquired for almost 8 hours .  Siebel is running on ZFS FileSystem on solaris .

The following is a snippet of database extract log .

GenericLog GenericDetail 4 0033dc50596e2346:0 2017-08-02 18:16:58 Get exclusive Lock for tall/skinny database file of /app/remote1/sba81/siebsrvr/docking/SANTOTJ/dobjinst.dbf
GenericLog GenericDetail 4 0033dc50596e2346:0 2017-08-03 02:43:47 Release Exclusive Lock for tall/skinny database file of /app/remote1/sba81/siebsrvr/docking/SANTOTJ/dobjinst.dbf

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