• SQL Performance Analyzer Active Report
  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
  with 11g analyzer application database oracle performance predict real sql testing
• sqlmonitor.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
  with 11g database display enterprise execution manager monitoring oracle performance real-time run-time sql statements statistic
• Subquery Factoring (4)
  Oracle Scratchpad Jonathan Lewis on subquery factoring
  with cbo factoring lewis oracle scratchpad subquery troubleshooting tuning
• Surachart Opun's Blog: ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200] lsts[0]]
  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]]
  with attribute error ora-29786 pfile siha spfile
• The Oracle PL/SQL WITH Clause
  with clause factoring oracle plsql psoug subquery with
• TZ_OFFSET
  shows how offset can vary depending upon daylight savings time
  with database dst est offset oracle timezone tz_offset
• Using Dbms_Advisor.Tune_Mview To Optimize Materialized Views For Fast Refresh (Doc ID 249993.1)
  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.
  with count defining dml due error fast inserts materialized ora-32314 original refresh restrictions statement view
  Note: Restrictions of fast refresh of Materialized Views after DML.
• Using Oracle Virtual Private Database to Control Data Access
  database views to understand policies, functions, etc.
  with 11gr2 fgac oracle package policy_function policy_name policy_type sys_context vpd
• Using Sql Tuning Advisor – Sql Profile
  Chen Guang's Blog Using Sql Tuning Advisor – Sql Profile
  with advisor dbms_sqltune scripts sql task tuning
• Virtual Column Partitioning Tips
  virtual column and partition by this derived column
  with 11gr2 column derived oracle oracle11g partition subpartition virtual
• Vish Vangapally's Blog
  Vangapally
  with 11g dba learning listener network oracle scripts sql vangapally vish
• 10.5 Specifying Partitions :: Chapter 10. Partitioning :: Mastering Oracle SQL :: SQL :: eTutorials.org
  SUBPARTITION clause to focus on a single subpartition of the table.
  with 11g 11gr2 clause focus oracle partition partition_extension single subpartition table
• Ask Tom "Pivot Query"
  with 11g asktom db kyte oracle pivot query tom
• Bloom filters for DBAs
  Julian Dontcheff's Database Blog
  with blog bloom database filters julian
• Convert Oracle Timestamp to STRING - Oracle Forums
  SELECT TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS') AS my_date FROM DUAL
  with my_date systimestamp to_char
• DBMS_PARALLEL_EXECUTE
  parallel control of DML
  with 11g data dbms dbms_parallel_execute incremental loading oracle package parallel
• Dropping a disk in an ASM Disk Group | jarneil
  with system:unfiled
• How do adaptive cursor sharing and SQL Plan Management interact? (Oracle Optimizer)
  How do adaptive cursor sharing and SQL Plan Management interact?
  with acs adaptive aware bind bind_aware cursor interact management plan profile sharing spm sql
• How Parallel Execution Works
  Oracle doc
  with controlling execution oracle parallel
• How to Use Oracle VM VirtualBox Templates
  How to download, import, and configure Oracle VM VirtualBox Templates in Oracle VM VirtualBox updated 2012
  with oracle virtualbox vm

Bookmarks 41 - 60 « Previous Next »