MOATS: The Mother of All Tuning Scripts!
An index of my TPT scripts
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051)
New cursor_bind_capture_destination parameter in Oracle 184.108.40.206
Dropping and creating tables in read only tablespaces?!
Flexible Sqlplus command line history with RLWRAP
Quiz: Explaining index creation
Non-trivial performance problems
New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!
Sometimes things are easy (Part 1): How to fix wrapped execution plan text?
Explain Plan For command may show you the wrong execution plan – Part 1
Detect chained and migrated rows in Oracle – Part 1
What’s a good way to learn some Oracle internals every day?
KGL simulator, shared pool simulator and buffer cache simulator – what are these?
Alter system kill session and ORA-00031: session marked for kill
When was a table last changed?
Identifying shared memory segment users using lsof
Little oradebug enhancement in Oracle 11g
Transportable tablespaces and ROWID uniqueness
Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others
Case study on some rowcache internals, cached non-existent objects and a describe bug
Why does even a small difference in SQL text cause a hard parse?
Script: Display valid values for multioption parameters (including hidden parameters)
The simplest query for checking what’s happening in a database
cursor_space_for_time To Be Deprecated
Performance Tools Quick Reference Guide
Querying the current tracefile name, using SQL – with tracefile_identifier
Perl version of Snapper
Sqlplus is my second home, part 5: Reading the name of currently executing script
A simple interview question
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP
Oracle Session Snapper – real-time session-level performance stats for DBAs
Sqlplus is my second home, Part 1: HTMLizing your sqlplus output