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
[…] Troubleshooting catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — February 1, 2022 @ 11:32 am GMT Feb 1,2022 |