Archive of category 'Oracle Database'

• Apr 14, 2016 • Oracle Database, Performance, Monitoring, Tools •

  Simple Script for Real-Time Wait Event Monitoring

• Mar 24, 2016 • Oracle Database, Performance, Internals

  SQL Profiles vs. SQL Plan Baselines

• Jan 26, 2014 • Oracle Database, Performance •

  Do AWR Reports Show the Whole Picture?

• Nov 11, 2013 • Oracle Database, Oracle e-Business Suite, Tools, Maintenance •

  getMOSPatch.sh - Downloading Patches From My Oracle Support

• Nov 4, 2013 • Oracle Database, Performance, Tools •

  Mining the AWR to Identify Performance Trends

• Nov 1, 2013 • Oracle Database, Performance, Internals •

  Meaning of "Disk Reads" Values in DBA_HIST_SQLSTAT

• Aug 15, 2013 • Oracle Database, Bugs, Troubleshooting, Internals

  There's Always Another Bug Hiding Just Around the Corner

• Apr 5, 2013 • Oracle Database, Troubleshooting •

  Which Partitions Does The SQL Statement Access?

• Jan 24, 2013 • Oracle Database, Performance, Troubleshooting •

  The Easy Way of Finding Similar SQL Statements

• Oct 7, 2011 • Oracle Database, Monitoring •

  Back to School: Elementary Physics for DBAs

• Jun 16, 2011 • Oracle Database, Performance, Monitoring, Troubleshooting, Tools

  xx_perf_watcher for monitoring waits during short time intervals

• Mar 5, 2011 • Oracle Database, Troubleshooting •

  How to find tables containing lots of unused space?

• Jan 9, 2011 • Oracle Database, Backups •

  How to back up a table properly before installation of an online data-fix?

• Dec 14, 2010 • Oracle Database •

  Can an autoextensible data file grow bigger then dba_data_files.maxbytes? Sure!

• Dec 6, 2010 • Oracle Database, Troubleshooting •

  Why is the context index on the MV so large?

• Nov 30, 2010 • Oracle Database, Presentations, Performance •

  UKOUG 2010 presentation “Surviving the Crisis with the Help of Oracle Database Resource Manager”

• Sep 11, 2010 • Oracle Database, Internals •

  Is redo size affected by nologging indexes?

• Sep 8, 2010 • Oracle Database, Performance, Troubleshooting •

  How stored outlines saved the day

• Aug 24, 2010 • Oracle Database, Performance, Troubleshooting •

  Can we trust AUTOTRACE?

• May 11, 2009 • Oracle Database •

  11i and 10gR2 support has been extended

• Sep 1, 2008 • Oracle Database, Backups, Internals •

  Block corruption vs RMAN backup retention policy