OPTIMIZER_INDEX_COST_ADJ changed from 100 to 10
Increased PGA size from 4G to 15G
Disabled the direct path read ( init.ora: event = “10949 trace name context forever’)
configured cursor sharing parameter as force earlier it was ‘EXACT’

FILESYSTEMIO_OPTIONS=SETALL as of now ‘NONE’
Configure Huges pages
Break the mirroring of log files.
Creation of indexes
Increase SGA Size

References:

• Advance JDBC topics: http://docs.oracle.com/cd/E11882_01/appdev.112/e12137/addfunc.htm#TDPJD206
• Ref Cursor and JDBC: http://docs.oracle.com/cd/A87860_01/doc/java.817/a83724/samapp5.htm