Essbase SQL/IF Data Load From an Oracle Database Takes Longer Using v11.1.2.4.004 Compared To v11.1.2.3.508 (Doc ID 2169491.1)

Last updated on AUGUST 09, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 to 11.1.2.4.009 [Release 11.1]
Information in this document applies to any platform.

Symptoms

An Essbase SQL/IF data load from an Oracle DB takes longer in v11.1.2.4.004 compared to v11.1.2.3.508

11.1.2.4.004:

[Wed Jun 29 11:41:25 2016]Local/GLRxxx/GLR/admin@Native Directory/140283779413760/Info(1003051)
Data Load Elapsed Time for [SQL] with [load.rul] : [1402.76] seconds

11.1.2.3.508:

[Wed Jun 29 15:04:24 2016]Local/GLRxxx/GLR/admin@Native Directory/140067957364480/Info(1003051)
Data Load Elapsed Time for [SQL] with [dt1.rul] : [651.45] 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