 Oracle Call Interface
Reliable - the Oracle Database executes SQL Statements with OCI. |
Overview
Oracle Call Interface (OCI) is the most comprehensive, high performance,
native 'C' language based interface to the Oracle Database that
exposes the full power of the Oracle Database. OCI provides the
foundation on which various language specific interfaces such as
Oracle JDBC-OCI, ODP.Net, Oracle Precompilers, Oracle ODBC and Oracle
C++ Call Interface (OCCI) drivers are built. OCI is also used by
leading Open Source interfaces such as the PHP OCI8 extension, ruby-oci8,
Perl DBD::oracle and Phython cx_oracle. OCI being the native interface
to the Oracle Database also powers queries, statements and calls
issued by the Oracle Database kernel internally. Various Oracle
tools such as SQL*Plus, Real Application Testing (RAT), SQL*Loader
and Data-Pump are also OCI based. In addition, Oracle In-Memory
Database Cache (IMDB Cache a.k.a. TimesTen) supports OCI and Oracle
Pro*C/C++ Pre-compilers. Oracle Instant Client gives ISVs and customers
the ability to quickly install and deploy Oracle applications. See
the Oracle Instant Client site for more information.
A broad range of customers including Fortune 500
customers and ISVs employ OCI directly for developing high performance
applications..
What's New in Oracle Database 11gR1 & 11gR2
The new features in Oracle
Database 11g Release 2 include:
- Ease of Day-Light Savings Transition (DLST)
Upgrades: Support for different version of Timezone files on clients
and servers under certain scenarios
- DRCP available to custom connection pools;
and better connection monitoring support for DBAs.
- new gv$cpool_conn_info view
- Non-intrusive Performance Acceleration thru
Table Annotation for Client-side Query Result Cache
- Ref Cursor Pre-Fetching - saves roundtrips
to the database
- 64-bit Integer Host Datatype for OCI Bind and
Define calls
The new features in Oracle
Database 11g Release 1 include:
- OCI and Precompilers support
for In-Memory Database Cache 11g (formerly TimesTen)
- IMDB and IMDB Cache integration
- Database Resident Connection
Pool (DRCP)
- Query Change Notification
- Client Query Result Cache
- Runtime Connection Load
Balancing in OCI Session Pool
- Binding and Defining Multiple
Buffers in a single call
- Implicit Fetching of Rowids
in SELECT ... FOR UPDATE
- Prefetching of LOB data
- SecureFiles LOB APIs
- XDB Binary XML
- Drop-in compatibility
with 10g
- Fault Diagnosability
|
Bookmark
