Netvouz / MondoTofu / tag / statistics http://netvouz.com/MondoTofu/tag/statistics?feed=rss MondoTofu's bookmarks tagged "statistics" on Netvouz Ask Tom "How to find object I/O contention" https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7350114448818 How to find object I/O contention Oracle > Internals MondoTofu Thu, 22 Oct 2015 16:13:12 GMT Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Oracle Optimizer) https://blogs.oracle.com/optimizer/entry/incremental_statistics_maintenance_what_statistics strategies for gathering statistics DML new feature 11g; helpful for partitioned tables Oracle > DB 11g MondoTofu Sun, 27 Apr 2014 01:39:24 GMT Kerry Osborne’s Oracle Blog » Blog Archive » What Did My New Index Mess Up? – Kerry Osborne’s Oracle Blog http://kerryosborne.oracle-guy.com/2009/06/what-did-my-new-index-mess-up/ find significantly different average elapsed times per execution. It uses AWR data and computes a normalized standard deviation between the average elapsed time per execution before and after the date specified by the days_ago parameter Oracle > DB 11g MondoTofu Fri, 06 Jun 2014 15:02:24 GMT Inside the Oracle Optimizer - Removing the black magic http://optimizermagic.blogspot.com/2008/01/improvement-of-auto-sampling-statistics.html Improvement of AUTO sampling statistics gathering feature in Oracle 11g Oracle > DB 11g MondoTofu Fri, 10 May 2013 19:49:44 GMT Maintaining statistics on large partitioned tables (Oracle Optimizer) https://blogs.oracle.com/optimizer/entry/maintaining_statistics_on_large_partitioned_tables large tables with partitions where statistics incrementally change may help with loading. Oracle > DB 11g MondoTofu Fri, 10 May 2013 12:57:32 GMT Oracle related stuff: Extended DISPLAY_CURSOR With Rowsource Statistics http://oracle-randolf.blogspot.com/2011/12/extended-displaycursor-with-rowsource.html Extended DISPLAY_CURSOR With Rowsource Statistics Oracle > DB 11g MondoTofu Sun, 27 Apr 2014 01:46:57 GMT