oracle和java效率,任何来自Java应用程序的Oracle TNS低效率(许多往返,延迟)的解决方案？...

调整tnsnames.ora和listener.ora中的

SDU和

TDU参数

要将当前法规的批量大小设置为100.

((OracleStatement)stmt).setRowPrefetch (100);

注意：

Setting the prefetch size can affect

the performance of an application.

Increasing the prefetch size will

reduce the number of round-trips

required to get all the data, but will

increase memory usage. This will

depend on the number and size of the

columns in the query and the number of

rows expected to be returned. It will

also depend on the memory and CPU

loading of the JDBC client machine.

The optimum for a standalone client

application will be different from a

heavily loaded application server. The

speed and latency of the network

connection should also be consideredconnection should also be considered

可用的连接属性here.