• This Site
  • Home
  • DBA Scripts
  • Oracle 8i Articles
  • Oracle 9i Articles
  • Oracle 10g Articles
  • Oracle 11g Articles
  • Miscellaneous Articles
  • Linux Articles
  • Oracle RAC Articles
  • Oracle Apps Articles
  • Oracle Certification
  • Forums
  • ORACLE-BASE Blog
  • Blog Aggregator
  • Industry News
  • Book Store
  • Firefox Search Plugins
  • Site Info
  • Links
• Oracle Sites
  • Oracle Corporation
  • Technology Network
  • Oracle Certification
  • Oracle Magazine
  • Ask Tom
  • Oracle 8i R3 Docs
  • Oracle 9i R1 Docs
  • Oracle 9i R2 Docs
  • Oracle 10g R1 Docs
  • Oracle 10g R2 Docs
  • Oracle 11g R1 Docs
  • Oracle 9iAS Docs
  • Oracle AS10g R1 Docs
  • Oracle AS10g R2 Docs
  • Oracle AS10g R3 Docs
  • Oracle Wiki
  • Oracle Mix

Error Messages

8i R3 9i R1 9i R2 10g R1 10g R2 11g R1

Search Oracle Docs

Metalink 8i R3 9i R1 9i R2 10g R1 10g R2 11g R1

Site Web

Oracle 9i Articles

• Oracle9i Database: New Features For Administrators OCP Exam Articles
• Oracle9i Database Release 2: New Features
• Oracle9i Installation Articles
• Oracle9i XML Articles
• Oracle9i Web Articles
• Oracle9i Miscellaneous Articles
• Oracle9i Application Server Articles

Oracle9i Database: New Features For Administrators OCP Exam Articles

Oracle9i: New Features For Administrators Exam Tips - Some tips on what to expect when upgrading your OCP to Oracle9i.

ANSI ISO SQL Support In Oracle9i - Check out the new SQL enhancements to bring Oracle in line with the ANSI/ISO SQL: 1999 standards.

Automatic Segment Free Space Management - Reduce segment header contention and wasted space within blocks by switching from using FreeLists to Automatic Segment Free Space Management.

Automatic Undo Management - Replace you existing rollback segments with self-tuning undo segments.

Bitmap Join Indexes - Increase the performance and reduce the size of your data warehouse.

Character Semantics And Globalization - Prevent storage problems associated with mutlibyte character sets by using character semantics when defining table columns.

Data Guard - Oracle9i Data Guard is the new name for Oracle8i Standby Database incorporating a large number of new features. This article discusses those relevant to the Oracle9i Database: New Features For Administrators OCP exam.

Export And Import Enhancements In Oracle9i - See what new functionality has been incorporated into the Export and Import utilities in Oracle9i.

Flashback Query - Get a consistent view of the your data at a previous point in time.

High Availability Enhancements in Oracle9i - Reduce downtime for users by using the new high availability features of Oracle9i.

Index Organized Table (IOT) Enhancements in Oracle9i - Better support for secondary indexes and improved online maintenance make IOTs nearly as flexible as heap tables.

Index Skip Scanning - See how Oracle9i uses composite indexes even when the leading edge is not referenced.

LOB Enhancements In Oracle9i - Kickstart the conversion from LONG and RAW columns to CLOB and BLOB columns.

LogMiner Enhancements In Oracle9i - A summary of the new features introduced in Oracle9i.

Memory Management In Oracle9i - See how easy memory management has become in Oracle9i.

Metadata API - Extract DDL or XML definitions of all database objects using this simple API.

Multiple Block Sizes - Improve efficiency by having multiple block sizes that relate more closely to the operations that are being performed.

Oracle Managed Files - Let Oracle manage operating system level file placement, naming and cleanup.

Partitioning Enhancements In Oracle9i - Check out the additions and enhancements to partitioning in Oracle9i.

Performance Enhancements In Oracle9i - Read about some of the new performance features in Oracle9i.

Persistent Initialization Parameters - Make database parameter changes persist between shutdowns.

Real Application Clusters - A brief introduction to the Oracle9i replacement for Oracle Parallel Server.

Recovery Enhancements In Oracle9i - Reduce unplanned downtime by using the new crash, instance and media recovery features of Oracle9i.

Recovery Manager (RMAN) Enhancements In Oracle9i - Use the latest RMAN features which make backup and recovery quicker and more reliable.

Resource Manager Enhancements In Oracle9i - Manage system resources more precisely using the Resource Manager enhancements in Oracle9i.

Resumable Space Allocation - Make long running operations suspend rather than abort if they encounter space errors.

Scalable Session Management - Learn about the new session management features in Oracle9i.

Security Enhancements In Oracle9i - A run through the new security features available in Oracle9i, focusing on those relevant for the Oracle9i Database: New Features For Administrators OCP exam.

SQL New Features In Oracle9i - Check out the new SQL features with emphasis on those relevant for the Oracle9i Database: New Features For Administrators OCP exam.

Workspace Management In Oracle9i - Allow multiple transactionally consistent environments to exist within one database.

Feature List:

