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

Home » Articles » Misc » Here


Miscellaneous Articles

DBA

ALTER TABLE ... SHRINK SPACE Command : Online Segment Shrink for Tables, LOBs and IOTs - The ALTER TABLE ... SHRINK SPACE command is used to perform online segment shrinks for tables, LOBs and IOT overflow segments.

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.

Clearing Down Old Database Sessions - This article explains how you might manage large numbers of old or inactive database sessions.

Configuration of TCP/IP with SSL and TLS for Database Connections - This article describes the server and client configuration needed to use TCP/IP with SSL and TLS for database connections.

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

Database Configuration Assistant (DBCA) : Creating Databases in Silent Mode - This article demonstrates how to create a new database using the Database Configuration Assistant (DBCA) in silent mode.

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

Detect And Repair Corruption in an Oracle Database - Learn the different methods of detecting and repairing 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.

hcheck.sql : A Quick Check for Known Data Dictionary Problems - The hckeck.sql script checks for known data dictionary problems in the Oracle database, so it can be used as a quick health check of a database when trying to diagnose problems.

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.

Incrementally Updated Backups : Rolling Forward Image Copies Using RMAN - Speed up backup and recovery time by rolling your image copy backups forward using incremental backups.

Install Sample Schemas - A quick note as a reminder of how to install the sample schemas into an existing database.

Killing Oracle Sessions (ALTER SYSTEM KILL / DISCONNECT SESSION) - Kill Oracle sessions from SQL, NT and UNIX.

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

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.

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.

Native Network Encryption for Database Connections - Native network encryption gives you the ability to encrypt database connections, without the configuration overhead of TCP/IP and SSL/TLS and without the need to open and listen on different ports.

ORA-00600 ORA-07445 ORA-00700 : How to Diagnose and Fix Them - A quick note to explain how to deal with these errors, so I don't have to keep answering the same questions.

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

Oracle Database Consolidation Comparison - An overview of the available options for consolidation of Oracle databases.

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 (listener.ora , tnsnames.ora , sqlnet.ora) - This article gives an example of each configuration file (listener.ora , tnsnames.ora , sqlnet.ora) 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.

SYSRESV Utility and "ORA-01041: internal error. hostdef extension doesn't exist" - This article provides an example of using the SYSRESV utility to identify the shared memory segments associated with an Oracle instance.

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.

Tablespace Thresholds and Alerts (DBMS_SERVER_ALERT) - Set tablespace thresholds as an early warning mechanism for space issues.

Oracle Trace File Analyzer (TFA) - Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy gather diagnostic information about the Oracle database and clusterware.

Tracking Database Feature Usage (DBA_FEATURE_USAGE_STATISTICS) - Identify which database options you are using to see if you comply with your Oracle licensing.

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.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

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 Data (Numbers, Strings and Dates) in Oracle - A description of how to generate random numbers, string and dates 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.

Hierarchical Queries in Oracle - Easily query hierarchical data in Oracle databases using SQL.

How do I learn to tune SQL? - A brief overview of the topic of SQL tuning for beginners.

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.

Instrumenting Your PL/SQL Code - No matter who you are or how cool you think you are at programming, you can never know exactly what is going on in your code unless you instrument it.

Join Elimination - This article describes how join elimination can improve performance of queries by removing tables from the plan.

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.

Managing Database Links - Some quick guidelines to help you manage database links.

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 for Beginners (Part 1) : The SELECT List - In this article we take a look at the type of things you are likely to see in the SELECT list of queries.

SQL for Beginners (Part 2) : The FROM Clause - In this article we take a look at the type of things you are likely to see in the FROM clause of queries.

SQL for Beginners (Part 3) : The WHERE Clause - In this article we take a look at the type of things you are likely to see in the WHERE clause of queries.

SQL for Beginners (Part 4) : The ORDER BY Clause - In this article we take a look at how you can influence the order of the data that is returned by queries.

SQL for Beginners (Part 5) : Joins - In this article we take a look at some of the common joins, both ANSI and non-ANSI, available in SQL.

