Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Miscellaneous Articles

DBA

AutoNumber And Identity Functionality - Implement AutoNumber or Identity column behaviour in Oracle.

Basic Enterprise Manager Troubleshooting - The first things to check out when the web-based Enterprise Manager console stops working.

Basic Security Measures for Oracle - This article presents some basic steps to increase the security of your Oracle database servers.

Cost Based Optimizer (CBO) And Database Statistics - Lists the available mechanisms for gathering database statistics that are used by the cost based optimizer.

Deadlocks - This article shows the steps necessary to identify the offending application code when a deadlock is detected.

Detect And Correct Corruption - Learn the different methods of detecting and correcting table block corruption.

Direct and Asynchronous I/O - Take advantage of the performance advantages associated with Direct and Asynchronous I/O.

Dbvisit Replicate Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Replicate with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Reporting Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Reporting with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Standby Installation on Oracle Linux 5 and 6 - This article briefly describes the installation and usage of Dbvisit Standby with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Granular Control of Optimizer Features (OPTIMIZER_FEATURES_ENABLE, _FIX_CONTROL, V$SYSTEM_FIX_CONTROL and V$SESSION_FIX_CONTROL) - Enable and disable specific optimizer features and bug fixes in Oracle 10.2.0.2 and above.

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

Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.

Killing Oracle Sessions - Kill Oracle sessions from SQL, NT and UNIX.

Manually Cloning an Existing Oracle Database Installation on Linux - This article describes the steps necessary to manually clone an existing Oracle database installation to a new Linux server.

Learning to be an Oracle Database Administrator (DBA) - My thoughts on the most efficient way to learn to be an Oracle Database Administrator (DBA).

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

Materialized Views in Oracle - Use materialized views (snapshots) to replicate data to a remote database.

Measuring Storage Performance For Oracle Systems - This article outlines two easy ways to test the performance of your storage systems using utilities provided by Oracle.

Oracle Certification : Frequently Asked Questions (OCA, OCP, OCE, OCM) - My personal opinions when answering questions about Oracle Certification.

Naming Conventions - Some of the typical naming conventions used for objects in Designer and the database.

Oracle Instant Client Installation - Quickly enable Oracle access without the need for a full-blown Oracle Client installation.

Oracle Network Configuration - This article gives an example of each configuration file as a starting point for simple network configuration.

Oracle Shell Scripting - This article presents some some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.

Oracle Universal Installations (OUI) Silent Installations - Use the Oracle Universal Installations (OUI) to create and use response files to automate the installation of Oracle products.

OS Authentication - A guide to configuring OS authentication on UNIX/Linux and Windows servers.

OS Backup Commands - A summary of the operating system backup commands you might encounter whilst backing up Oracle databases.

Partitioning an Existing Table using EXCHANGE PARTITION - This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax.

Partitioning an Existing Table using DBMS_REDEFINITION - This article presents a simple method for partitioning an existing table using the DBMS_REDEFINITION package.

Proxy User Authentication and Connect Through in Oracle Databases - Connect to other database users without knowing their passwords.

Oracle and RAID - A summary of the most common RAID levels and their usage with Oracle files.

Reclaiming Unused Space in Datafiles - This article shows several methods for reclaiming unused space from datafiles.

Recompiling Invalid Schema Objects - This article presents several methods for recompiling invalid schema objects.

Renaming or Moving Oracle Files - An explanation of how assorted Oracle files can be renamed or moved to a new location.

Stored Outlines and Plan Stability - Use stored outlines to maintain consistent execution plans regardless of changes in the system environment or associated statistics.

Schema Owners and Application Users - Protect your schema objects by defining application users with the necessary privileges on those objects, rather than allowing direct connections to the schema owner.

SQL Developer 3.1 Data Pump Wizards (expdp, impdp) - This article gives an overview of the Data Pump Wizards included in SQL Developer 3.1.

SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support - A brief overview of the DBMS_SCHEDULER support in SQL Developer 3.1.

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

UNIX Commands For DBAs - A selection of UNIX commands including those for monitoring performance.

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

Virtual Indexes - Use virtual indexes to test alternate indexing strategies with no impact on the rest of your system.

Development

ALL, ANY and SOME Comparison Conditions in SQL - A quick look at some comparison conditions you may not be used to seeing in SQL against an Oracle database.

Analytic Functions - An introduction to analytic functions in Oracle.

ANYDATA Type - This article presents an overview of the ANYDATA type.

APPEND Hint - Use the APPEND hint to improve the performance of load operations.

Autonomous Transactions - A brief overview of autonomous transactions.

Database Triggers Overview - An introduction to database triggers in Oracle.