ANSI SQL Automatic Segment Space Management (ASSM) Automatic SQL Execution Memory Management Automatic Undo Management Bitmap Join Indexes Buffer Cache Advisory Cached Execution Plans Character Semantics And Globalization Core Library Improvements CURSOR_SHARING Database Statistics Data Guard DBMS_METADATA Dedicated External Procedure Agents Dynamic Initialization Parameters Dynamic SGA Parameters Export ans Import External Tables Fast-Start Time-Based Recovery Fine Grained Auditing (FGA)

FIRST_ROWS_n Flash Freeze Flashback Query Function Based Index Enhancements Global Application Context Index Monitoring Index Organized Tables Index Skip Scanning Internal Connections Deprecated LOBs Logminer Media Recovery Enhancements MERGE Minimal I/O Recovery Multitable Inserts Muliple Block Sizes Multithreaded Heterogeneous Service (HS) Agents OCI Connection Pooling Online Analyze Validate Online Index Rebuilds

Online Table Redefinition Oracle Managed Files (OMF) Partitioned Fine Grain Access Control Partitioning PK Lookup During FK Insertion Quiesce Database Real Application Clusters (RAC) Recovery Manager (RMAN) Resource Manager Resumable Space Allocation Secure Application Roles Security Miscellaneous Features SELECT .. FOR UPDATE Enhancements Share Locks On Unindexed FKs Shared Server SPFILE System Statistics View Constraints Workspace Management

Oracle9i Database Release 2: New Features

Associative Arrays - Oracle9i Release 2 allows you to index-by string values using this renamed collection.

Bulk Binds and Record Processing in Oracle9i Release 2 - Take advantage of bulk binds for performance improvements whilst using record structures.

DBNEWID Utility - Change the internal DBID and the database name using this new utility without rebuilding your controlfile.

DBMS_XPLAN - Easily format the output of an explain plan with this replacement for the utlxpls.sql script.

Export BLOB Contents Using UTL_FILE - Use the new UTL_FILE functionality to write binary data to files.

FTP From PL/SQL - A description of two methods for triggering FTP jobs directly from PL/SQL.

InterMedia - Import-Export Of Images - Use Oracle interMedia to store and retrieve images without using Java stored procedures.

Renaming Columns And Constraints - Oracle9i Release 2 now allows the renaming of columns and constraints. Check out the syntax here.

SQL/XML - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

STATISTICS_LEVEL - Let Oracle9i Release 2 control the collection of statistics and advisories with a single parameter.

Streams - Based on Advanced Queuing and LogMinor, Oracle Streams form a distributed messaging technology that can be used for a variety of tasks including messaging, replication and ETL processes.

UTL_FILE Enhancements - Oracle9i Release 2 includes some long overdue enhancements including basic file handling and support for NCHAR and RAW data.

UTL_FILE - Random Access of Files - Use the UTL_FILE package for random access of files from PL/SQL.

XML DB - Store and retrieve XML documents from the Oracle XML DB repository using HTTP, FTP and WebDAV in seconds.

XMLSEQUENCE - Use this operator to split multi-value results from XMLTYPE queries into multiple rows.

Oracle9i Installation Articles

Oracle9i (9.2.0.4.0) Installation On Fedora Core 1 Linux - A brief guide to installing Oracle9i (9.2.0.4.0) on Fedora Core 1 Linux.

Oracle9i (9.2.0.1.0) Installation On RedHat 8.0 Linux - A brief guide to installing Oracle9i (9.2.0.1.0) on RedHat 8.0 Linux.

Oracle9i (9.2.0.1.0) Installation On RedHat 9.0 Linux - A brief guide to installing Oracle9i (9.2.0.1.0) on RedHat 9.0 Linux.

Oracle9i (9.2.0.4.0) Installation On RedHat Advanced Server 2.1 Linux - A brief guide to installing Oracle9i (9.2.0.4.0) on RedHat Advanced Server 2.1 Linux.

Oracle9i (9.2.0.4.0) Installation On RedHat Advanced Server 3.0 Linux - A brief guide to installing Oracle9i (9.2.0.4.0) on RedHat Advanced Server 3.0 Linux.

Oracle9i (9.2.0.4.0) Installation on RedHat Advanced Server 4.1 And Centos 4.1 - A brief guide to installing Oracle9i (9.2.0.4.0) on RedHat Advanced Server 4.1 And Centos 4.1.

Oracle9i (9.2.0.1.0) Installation On Tru64 5.1b - A brief guide to installing Oracle9i (9.2.0.1.0) on Tru64 5.1b.

Oracle9i RAC Installation On Tru64 - A brief guide to installing Oracle9i (9.2.0.4.0) Real Application Clusters (RAC) on Tru64 5.1b.

Manual Oracle Uninstall - Having trouble removing all Oracle software using the OUI? Try these methods.

Oracle9i XML Articles

Load XMLTYPE From File - A simple method to load XMLTYPE data from a file.

Parse XML Documents - Explode unstructured XML documents into relational tables using the new integrated XDB packages.

XML DB - Store and retrieve XML documents from the Oracle XML DB repository using HTTP, FTP and WebDAV in seconds.

SQL/XML - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

