For the Oracle Collector AppDynamics Database Visibility 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