SQL for Beginners (Part 6) : Set Operators - In this article we take a look at the SQL set operators available in Oracle.

SQL for Beginners (Part 7) : The GROUP BY Clause and HAVING Clause - In this article we take a look at the GROUP BY clause and HAVING clause in SQL.

SQL for Beginners (Part 8) : The INSERT Statement - In this article we take a look at some of the variations on the INSERT statement.

SQL for Beginners (Part 9) : The UPDATE Statement - In this article we take a look at some of the variations on the UPDATE statement.

SQL for Beginners (Part 10) : The DELETE and TRUNCATE TABLE Statements - In this article we take a look at the DELETE and TRUNCATE TABLE statements.

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.

Updates Based on Queries - This article describes how a table can be updated using data from another table.

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 Services and the Oracle Database - An overview of the functionality available in the Oracle database for consuming and publishing web services.

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 : Subquery Factoring in Oracle - Use the WITH clause in Oracle 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.

XMLTABLE : Convert XML Data into Rows and Columns using SQL - Use the XMLTABLE operator to project columns on to XML data, allowing you to query it directly from SQL.

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 6 Installation on Linux (RHEL and clones) - A guide to installation of Apache Tomcat on RHEL and its clones.

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

Apache Tomcat 8 Installation on Linux (RHEL and clones) - A guide to installation of Apache Tomcat 8 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.

Oracle Application Express (APEX) 5.x and 18.x Installation - A brief overview of the installation process for Application Express (APEX) 5.x and 18.x

Oracle Application Express (APEX) Patches - This article describes how to patch minor version numbers of APEX.

Oracle Application Express (APEX) 4.2, 5.0 and 5.1 LDAP Authentication - Use DBMS_LDAP to perform LDAP authentication from APEX 4.2, 5.0 and 5.1.

Oracle Application Express (APEX) 4.2 Basic Themes and Cascading Style Sheets (CSS) - This article covers some really basic information about APEX themes and CSS. It is meant as a quick pointer to help you start customizing your APEX look and feel.

APEX_JSON Package: Generate and Parse JSON Documents in Oracle - This article gives a brief overview of using the APEX_JSON package to generate and parse JSON documents in Oracle.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

Multitenant : Remove APEX Installations from the CDB in Oracle Database 12c Release 1 (12.1) - This article describes how to remove APEX from the CDB so you can install it directly in a PDB.

Oracle REST Data Services (ORDS) 3.0 and 17.x Installation on Tomcat 7, 8 and 9 - Install Oracle REST Data Services (ORDS) 3.0 and 17.x on Tomcat 7, 8 and 9.

Oracle Application Express (APEX) : Change the Admin Password - This article describes the two methods of changing the admin password for APEX.

Oracle REST Data Services (ORDS)

See the Introduction to JSON Support in the Oracle Database article for an introduction to REST and JSON.

Oracle REST Data Services (ORDS) 3.0, 17.x and 18.x Installation on Tomcat 7, 8 and 9 - Install Oracle REST Data Services (ORDS) 3.0, 17.x and 18.x on Tomcat 7, 8 and 9.

Oracle REST Data Services (ORDS) : Upgrade ORDS - This article describes the process of upgrading an existing installation of Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Standalone Mode - This article provides an overview of using Oracle REST Data Services (ORDS) in standalone mode.

Oracle REST Data Services (ORDS) : Configure Multiple Databases - This article described how to create new database connections so ORDS can service APEX, PL/SQL application and ORDS RESTful services.

Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL - This article gives an overview of using Oracle REST Data Services to developing RESTful web services using the PL/SQL API provided by the ORDS package.

Oracle REST Data Services (ORDS) : RESTful Web Services Handling Complex JSON Payloads - This article describes how to create RESTful web services that can process complex JSON payloads representing complete transactions.

