Tuning and Optimizing RHEL for Oracle 9i and 10g Databases
Thu, 03/31/2011 - 14:14 — sandipThis 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
Wed, 09/22/2010 - 09:42 — sandipThe 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
Wed, 04/02/2008 - 16:41 — sandipSQL*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
Fri, 02/29/2008 - 18:03 — sandipVery comprehensive oracle installation guide.
PL/SQL Cursor For Loop
Sat, 01/19/2008 - 19:29 — wizapOracle 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...