www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
Scripts
Using a ref cursor
How to redirect a page
Oracle scripts
How to secure your webserver
How to WAP in pl/sql
Use XML in the database


  OraDev.com

Scripts

Compile
Compile invalid objects

Show errors
Show errors of invalid objects

Perform
Show active sessions with their reads

Open cursors
Show open cursors per user/process

View locks
Show locks

Sessions
Show session information

Show indexes
Show indexes for a table

Who am I
Shows user and database for current connetion

Timer
Example procedure for measuring execute time in 1/1000 of a second.

Trace
Show cursors in shared pool with their statistics