DBMS_PIPE : For Inter-Session Communication - This article presents a brief description of the DBMS_PIPE package, explaining how it can be used for non-secure inter-session mesaging.

DBMS_RANDOM : Generating Random Numbers and Strings in Oracle - A description of how to generate random numbers and string in Oracle.

DBMS_SESSION : Managing Sessions From a Connection Pool in Oracle Databases - A guide to using the DBMS_SESSION package to manage sessions that form part of a connection pool.

Decoupling to Improve Performance - Learn how to decouple processing to give the impression of improved performance.

Dynamic IN-Lists - This article presents a number of methods for parameterizing the IN-list of a query.

Efficient Function Calls From SQL - This article presents a number of solutions for making calls to PL/SQL functions from SQL more efficient.

Efficient SQL Statements - A brief non-version specific guide to writing efficient SQL statements.

Email From Oracle PL/SQL (UTL_SMTP) - Email from PL/SQL using UTL_SMTP rather than using external procedures or Java.

FIRST_VALUE and LAST_VALUE Analytic Functions - Simple examples of how to use these analytic functions.

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

HTML with Embedded Images from PL/SQL - Use PL/SQL to create HTML with embedded images.

Implicit vs. Explicit Cursors in Oracle PL/SQL - A comparison of the relative performance of implicit and explicit cursors in Oracle PL/SQL.

Introduction to PL/SQL - A brief overview of some of the important points you should consider when first trying to learn PL/SQL.

LAG and LEAD Analytic Functions - Simple examples of how to use these analytic functions.

Literals, Substitution Variables and Bind Variables - The article compares the affect of using literals, substitution variables and bind variables on memory and CPU usage.

Logic/Branch Ordering in PL/SQL - This article demonstrates the affect of branch ordering on the performance of CASE and ELSIF statements.

NOCOPY Hint to Improve Performance of OUT and IN OUT Parameters in PL/SQL Code - This article discusses the benefits of using the NOCOPY hint for passing large or complex OUT and IN OUT parameters in PL/SQL.

NULL-Related Functions (NVL, DECODE, NVL2, COALESCE, NULLIF, LNNVL, NANVL, SYS_OP_MAP_NONNULL) - A summary of the functions available for handling NULL values.

Object Views and Nested Tables - Use object views to present relational data as an object-relational model.

Oracle Certification : Frequently Asked Questions (OCA, OCP, OCE, OCM) - My personal opinions when answering questions about Oracle Certification.

Oracle Dates, Timestamps and Intervals - An overview of the usage of dates, timestamps and intervals in Oracle databases.

Overlapping Date Ranges - This article presents simple methods to test for overlapping date ranges.

Performance of Numeric Data Types in PL/SQL - This article demonstrates the relative performance of the numeric data types in PL/SQL.

PL/SQL : Stop Making the Same Performance Mistakes - This article describes the common PL/SQL performance mistakes I see people making time and time again.

PL/SQL Vs. Oracle JVM: Speed Comparison for Mathematical Operations - This article does a side-by-side speed comparison of PL/SQL and the Oracle JVM for some basic mathematical operations.

Populating Master-Detail Foreign Key Values Using Sequences - This article presents some safe methods for populating master-detail foreign key columns when using sequences.

RANK, DENSE_RANK, FIRST and LAST Analytic Functions - Simple examples of how to use these analytic functions.

Regular Expression Support in Oracle (REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_LIKE) - Using regular expressions to solve some questions I've been asked over the years.

Retrieving HTML and Binaries into Tables Over HTTP - This article gives two brief examples of how HTML pages and Binaries, such as images or documents, can be downloaded over HTTP and placed directly into tables.

ROLLUP, CUBE, GROUPING Functions and GROUPING SETS - An overview of some functionality available for aggregation in data warehouses.

ROWIDs for PL/SQL Performance - This article demonstrates how using ROWIDs in transactions can improve performance.

Short-Circuit Evaluation in PL/SQL - This article describes how short-circuit evaluation can be used to improve the performance of some boolean expressions.

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.

String Aggregation Techniques - Several methods of combining multiple rows of data into a single row using aggregate functions.

Top-N Queries - Top-N queries provide a method for limiting the number of rows returned from ordered sets of data.

Using Ref Cursors To Return Recordsets - Return recordsets from Oracle stored procedures.

UTL_HTTP and SSL (HTTPS) using Oracle Wallets - This article describes how to use the UTL_HTTP package to interact with resources secured by SSL (HTTPS).

Web Scripting for Oracle (PHP, Perl, JSP, ASP and ASP.NET) - This article presents the basic syntax for several popular web scripting languages that connect to Oracle databases.

WITH Clause - Use the WITH clause to reduce repetition and simplify complex SQL statements.

XML-Over-HTTP (REST Web Services) From PL/SQL - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs.