Oracle REST Data Services (ORDS) : RESTful Web Services Handling Media (Documents and Images) - This article demonstrates how to create RESTful web services that handle media, such as documents and images, using Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : AutoREST - This article gives an overview of the AutoREST functionality of Oracle REST Data Services (ORDS), which allows you to automatically expose tables and views as RESTful web services.

Oracle REST Data Services (ORDS) : Auto PL/SQL - This article gives an overview of the Auto PL/SQL functionality of Oracle REST Data Services (ORDS), which allows you to easily expose PL/SQL code as RPC over HTTP(S).

Oracle REST Data Services (ORDS) : Remote Procedure Call (RPC) and Output Parameters - This article demonstrates how to handle output parameters from procedures when using Oracle REST Data Services (ORDS) for remote procedure calls (RPC).

Oracle REST Data Services (ORDS) : Using SQL Developer - This article gives an overview of using SQL Developer to interact with Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Authentication - This article gives a quick run through the authentication options available with Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Database Authentication - Use database authentication to provide basic authentication for your calls to PL/SQL from Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Custom Authentication Schemes - This article gives an example of how you could develop your own custom authentication scheme for Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Simple Oracle Document Access (SODA) - This article gives an overview of the Simple Oracle Document Access (SODA) functionality of Oracle REST Data Services (ORDS), which allows you to use Oracle as a JSON document store.

Oracle REST Data Services (ORDS) : REST Enabled SQL - REST Enabled SQL allows REST client to send DML, DDL and scripts to any REST enabled schema without additional web service configuration.

Oracle REST Data Services (ORDS) : Open API 2.0 (Swagger) Support - From version 17.4 onward, Oracle REST Data Services (ORDS) exposes the metadata of web services in Open API 2.0 format, making it easy to document and generate calling code for REST APIs using Swagger.

Oracle REST Data Services (ORDS) : HTTP Headers (OWA_UTIL) and ORDS-Specific Bind Variables - This article describes how to get information from the HTTP header of a request to ORDS using the OWA_UTIL package, as well as how to reference ORDS-specific bind variables.

Oracle REST Data Services (ORDS) : Including Hyperlinks in JSON Output - This article demonstrates how column aliases are used to instruct Oracle REST Data Services (ORDS) to display values as hyperlinks in the JSON output.

Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions - SQLcl is a lightweight Java-based replacement for SQL*Plus, which amongst other things allows you to display ORDS web service definitions using the REST command.

SODA for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

Docker : Oracle REST Data Services (ORDS) on Docker - This article describes a simple build for running Oracle REST Data Services (ORDS) on Docker.

JSON

See the Oracle REST Data Services (ORDS) articles above.

An Introduction to JSON Support in the Oracle Database - This article provides an overview of the JSON functionality available when using an Oracle database, along with links to relevant articles.

APEX_JSON Package: Generate and Parse JSON Documents in Oracle - This article gives a brief overview of using the APEX_JSON package to generate and parse JSON documents in Oracle.

SQL/JSON Functions in Oracle Database 12c Release 2 (12.2) - This article gives basic examples of the SQL/JSON functions introduced in Oracle Database 12c Release 2 (12.2).

JSON Support in Oracle Database 12c Release 1 (12.1.0.2) - This article describes the server side support for JSON in the database.

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on some of them.

JSON Support Enhancements in Oracle Database 18c - Oracle 18c includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on others.

Indexing JSON Data in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of how to index JSON data in Oracle Database 12c Release 1 (12.1.0.2).

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

PL/SQL Object Types for JSON in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database including native support for JSON parsing and generation in PL/SQL.

JSON Data Guide in Oracle Database 12c Release 2 (12.2) - Simplify the interaction with JSON data stored in the database using the JSON Data Guide functionality introduced in Oracle Database 12c Release 2 (12.2).

JSON Data Guide Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.

TREAT(... AS JSON) in Oracle Database 18c - In Oracle 18c the TREAT function can be used in SQL to change the declared type of an expression to JSON, where the expression is an object containing JSON data.

JSON_EQUAL Condition in Oracle Database 18c - The JSON_EQUAL condition was introduced in 18c to allow JSON documents to be compared regardless of member order or document formatting.

