Weblogic connection pooling - jdbc configuration

Using oracle OCI driver is faster than the thin .
Oracle OCI works well with the CLOB / BLOB.
The query test impact performance on Oracle 9x , the "select from DUAL" – affect performance . on oracle 10 the problem fixed .

The queries from Oracle DUAL table are very common.
As of the v$SQLAREA each query uses about 5 logical reads.
In order to wrap-up the pace of retrieving data please use X$DUAL instead of using the DUAL table.

Below is a prescription on the way to implement it and fix this issue on oracle 9x:

sqlplus /nolog
connect / as sysdba
create view dual_view as select dummy from x$dual;
grant select on dual_view to public;
rename dual to dual_table;
rename dual_view to dual;
exit