Operating System Installations

Fedora Core 6 (FC6) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora Core 6 (FC6).

Fedora 7 (F7) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 7 (F7).

Fedora 8 (F8) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 8 (F8).

Fedora 9 (F9) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 9 (F9).

Fedora 10 (F10) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 10 (F10).

Fedora 11 (F11) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 11 (F11).

Fedora 12 (F12) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 12 (F12).

Fedora 13 (F13) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 13 (F13).

Fedora 14 (F14) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 14 (F14).

Fedora 15 (F15) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 15 (F15).

Fedora 16 (F16) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 16 (F16).

Fedora 17 (F17) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 17 (F17).

Fedora 18 (F18) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 18 (F18).

Oracle Enterprise Linux 4.5 - This article provides a pictorial guide for performing a default installation of Oracle Enterprise Linux 4.5.

Oracle Enterprise Linux 5 - This article provides a pictorial guide for performing a default installation of Oracle Enterprise Linux 5.

Oracle Linux 6 Installation - This article provides a pictorial guide for performing a default installation of Oracle Linux 6.

Red Hat Enterprise Linux 2.1 and CentOS 2 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 2.1 and CentOS 2.

Red Hat Enterprise Linux 3 and CentOS 3 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 3 and CentOS 3.

Red Hat Enterprise Linux 4 and CentOS 4 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 4 and CentOS 4.

Red Hat Enterprise Linux 5 and CentOS 5 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 5 and CentOS 5.

Solaris 10 (x86-32) Installation - This article provides a pictorial guide for performing a default installation of Solaris 10 (x86-32).

SUSE Linux 10.1 Installation - This article provides a pictorial guide for performing a default installation of SUSE Linux 10.1.

Ubuntu 6.10 Installation - This article provides a pictorial guide for performing a default installation of Ubuntu 6.10.

VMware ESX Server 3.5 Update 2 Installation - This article describes the bare-metal installation and basic usage of VMware ESX Server 3.5 Update 2.

Oracle VM

A Cure for Virtual Insanity - A vendor-neutral introduction to virtualization without the hype.

Oracle VM (2.2) Installation - This article gives a brief overview of the installation of Oracle VM Server and Oracle VM Manager version 2.2 (64-bit).

Oracle VM (3.0.1) Installation - This article gives a brief overview of the installation of Oracle VM Server and Oracle VM Manager version 3.0.1 (64-bit).

VirtualBox : Creating a New Virtual Machine (VM) - An overview of creating a new virtual machine using VirtualBox (4.2).

Middleware

Oracle 9iAS Articles - Installation and configuration articles for Oracle 9iAS.

Oracle AS10g Articles - Installation and configuration articles for Oracle AS10g.

Oracle WebLogic 11g Articles - Installation and configuration articles for Oracle WebLogic 11g.

Oracle WebLogic 12c Articles - Installation and configuration articles for Oracle WebLogic 12c.

An Oracle DBA's Guide to WebLogic Server - An overview of WebLogic Server for beginners, especially DBA's, who are new to middle tier administration.

Linux HTTP Server Configuration - Install and configure an Apache HTTP server on Linux.

Apache Tomcat Installation on Linux - A guide to installation of Apache Tomcat on RHEL and its clones.

Apache Tomcat 7 Installation on Windows - A guide to installation of Apache Tomcat 7 on Windows.

Apache : Reverse Proxy Configuration - Learn how to configure Apache as a reverse proxy server.

Apache Monitoring using mod_status (server-status) - Monitor the performance of Apache servers using the mod_status Apache module.

Signing JAR Files - This article describes the method for creating a keystore and signing JAR files.

Apache and PHP Installation on Windows - The steps necessary to get Apache 1.3 and PHP 4.4.0 configured on Windows to connect to Oracle.

Configuration of PHP with IIS on Windows 2003 - This article contains instructions for setting up PHP with IIS on Windows 2003.

Zend Core for Oracle v2 - Get a fully configured Apache + PHP server with full Oracle connectivity from a single installation.

Create Self-Signed SSL Certificates - Notes on how to create self-signed SSL certificates using a variety of methods.

Monitoring Java Garbage Collection Using jstat - This article provides a very brief introduction to diagnosing Java performance problems relating to garbage collection.

Application Express (APEX)

Oracle Application Express (APEX) 4.2 Installation - A brief overview of the installation process for Application Express (APEX) 4.2.

Others

PowerShell : Useful Commands - A collection of commands and scripts I've found useful when working with Windows PowerShell.

Configuring the Alcatel SpeedTouch USB modem on RedHat 7.3 - 9.0 - A guide to configuring an ADSL connection on RedHat Linux using the Alcatel SpeedTouch USB modem.