Oracle Database 10g Release 2: New Feature Highlights

Released in January 2004, Oracle Database 10g is the first relational database designed for Grid comp uting, delivering information with the highest quality of service, for the lowest possible cost. Only Oracle Database 10g delivers the clustering, workload management, and data center automation required for enterprise grid computing
as well as the ease of use required for small businesses. With Release 2, Oracle’s focus on improving efficiencies and reducing the cost of information management continues. This data sheet highlights some of the new features in Oracle Database 10g Release 2.

For more information, visit…

New Features in Oracle 10g for SQL*Plus and iSQL*Plus
By
James Koopmann

Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.

Unless you have some whiz-bang 3rd-party utility that you are using, you will on a daily basis use either SQL*Plus or the new iSQL*Plus utilities supplied by Oracle. With the release of Oracle 10g, these two interfaces come with a few new features that we have all been waiting for and a few features that just make them nicer to use. I am only going to touch on the new features that I think are most notable. There are a couple of new features, such as default behavior and compatibility, that I will not focus on and leave you to read the manual. I have tested the new SQL*Plus and iSQL*Plus 10g Clients against pre-10g and 10g instances so that we can quickly determine what new features are dependent on the 10g backend database to be running. Let’s begin.

SQL*Plus

File and Path Names with spaces

Probably the least noticeable new feature for SQL*Plus is the ability for you to have spaces in the directory path or within the file name for our SQL files. This option is only available in Windows environment & requires you to enclose the full path & file name within quotes (” or ‘).

SQL> @”c:/oracle/admin/tune/session/Current Sessions.sql”

While this might be a neat little feature to have, if you ever want to port your scripts to a UNIX environment they just will not work. I would suggest that you skip this feature if you have a need to port across operating systems.

glogin.sql and login.sql is run after each CONNECT

I personally think this is the greatest part of the new features. Being a DBA that will typically switch between a multitude of databases in any given hour, the ability for the re-execution of the glogin.sql and login.sql scripts to be executed after every successful CONNECT is priceless. Because these scripts use to be executed only on the first startup of SQL*Plus I would never use them; this will definitely change now and if you are not using these scripts and the power they now possess, I would encourage you to re-visit them.

For more Information, visit…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s