http://netvouz.com/MondoTofu/folder/9169064117513692344/Oracle+DB+11g?feed=rss&pg=4 MondoTofu's bookmarks in folder DB 11g on Netvouz 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://jonathanlewis.wordpress.com/2010/09/13/subquery-factoring-4/ Oracle Scratchpad Jonathan Lewis on subquery factoring Oracle > DB 11g MondoTofu Wed, 26 Feb 2014 21:51:44 GMT http://surachartopun.com/2010/09/ora-29786-siha-attribute-get-failed.html SQL> create spfile='+DATA' from memory; create spfile='+DATA' from pfile * ERROR at line 1: ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200] lsts[0]] Oracle > DB 11g MondoTofu Fri, 23 Jun 2017 15:41:08 GMT http://psoug.org/definition/WITH.htm Oracle > DB 11g MondoTofu Tue, 23 Apr 2013 18:06:53 GMT http://docs.oracle.com/cd/E11882_01/olap.112/e23381/row_functions102.htm shows how offset can vary depending upon daylight savings time Oracle > DB 11g MondoTofu Thu, 07 Mar 2013 19:53:47 GMT https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=1c8aacrmhq_386&_afrLoop=2886417712899739 Due to the restrictions on fast refresh, the original materialized view can only use fast refresh after inserts since there is no count(*) in the materialized view defining statement. Oracle > DB 11g MondoTofu Wed, 24 Sep 2014 20:07:05 GMT http://docs.oracle.com/cd/E11882_01/network.112/e16543/vpd.htm#CIHGHGEF database views to understand policies, functions, etc. Oracle > DB 11g MondoTofu Wed, 12 Jun 2013 16:28:58 GMT http://chenguangblog.wordpress.com/2011/01/31/automatic-sql-tuning-sql-tuning-advisor-and-sql-profile/ Chen Guang's Blog Using Sql Tuning Advisor – Sql Profile Oracle > DB 11g MondoTofu Tue, 16 Sep 2014 15:29:24 GMT http://www.dba-oracle.com/t_11g_new_virtual_column.htm virtual column and partition by this derived column Oracle > DB 11g MondoTofu Thu, 09 Oct 2014 22:12:56 GMT