Handy Oracle database utility scripts

online lookup of errors

set table extent unlimited

set index extent unlimited

show user locks

recompile invalid objects

calculate user table size

re-org calculate size to set extent

show object with more than two extents

size of DBA tablespace

coalesce

Create analyze script

PL/SQL loop example

Other Sources of Oracle code