SQL & PL/SQL

Hi,

We have used oracle object Types heavily in our project to tranfer the data from java layer to database layer. Becuase of security reasons we are referencing our oracle Types using synonyms in the java layer.

Unfotunately this is causing perfomance issues for us. JDBC driver seem to taking lot of database time in finding the appopriate underlying oracle Type object for a given synonym.

Is there anyway to tune jdbc driver synonym checks?

the following SQL is running heavily.

SELECT /*+RULE*/ TABLE_NAME, TABLE_OWNER, DB_LINK INTO
the_table_name, the_table_owner, the_db_link
FROM ALL_SYNONYMS WHERE
OWNER = 'PUBLIC' AND
SYNONYM_NAME = bind_synonym_name;

Thanks for you help in advnace


Regards
Charan