Oracle Tips by Burleson

Oracle 10g Oracle Services in OGS

As we said above, Java's globalization functionalities and behaviors are not the same as those offered in Oracle. For example, dates retrieved from a database are formatted using Oracle conventions (such as number and date formatting and linguistic sort ordering), but the static application dates are typically formatted using Java conventions. Java’s globalization functionalities can also vary, depending on the version of the JDK that is used.

Before Oracle Database 10g, when an application was required to incorporate Oracle globalization features, it would make connections to the database server and issue SQL statements to retrieve the required settings. The select operations needed to support locale definition make applications complicated and generate more network connections to the database server.

The DBA has to be aware that the OGS Java APIs are certified with JDK versions 1.2 and above with the following exception: The character set conversion classes depend on the java.nio.charset package, which is available in JDK 1.4 and later. Therefore, during installation make sure that the proper JDK (1.4) is available.

OGS extends Oracle's database globalization features to the application server. This allows applications to perform globalization logic, such as Oracle date and number formatting on the middle tier. OGS developers can eliminate expensive programming logic from the database, improving the overall application performance by reducing unnecessary network traffic between the application tier and the database server. This also helps the DBA by making the database operate more effectively and eliminating traffic that could mask other application issues.

The main functionalities of the OGS Oracle Services are:

• Oracle Locale Mapping and Locale Information
   

• Character Set Conversion (JDK 1.4 and Later)
   

• Oracle Date, Number, and Monetary Formats
   

• Oracle Binary and Linguistic Sorts

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm