My Oracle Support Banner

BAM Server Takes A Lot Of Time To Startup (Doc ID 1491917.1)

Last updated on MAY 22, 2017

Applies to:

Oracle BAM (Business Activity Monitoring) - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

BAM Server takes a lot of time to start up.

When setting the logging level to Trace:32, in the bam diagnostic logs we can see the following messages:

[2012-09-14T13:22:04.164+02:00] [bam_server1] [TRACE:32] [] [oracle.bam.adc.dse.oracle.OracleQueryBuilder] [tid: [STANDBY].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: OracleSystemUser] [ecid: 0000Jb4H8E26mJlkKshsZu1GKkAd000002,0] [SRC_CLASS: oracle.bam.adc.dse.oracle.OracleQueryBuilder] [APP: oracle-bam#11.1.1] [SRC_METHOD: BuildSelectQueryEx] BuildSelectQueryEx: SQL = SELECT * FROM "92063-54fe" WHERE ROWNUM
[2012-09-14T13:22:04.165+02:00] [bam_server1] [TRACE] [] [oracle.bam.adc.sqlprovider.ha.HAOracleCommand] [tid: [STANDBY].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: OracleSystemUser] [ecid: 0000Jb4H8E26mJlkKshsZu1GKkAd000002,0] [SRC_CLASS: oracle.bam.adc.sqlprovider.ha.HAOracleCommand] [APP: oracle-bam#11.1.1] [SRC_METHOD: ExecuteReader] In ExecuteReader. THE SELECT SQL:SELECT * FROM "92063-54fe" WHERE ROWNUM
[2012-09-14T13:22:04.165+02:00] [bam_server1] [TRACE:32] [] [oracle.bam.adc.sqlprovider.OracleCommand] [tid: [STANDBY].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: OracleSystemUser] [ecid: 0000Jb4H8E26mJlkKshsZu1GKkAd000002,0] [SRC_CLASS: oracle.bam.adc.sqlprovider.OracleCommand] [APP: oracle-bam#11.1.1] [SRC_METHOD: ExecuteReader] SELECT * FROM "92063-54fe" WHERE ROWNUM
[2012-09-14T13:22:05.864+02:00] [bam_server1] [TRACE:32] [] [oracle.bam.adc.dse.oracle.OracleQueryBuilder] [tid: [STANDBY].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: OracleSystemUser] [ecid: 0000Jb4H8E26mJlkKshsZu1GKkAd000002,0] [SRC_CLASS: oracle.bam.adc.dse.oracle.OracleQueryBuilder] [APP: oracle-bam#11.1.1] [SRC_METHOD: BuildSelectQueryEx] BuildSelectQueryEx: SQL = SELECT * FROM "92063-54fc" WHERE ROWNUM
...

 

The BAM Repository contains thousends of tables with similar names: '645a99-7f2f', '1f03e-7d2f', '92063-54fc'

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.