Enhanced filtering for the JDBC logger in the Enforce Server

Products

• Data Loss Prevention Enforce

Issue/Introduction

An enhanced filtered logging capability is available for the JDBC logger in the Symantec Data Loss Prevention Enforce Server.  This new capability enables you to filter out queries that execute quickly and only log those queries that take longer to process.  This may reveal Oracle database-related delays.

You can also limit logging to Oracle execution plan information for the queries whose execution time exceeds a certain configurable threshold. This can be used to obtain critical information about how Oracle executed the query.  You can see the complete execution plan with optimizer-based decisions. You can also see the breakdown of individual steps with their respective execution times, memory buffers, and disk input and output access.

 

Resolution

See the attached document "Enhanced filtering for the JDBC logger in the Enforce Server" for more information about setting up this feature.