oracle

Tuning and Optimizing RHEL for Oracle 9i and 10g Databases

(via www.puschitz.com)

This article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x86 and x86-64 platforms running Oracle 9i (32bit/64bit) and Oracle 10g (32bit/64bit) standalone and RAC databases. This guide covers Red Hat Enterprise Linux Advanced Server 3 and 4 and the older version 2.1. For instructions on installing Oracle 9i and 10g databases, see Oracle on Linux. Other Linux articles can be found at www.puschitz.com...

Beautifying SQL PLUS Output

(via www.adp-gmbh.ch)

The output of SQL Plus can be a annoying a little bit. Here are some techniques that show how to enhance the readability of SQL Plus output...

SQL*Plus FAQ

(via www.orafaq.com)

SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database.

Installing Oracle 10g Guide

(via www.puschitz.com)

Very comprehensive oracle installation guide.

PL/SQL Cursor For Loop

(via www.fast-track.cc)

Oracle Tips by Burleson

1. Open the cursor.
2. Start a loop.
3. Fetch a row of data.
4. Check for a new row, exit if not.
5. Process the data.
6. End the loop.
7. Close the cursor.

Since these steps are almost always followed, Oracle provides a way to let PL/SQL perform most of the steps. This is called the CURSOR FOR loop. As in the name, it uses a FOR loop to process the cursor...

Comment