Recently we found out that a certain query (attached below) is executed a high number of times against our databases. As far as I know this is the query hibernate issues at start up to validate the mapping against database schema, however, the behavior we’re seeing is that the query is executed several times per second, causing high load on database.

Has anybody run into an issue like this before? We're using 3.2.1.ga, with annotations.

Here’s the query in question:

SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE')
ORDER BY table_type, table_schem, table_name