11g New features : Application Developement

Client-Side Query Cache This feature enables caching of query result sets in client memory. The cached result set data is transparently kept consistent with any changes done on the server side. Benifit: This improves perfomance of application. I mean avoids round trip by sending query and fetching data again since cached. Also improves CPU utilization by avaoind second exection time. OCI Client Session NLS Character Set Status Information This new feature adds client session NLS and character set information to the V$SESSION_CONNECT_INFO and GV$SESSION_CONNECT_INFO views. Benifit : This enhancement provides DBAs with access to client-side session character set information for all clients. This information is especially useful in troubleshooting problems. Cheers Vignesh Bala