8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 9i » Here


Oracle 9i 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.

CURSOR_SHARING : Automatically Convert Literals to Bind Variables in SQL Statements - Oracle 9i introduced the CURSOR_SHARING parameter, which determines how the database handles statements containing literal values.

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

Data Guard - Oracle 9i Data Guard is the new name for Oracle 8i Standby Database incorporating a large number of new features. This article discusses those relevant to the Oracle 9i 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.

MERGE Statement - Use the MERGE statement to quickly upsert data into tables.

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.

A brief overview of the DBMS_SCHEDULER support in SQL Developer 3.1.

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:

Oracle9i Database Release 2: New Features

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

Bulk Binds (BULK COLLECT & FORALL) and Record Processing in Oracle9i Release 2 - Take advantage of bulk binds (BULK COLLECT & FORALL) 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 : Display Execution Plans - 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 (SQLX) : Generating XML using SQL - 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 LogMiner, 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.

SQL/XML (SQLX) : Generating XML using SQL - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

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.

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 Oracle PL/SQL (UTL_SMTP) - Email from PL/SQL using UTL_SMTP 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.

Dynamic Binds Using Query Transformation - Simplify dynamic variable binds within dynamic SQL using query transformation.

External Tables: Querying Data From Flat Files in Oracle - 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) : Oracle to Non-Oracle Database Links Using ODBC - Query non-Oracle databases using database links over ODBC.

Index Key Compression - Reduce the size of indexes by using index key compression, including advanced index compression in Oracle 12c.

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

Multitable Inserts - Multitable inserts were introduced in Oracle 9i to allow a single INSERT INTO .. SELECT statement to conditionally, or unconditionally, insert into multiple tables.

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 an RMAN Recovery Catalog - 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.