Tools to Administer, Monitor and Tune the Oracle Database.


I just posted a complete integrated set of tools to manage, monitor and tune the Oracle database.

It is free, no registration or email is required. I will just appreciate any kind of feedback to make it better.

The package comprises the following topics:

This section allows you to view and maintain virtually all database objects, including partitioned tables and materialized views. It also includes a function to view inter-dependency between objects.

1Z0-052 Oracle DBA Admin 1 OCA Study Guide by Matthew Morris: Review


Matthew Morris (who makes many constructive and knowledgeable contributions to the forum) has written a series of study guides for the OCA/OCP exams. I asked him if I could have a copy of one to review. The result: it's very good. This is a copy of the review I put up on Amazon.

andy huang's picture

How to use Incarnation in Oracle 10G

OS:Red Hat Linux As 5
DB Version:

Oracle Database 11g Release 2: Performance Tuning Tips and Techniques (Richard Niemiec)

I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.

FIne Grained Dependencies in Oracle 11g

Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.

Announcing my upcoming Book on Advanced Oracle PL/SQL Concepts (1Z0-146 Preparation handbook)



It gives me great pleasure and honour to announce my upcoming book Oracle Advanced PL/SQL Developer Professional Guide with Pact Publishers. The book 'Oracle Advanced PL/SQL Developer Professional Guide' is focussed on the preparation of OCP (1Z0-146) examination. The book doesn't restricts its scope to the examination but aims to strengthen the advanced concepts in Oracle 11g PL/SQL.

Basics of Partition Tables in Oracle

Basics of Partition Tables

Please use ANSI join syntax


The old Oracle join syntax really should be consigned to history.

Script to find Oracle database performance


This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical I/O, logical I/O, memory and CPU processes), Top CPU usage by users, etc.


Subscribe to Oracle FAQ RSS