JSON_TABLE Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON_TABLE function in Oracle Database 18c.

TO_UTC_TIMESTAMP_TZ Function in Oracle Database 18c - Oracle 18c introduced the new TO_UTC_TIMESTAMP_TZ function to help deal with ISO 8601 date strings.

SODA for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

XML

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-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.

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

XMLTABLE : Convert XML Data into Rows and Columns using SQL - Use the XMLTABLE operator to project columns on to XML data, allowing you to query it directly from SQL.

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

Native Oracle XML DB Web Services in Oracle 11g Release 1 - Present your exisitng PL/SQL procedures and functions as web services using XML DB in Oracle 11g.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

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

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

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

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.

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

Cloud

Oracle Databases in the Cloud - This article presents an overview of options for deploying Oracle databases in the cloud.

Amazon Web Services (AWS) : Installation of Oracle on EC2 - This article gives an overview of creating an Oracle database in an Amazon Web Services (AWS) Elastic Compute Cloud (EC2) virtual machine.

Amazon Web Services (AWS) : Relational Database Services (RDS) for Oracle - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for Oracle.

Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for MySQL.

Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for SQL Server.

Azure : Installation of an Oracle Database on Azure - This article gives an overview of creating an Oracle database in a Microsoft Azure virtual machine.

Azure : SQL Server Databases on Azure - This article gives an overview of creating an Oracle database in a Microsoft Azure virtual machine.

Oracle Cloud : Autonomous Data Warehouse (ADW) - Create Service - This article provides a run through of creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.

Oracle Cloud : Autonomous Data Warehouse (ADW) - Load Data from an Object Store (DBMS_CLOUD) - This article demonstrates how to load data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the DBMS_CLOUD package.

Oracle Cloud : Autonomous Data Warehouse (ADW) - Import Data from an Object Store (impdp) - This article demonstrates how to import data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the impdp utility.

Oracle Cloud : Autonomous Transaction Processing (ATP) - Create Service - This article provides a run through of creating a new Autonomous Transaction Processing (ATP) service on the Oracle Cloud.

Oracle Cloud : Database as a Service (DBaaS) - Create Service - This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

Oracle Cloud : Database as a Service (DBaaS) - Patch Service - This article provides a run through of patching a DBaaS service on the Oracle Cloud.

Oracle Cloud : Schema as a Service - This article gives and overview of Oracle's schema as a service DBaaS offering.

Oracle Cloud : MySQL Cloud Service - Create Service - The Oracle MySQL Cloud Service allows you to quickly deploy MySQL databases on the Oracle Public Cloud.

Silent Installation and Configuration

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.

Database Configuration Assistant (DBCA) : Creating Databases in Silent Mode - This article demonstrates how to create a new database using the Database Configuration Assistant (DBCA) in silent mode.

WebLogic 11g Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 11g on Oracle Linux.

Oracle Forms and Reports 11gR2 Silent Installation on Oracle Linux 6 - An overview of the silent installation of Oracle Forms and Reports 11gR2 on Oracle Linux 6.

ADF 11g Silent Installation - This article demonstrates how to perform a silent installation of ADF 11g on Oracle Linux.

WebLogic 12c Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 12c on Oracle Linux.

Oracle Forms and Reports 12c (12.2.1) Silent Installation on Oracle Linux 6 and 7- An overview of the silent installation of Oracle Forms and Reports 12c on Oracle Linux 6 and 7.

WebLogic Server 12cR2 (12.2.1) : ADF Application Development Runtime - Repository Configuration Utility (RCU) in Silent Mode - This article provides a brief example of using the Repository Configuration Utility (RCU) from the ADF Application Development Runtime in silent mode.

Oracle Business Intelligence 12c (12.2.1.2.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.2.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Business Intelligence 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.2.6) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.2.6) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

Oracle Business Intelligence 11g Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 11g on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 11g Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 11g on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

WebLogic Scripting Tool (WLST) Examples

Resource Manager

