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 laterInformation 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
...
[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 |