-
- v$active_session_queries
- Wait Analysis
- view onto v$session_wait script output
- log file switch (archiving needed)
- library cache pin/lock analysis
- TX Locks decode script
- TX Locks script output
- TX Lock Info script output
- TX Lock Info script output
- kill cpu good for testing
- sorts.sql info from v$sort_usage
- bh.sql getting Object ID and Name from v$bh
- Shared Pool
- Admin
- SPFILE
- Space
- Tablespaces
- Space Tom Kyte
- Alert.log errors w/ dates
- hidden init.ora params
- table statistics backing up, reloading
- PQO selective setup
- Unusable index for inserts into new partitions with bitmap indexes
- rebuild invalid objects
- sql example show_space.sql from tom kyte with partition fix
- how much rollback needs to be applied
- histograms
- session sid ways of getting
- Backup/Restore/Create
- SQL
- explain extract formated explain plan from v$sqlplan
- analytics
- hex to dec, dec to hex
- dba to file block
- obj name from dba
- explain plan basics
- 10g Autotune Notes
- list of hints
- 10gR2 V$SQLSTATS
- cursor sharing
- columns to rows print rows vertially thanks to Tom Kyte , flip sql output, print columns as rows
- Net
- Statspack
- Internals
- OEM
- Unix