Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher bursting issues in 12c

Received Response
51
Views
2
Comments
Adam Wickes
Adam Wickes Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

Hi all,

We have just upgraded from OBIEE 11g to 12c and noticed a huge increase in time spent while bursting.
For example, reports bursting to file location (on local server) increasing from 4 minutes to 40 minutes.
After turning on xdo.log, I have noticed the following lines:

[042320_094520283][][STATEMENT]  ======== BurstingDataprocessor.DataFileHandler.updateSubJob :: after update sub job properties: jobId=8048
[042320_094520283][][PROCEDURE]  == BurstingDataprocessor.DataFileHandler.insertSubJob :: end
[042320_094544799][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094644800][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094744801][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094844802][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094944804][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095044805][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095144806][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095213729][][PROCEDURE]  == BurstingDataprocessor.DataFileHandler.insertSubJob :: begin
[042320_095213729][][STATEMENT]  ======== BurstingDataprocessor.DataFileHandler.insertSubJob :: after insert sub job: jobId=8049

These lines account for 7 minutes of the total time (in this case, it was 15 minutes total job) where the server is seemingly doing nothing?
During this time however, the CPU is working hard but nothing is being written to xdo.log except for the above.

Anyone have any ideas?

Thanks,
Adam

Answers