http://netvouz.com/MondoTofu/tag/performance?feed=rss MondoTofu's bookmarks tagged "performance" on Netvouz https://www.ec2instances.info/?filter=R4 Amazon instance type, name, network performance, memory, vCPU, Linux on demand, reserved cost comparison AWS MondoTofu Wed, 27 Jun 2018 18:09:47 GMT http://www.oracle-developer.net/display.php?id=429 Excerpt on pipelined table functions from Feuerstein book on PL/SQL Oracle > DB 11g MondoTofu Fri, 28 Dec 2012 20:10:09 GMT http://www.miracleas.com/BAARF/1.Millsap2000.01.03-RAID5.pdf Paper by Cary Millsap, explaining pitfalls on RAID 5. Oracle > Optimization > Hotsos MondoTofu Wed, 24 Sep 2014 15:47:52 GMT 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 https://docs.oracle.com/database/121/TGSQL/tgsql_profiles.htm#TGSQL613 Transporting a SQL Profile Oracle > Optimization MondoTofu Sat, 25 Apr 2015 14:40:45 GMT http://method-r.com/papers Papers: Technical papers and presentations from conferences and user groups. Oracle > DB 11g MondoTofu Wed, 24 Sep 2014 15:57:27 GMT http://www.oracle-base.com/articles/11g/sql-performance-analyzer-11gr1.php Creating SQL Tuning Sets using the DBMS_SQLTUNE Package Oracle > Optimization MondoTofu Thu, 28 Aug 2014 14:04:34 GMT http://www.oracle.com/technetwork/database/manageability/sqlpa-094776.html SQL Performance Analyzer (SPA), a key feature of the Real Application Testing option introduced in Oracle Database 11g, can predict and quantify SQL performance improvements and regressions caused by system changes such as upgrading a database, adding new indexes, changing database parameters, collecting optimizer statistics, etc. SQL Performance Analyzer provides a granular view of the impact of changes on SQL execution plans and execution statistics by running the SQL statements on a production or test system in isolation before and after a change. SPA compares the SQL execution result, before and after the change, and generates a report outlining the net benefit on the SQL workload due the change as well as the set of regressed SQL statements. For regres Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:36:49 GMT http://www.oracle.com/technetwork/database/manageability/sqlmonitor-084401.html Oracle Database 11g: Real-Time SQL Monitoring Real-Time SQL Monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager screens display details of SQL execution using new, fine-grained SQL statistic that are tracked out-of-the-box with no performance penalty to production systems. Statistics at each step of the execution plan are tracked by key performance metrics, including elapsed time, CPU time, number of reads and writes, I/O wait time and various other wait times. This allows DBAs to analyze SQL execution more deeply than pre Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:26:40 GMT http://www.toadworld.com/platforms/oracle/b/weblog/archive/2011/03/23/bitmap-confusion.aspx Oracle - Oracle - Toad World - short article on bitmap join indexes Oracle > Oracle Tips > Data Modeling MondoTofu Thu, 02 Jul 2015 20:01:14 GMT