Blog posts

• Blog Migrated to GitHub Pages
• Oracle Log Writer (LGWR) Writes Behavior On ASM – NORMAL And HIGH Redundancy Disk Groups
• Automating Oracle Patching With Ansible
• Date And Time Format In ASMCMD For File Listing
• TEMP Table Transformation Errors
• Oracle Call Interface (OCI) Tracing
• The Side Effects Of Drop 'UNUSED' Index
• Empty Blocks Affecting ROWNUM Performance
• RMAN Duplicate Hang And nK Buffers
• Data Redaction – Virtual Column Bug Fixed In Oracle 12.2
• Identify Timed-Out SQL From SQL Tuning Task
• Partial Restore And Recovery
• Date Periods Overlapping
• Sequences – Cache/No-Cache
• View Merging And DBMS_RADNOM Anomaly
• Active Services On Physical Standby Database
• Enable Recovery For Disabled Pluggable Database In Data Guard Environment
• LATERAL Inline Views / GROUP BY And Scalar Subquery Caching
• Data Redaction Thoughts
• Function Based Indexes And Data Redaction
• Partial GLOBAL And LOCAL Indexes
• Troubleshooting TNS-12531 (TNS:Cannot Allocate Memory Error)
• Increase VARCHAR2, NVARCHAR2, And RAW Data Types Size
• Oracle DB Time
• Restrict PDBs Information For Common Users While Connected To Root
• Initialization Parameters For PDBs
• Data Redaction – Part 2
• How To Get DDL For Scheduler Jobs Owned By SYS
• Data Redaction – Part 1
• Invisible Columns
• INSERT Statement Taking Long Time – Sequence Problem
• PL/SQL Function Result Cache
• Recreate DUAL Table
• Real World Performance Tour 2014, Sofia
• Show All Hidden Parameters And Their Current/System Values