For the Oracle Collector to collect database queries, sessions, clients, and schemas information that occurred during snapshots captured by the Java Agent, you need to set the jdbc-dbcam-integration-enabled App Agent property for the Java Agent.  

For information on the jdbc-dbcam-integration-enabled property, see App Agent Node Properties.

For information on snapshot correlation between the Oracle database Collector and a Java business transaction, see Access Database Visibility from Application Monitoring Views