Troubleshooting catalogue

This is a list of all articles I’ve written that describe some troubleshooting ideas. Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first.

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

• ORA-39857 (June 2022): using a “drop tablespace” problem to describe a generic method for finding out why Oracle is not doing what you thought it would.
• Case Study (June 2022): an example of solving a performance problem by reading an SQL Monitor report
• Adaptive Plans (April 2022): what they can cost and how block then selectively
• PL/SQL Warning (April 2022): an aid to pre-empt trouble-shooting – automatic warnings of pl/sql coding flaws
• Finding SQL (Aug 2021): currently includes ideas on finding “who has been using up all the temporary space”.
• Memory allocation (Aug 2021): SGA target, PGA target, Memory target: where’s the memory going.
• Cleaning the audit trail (July 2021): playing about with hexadecimal pinpoints a bug in dbms_audit_mgmt.clean_audit_trail
• Disappearing NOT NULL constraints (July 2021): the effects of the link between primary keys and not null declarations
• v$resource_limit (March 2021): reference note and simple script
• v$lock efficiency (May 2013): the benefit of collecting stats on individual x$ structures
• Old Plan_table (Jan 2010): why dbms_xplan.display() might have a note: ‘PLAN_TABLE’ is old version