Oracle Reference

Administration
Backup/Recovery
PL/SQL
Scripts
SQL and Object Reference
SQL*Plus
Tuning
Utilities
White Papers
FAQ

O/S and Other Reference

ASP With Oracle
Unix
Windows NT

DBSTAR - WebAdmin

WebAdmin

MyDBSTAR

Login

Search

Datafiles - Show Statistics

Explain Plan - Script to display the explain plan for a specific SQL statement

Explain Plan - Setup

Latches - Show Statistics

Locking - Example Queries

Redo Latches - Show Statistics

Rollback Segments - List performance data

Rollback Segments - List users/processes using them

Session - Show sessions using resources

Session - show user session based on unix pid

SQL - Show active

SQL tracing - tracing the SQL of a session

Statspack - Quick reference

tkprof - Format an sql trace dump

Transactions - Show active

Utlbstat and utlestat - Report on Oracle Statistics