Resource Manager in Oracle 8i - Prevent batch processes interfering with your OLTP transactions by using this simple PL/SQL API to assign a priority to each type of session.

Resource Manager Enhancements In Oracle 9i - Manage system resources more precisely using the Resource Manager enhancements in Oracle 9i.

Resource Manager Enhancements in Oracle Database 10g - In Oracle 10g resource manager is more flexible and even easier to configure than before. Check out the enhancements here.

Resource Manager Enhancements in Oracle Database 11g Release 1 - An overview of the resource manager enhancements in Oracle Database 11g Release 1.

Instance Caging to Manage CPU Usage in Oracle Database 11g Release 2 - Control CPU usage when consolidating multiple databases on to a single server.

Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.1).

Multitenant : Disk I/O (IOPS, MBPS) Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of disk I/O used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Control resource allocation between pluggable databases and within an individual pluggable database.

Multitenant : Memory Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of memory used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : Resource Manager PDB Performance Profiles in Oracle Database 12c Release 2 (12.2) - PDB performance profiles define the resource management for groups of PDBs in Oracle Database 12c Release 2 (12.2)

Resource Manager Enhancements in Oracle Database 12c Release 2 (12.2) - This page brings together all the articles related to Resource Manager enhancements in Oracle Database 12c Release 2 (12.2).

Resource Manager : Per-Process PGA Limits in Oracle Database 12c Release 2 (12.2) - Resource Manager can limit the amount of PGA used by a session in Oracle Database 12c Release 2 (12.2).

Scheduler (DBMS_SCHEDULER)

Scheduler (DBMS_SCHEDULER) in Oracle Database 10g - Oracle Database 10g includes a flexible scheduler to replace the DBMS_JOB package.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle 10g Database Release 2 - This article provides simple examples of how to use the scheduler enhancements (DBMS_SCHEDULER) in Oracle 10g Database Release 2, including event-based jobs and job chains.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 11g Release 1 - Oracle 11g adds more functionality to the Oracle scheduler.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 11g Release 2 - Oracle 11gR2 adds more functionality to the Oracle scheduler.

Remote Scheduler Agent Installation for Oracle 11g Release 2 - An overview of the installation of the Remote Scheduler Agent for Oracle 11g Release 2.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c Release 1 adds more functionality to the Oracle scheduler.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 continues to extend the functionality of the Oracle scheduler with in-memory jobs, job incompatibility definitions and scheduler resource queues.

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

DBMS_CREDENTIAL : Persist Database and OS Credentials in Oracle Database 12c Release 1 (12.1) - In Oracle 12c the credential related sub-programs of the DBMS_SCHEDULER package have been deprecated and replaced by the new DBMS_CREDENTIAL package. From a usage perspective it feels similar.

Feature List:

Partitioning

Partitioned Tables And Indexes - Reduce tables and indexes to a more manageable size and simultaneously improve performance.

Partitioning Enhancements In Oracle 9i - Check out the additions and enhancements to partitioning in Oracle 9i.

Partitioning Enhancements in Oracle Database 11g Release 1 - An introduction to the partitioning enhancements in Oracle 11g Release 1.

Partitioning Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.

Partitioning Enhancements in Oracle Database 12c Release 2 (12.2) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 2.

Automatic List Partitioning in Oracle Database 12c Release 2 (12.2) - Automatic list partitioning was introduced in Oracle Database 12c Release 2 (12.2) to solve the problem of how to handle new distinct values of the list partitioning key.

Asynchronous (Delayed) Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1 - Oracle 12c can optimize the performance of some DROP PARTITION and TRUNCATE PARTITION commands by deferring the associated index maintenance, while leaving the global indexes in a valid state.

Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1 - The TRUNCATE [SUB]PARTITION and EXCHANGE [SUB]PARTITION commands can now include a CASCADE clause, allowing the actions to cascade down the hierarchy of reference partitioned tables.

Create Table for Exchange With a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Make sure a table is compatible for an EXCHANGE PARTITION operation by using CREATE TABLE ... FOR EXCHANGE WITH TABLE in Oracle Database 12c Release 2 (12.2).

