Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Mariposa Bot Shipped With Vodafone Smartphone

IT Job Market Heating Up: Report

Bing Makes Strides But Momentum Stalls

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2







PROGRAMMER ANALYST (IL)
Next Step Systems
US-IL-Chicago

Justtechjobs.com Post A Job | Post A Resume

Featured Database Articles

Oracle

June 29, 2004

Instant Client in Oracle 10g

By James Koopmann

Wouldn't it be nice if you didn't have to install the full Oracle client software just to get connectivity to an Oracle instance? Well, it is now reality with Oracle's new Instant Client software offering.

Oracle Instant Client

If we wanted to go the java route and name the typical Oracle Client installation as a "Fat-Client," the Oracle Instant Client would be called the "Thin-Client." Oracle's Instant Client is a small set of software and libraries that allow you to develop and deploy your applications without having to install Oracle's Fat-Client. Taking the name and putting a few definitions around it clarifies everything:

Oracle

We all know who Oracle is. In this case, it is the software, not the company or the database.

Instant

Well, almost instant. With very minor download and setup time, Oracle has given us the ability to connect from a remote machine almost as quick as it takes for you to download this small package.

Client

Typical and true client/server nomenclature here. The client here is used to make a request of the database instance. It does not matter if you are connecting to an Oracle instance on the same box as your client software, within the use of Oracle Instant Client, it is always considered to be a client and not part of the requested database.

The good news here is, even though Oracle has given us a very small footprint in this connection mechanism, we do not lose any of the features associated with the connection mechanism or the underlying database instance. If you compared Oracle's full client release against the new Instant Client you would typically find the following.

Client Comparison

Instant Client Package

File Size

Download Time

Install Space

Installation Time

 

Basic Package

~ 30M

~ 5 min

~ 80M

~ 5min

 

SQL*Plus Support

< 1M

< 1 min

< 1M

Oracle Database 10g Client Release

~360M

~1.5 hours

~ 460M

40-60min



Go to page: 1  2  Next  

Tools:
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

Oracle Archives








Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Free ERD program with import option ? tenamatt 1 February 26th, 01:39 PM
Record Select inet 1 February 26th, 01:38 PM
Rownum inet 1 February 18th, 10:01 AM
UPDATE statement performance sacrsv 2 January 19th, 07:58 PM









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers