STORAGE

• Tablespaces
• Free space
• Free space2
• Extents
• Extents togo
• Extent warning
• Storage check
• Storage check2

USERS

• All DB users
• Active users
• By Object
• By Object2
• By starttime
• SQLtext
• Kill a user
• Rollback 1
• Rollback 2
• Rollback 3

OBJECTS

• Object sizes
• Object types
• Synonyms
• Index by table
• Index by index
• All indexes
• Rebuild indexes
• Invalid objects
• Compile objects
• Analyze tables
• Analyze 1 table
• Analyze delete
• Analyzed tables?

PLAN table

• Introduction
• utlxplan
• Plan1
• Plan2 - by level
• Plan3 - Timestamp
• Plan4 + index
• Show index

CREATE

• Create DB
• CreateDB WNT
• CreateDB Unix
• Create Big db
• Create user
• Create owner
• Copy user
• Copy grants
• Publ. Synonyms
• User Synonyms

More info

• about SQL 4DBA's

---

©2009 Bytelife