XMLSEQUENCE - Use this operator to split multi-value results from XMLTYPE queries into multiple rows.

XMLType Datatype - Store XML documents in tables and query them using SQL.

XML Generation In Oracle9i Using DBMS_XMLQuery, DBMS_XMLGen, Sys_XMLGen And Sys_XMLAgg - Generate XML and perform XSL transformations with ease using the new XML features of Oracle9i.

XML-Over-HTTP - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs.

XSQL Servlet and XSQL Pages - Publish dynamic XML documents through HTTP using the XSQL Servlet utility.

Oracle9i Web Articles

Consuming Web Services - Access web services directly from PL/SQL using this simple API.

Email From PL/SQL In Oracle9i - Email from PL/SQL rather than using external procedures or Java.

File Upload and Download Procedures - Upload and download files directly from the database using Database Access Descriptors.

FTP From PL/SQL - A description of two methods for triggering FTP jobs directly from PL/SQL.

Images from Oracle Over HTTP - Retrieve images directly from the database over HTTP.

Java Server Pages - Use Java as a scripting language to interact with the database from web pages.

PL/SQL Server Pages - Use PL/SQL as a scripting language to generate web pages directly from the database.

PL/SQL Web Toolkit - Generate web pages directly from the database using this simple toolkit.

SQL*Plus Web Reports - Generate HTML reports directly from SQL*Plus.

Stateless Locking Methods - Learn how to avoid data loss in stateless environments.

Oracle9i Miscellaneous Articles

Advanced Queuing In Oracle9i - Get to grips with the basics of advanced queuing in Oracle9i.

Archivelog Mode On RAC - The differences between resetting the archive log mode on a single node instance and a Real Application Cluster (RAC).

CASE Expressions And Statements - Learn how to use CASE expressions in both SQL and PL/SQL. In addition, learn how to use the CASE statement in PL/SQL.

Complete Data Audit - A simple and generic solution for auditing before and after snapshots of data.

Compressed Tables - Compress whole tables or individual table partitions to reduce disk space requirements.

Duplicate a Database Using RMAN - Use RMAN to create a duplicate, or clone, of a database from a recent backup.

DBMS_LDAP - Accessing LDAP From PL/SQL - Use the DBMS_LDAP package to query and modify LDAP entries from PL/SQL.

DBMS_LIBCACHE - Warm up the library cache of an instance by compiling the SQL and PL/SQL statements from the library cache of another instance.

DBMS_PROFILER - Profile the run-time behaviour of PL/SQL code to identify potential bottlenecks.

DBMS_TRACE - Trace the run-time behaviour of PL/SQL code to identify potential bottlenecks.

Dynamic Binds Using Contexts - Simplify dynamic variable binds within dynamic SQL using contexts.

External Tables - Query the contents of flat files as if they were regular tables.

Full Text Indexing using Oracle Text - Efficiently query free text and produce document classification applications using Oracle Text.

Generating CSV Files - A simple example of using the UTL_FILE package to generate CSV extract files.

Heterogeneous Services - Generic Connectivity In Oracle9i - Query non-Oracle datasources using ODBC.

Java Native Compilation - Improve the performance of Java procedural code by compiling it to native shared libraries.

Mutating Table Exceptions - A simple method to prevent triggers producing mutating table exceptions.

Oracle Internet Directory - Use the Oracle Internet Directory to replace local Oracle Net configuration files and Oracle Names Server.

Oracle Label Security - Configure row-level security with this out-of-the-box solution.

Pipelined Table Functions - Improve performance of ETL processes by pipelining all transformation functions.

PL/SQL Native Compilation - Improve the performance of PL/SQL procedural code by compiling it to native shared libraries.

Recovery Manager (RMAN) - Explanation of RMANs basic backup, recovery and reporting functionality.

Storing Passwords In The Database - Store passwords securely in the database using this simple hashing technique.

Transportable Tablespaces - Copy tablespaces to new instances in the time it takes to copy the datafiles.

Unregister a Database From RMAN - A step-by-step guide to unregistering unwanted databases from the RMAN catalog.

Universal Unique Identifier (UUID) - Reduce data migration and replication issues by replacing sequence generated IDs with UUIDs.

Useful Procedures And Functions - Procedures and functions you may have overlooked which can come in useful during development.

Oracle9i Application Server Articles

Oracle9iAS Backup and Recovery - Simplify backup and recovery of Oracle9i Application Server using this Oracle supplied Perl utility.

Oracle9iAS dcmctl Utility - Speed up 9iAS administration by avoiding Enterprise Manager.

Oracle9iAS (9.0.3.0.0) Installation On RedHat Advanced Server 2.1 - A brief guide to installing Oracle9iAS (9.0.3.0.0) on RedHat Advanced Server 2.1.

Oracle9iAS (9.0.2.0.1) Portal Installation On Tru64 5.1b - A brief guide to installing Oracle9iAS (9.0.2.0.1) Portal on Tru64 5.1b.

Oracle9iAS (9.0.2.0.1) Portal Installation On Windows 2000 - A brief guide to installing Oracle9iAS (9.0.2.0.1) Portal on Windows 2000.