Filtered Partition Maintenance Operations - Oracle Database 12c Release 2 (12.2) allows you to add a filter condition when you move, split or merge a partition, move a table or convert a non-partitioned table to a partitioned table.

Interval-Reference Partitioning in Oracle Database 12c Release 1 - Oracle 12c allows you to use an interval partitioned table as the parent for a reference partitioned table.

Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) introduced the ability to define a list partitioned table based on multiple columns.

Online Conversion of a Non-Partitioned Table to a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 makes it easier than ever to convert a non-partitioned table to a partitioned table, requiring only a single command and no downtime.

Online MERGE PARTITION and MERGE SUBPARTITION in Oracle Database 18c - In Oracle Database 18c the MERGE PARTITION and MERGE SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1 - In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.

Online SPLIT PARTITION and SPLIT SUBPARTITION in Oracle Database 12c Release 2 (12.2) - In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION and SPLIT SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1 - Oracle 12c allows the creation of global and local indexes on a subset of the partitions of a partitioned table.

Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1 - In Oracle 12c some maintenance operations can now be performed on multiple partitions in a single ALTER TABLE statement.

Partitioned External Tables in Oracle Database 12c Release 2 (12.2) - Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins.

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.

Read-Only Partitions and Subpartitions in Oracle Database 12c Release 2 (12.2) - From Oracle Database 12c Release 2 (12.2) onward you can mark partitions and subpartitions as read-only to protect their data from accidental change.

External Tables

External Tables : Querying Data From Flat Files in Oracle - Query the contents of flat files as if they were regular tables by using external tables.

External Table Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to external tables in Oracle Database 12c Release 1 (12.1).

External Tables and XMLTAG to Load XML Documents in Oracle Database 12c Release 2 (12.2) - This article describes how to use the XMLTAG clause of an external table to load XML fragments from XML documents in Oracle Database 12c Release 2 (12.2).

External Tables Containing LOB Data - This articles shows how external tables are used to read CLOB and BLOB data, enabling parallel load operations of large quantities of data.

Inline External Tables in Oracle Database 18c - Oracle Database 18c allows you to access data in flat files using an inline external table defined in a SELECT statement.

Partitioned External Tables in Oracle Database 12c Release 2 (12.2) - Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins.

Override External Table Parameters From a Query in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) allows a query to modify of some external table parameters using the EXTERNAL MODIFY clause of the SELECT statement.

External Tables (Unloading/Loading Data Using External Tables) - Oracle have incorporated support for data pump technology into external tables. The ORACLE_DATAPUMP access driver can be used to unload data to data pump export files and subsequently reload it. The unload of data occurs when the external table is created using the "AS" clause.

SQLcl

SQLcl : Format Query Results with the SET SQLFORMAT Command - SQLcl makes it simple to format query results using the SET SQLFORMAT command and a variety of built-in formats.

Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions - SQLcl is a lightweight Java-based replacement for SQL*Plus, which amongst other things allows you to display ORDS web service definitions using the REST command.

Operating System Installations

These articles provide a pictorial guide for performing an installation of Oracle linux.

These articles provide a pictorial guide for performing an installation of RHEL.

These articles provide a pictorial guide for performing an installation of Fedora.

Here are some miscellaneous installation articles.

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).

VirtualBox : Extend Virtual Disk and File System - This article describes how to extend VirtualBox virtual disks.

Others

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

Adding/Removing Windows Features using PowerShell - This article describes how to list, add and remove Windows features using PowerShell.

SQL Server : Connections in SQL Developer - Use SQL Developer to connect to SQL Server databases.

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.

Dnsmasq : For Simple DNS Configurations on Mac OS X - Learn how to use Dnsmasq simple DNS configurations on Mac OS X.

Miscellaneous Frequently Asked Questions - Some frequently asked questions about general items.

Cool New Features for Developers in 18c and 12c - A links page to all the articles referenced by the conference presentation of the same name.