• How to select statements from AWR? (Upgrade your Database - NOW!)
  How to pick SQL statements out of AWR to create a workload for DBMS_Advisor runs
  with 11g access advisor awr basic_filter dbms_advisor dbms_sqltune filter plsql select_workload_repository sql sqlaccess tuning workload
• Kerry Osborne Oracle Blog Blog Archive Unstable Plans (Oracle Plan Stability/Instability) – Kerry Osborne’s Oracle Blog
  unstable plans what changed oracle execution awr snapshot
  with awr change plan
• Kerry Osborne’s Oracle Blog » Blog Archive » SQL Profiles – Kerry Osborne’s Oracle Blog
  with archive blog kerry oracle osborne’s profiles sql » –
• Kerry Osborne’s Oracle Blog » Blog Archive » Tracking Parameter Changes – Kerry Osborne’s Oracle Blog
  tracking changes, retain AWR history
  with awr repository retention workload
• Kyle Hailey » Wait Metrics vs Wait Events
  with capture events hourly io metrics sql v$system_event wait waits
• Managing SQL Profiles
  Transporting a SQL Profile
  with performance profile sql transporting
• Oracle 11g R2 Performance Tuning -AWR
  Descriptive information in AWR 11g special scripts Automatic Workload Repository Report awrrpt.sql Automatic Database Diagnostics Monitor Report addmrpt.sql ASH Report ashrpt.sql AWR Diff Periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql
  with 11g automatic awr awrrpt.sql diagnostics optimization oracle report reports repository scripts sql workload
• Oracle DBA's Blog
  Degree of Parallelism - 11gR2 feature
  with 11gr2 calibration degree feature io parallelism
• Oracle DBMS_SQLTUNE documentation page
  DBMS_SQLTUNE Package 11.2 PL/SQL package description
  with 11.2 oracle package sql task tuning
• Oracle SQL Tuning Tools and Tips
  SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics
  with adaptive bind cursor data sharing skewed sql variables
• ORACLE-BASE
  Automatic SQL Tuning in Oracle Database 11g Release 1
  with advisor automatic dbms_sqltune oracle sql sys_auto_sql_tuning_task task tune tuning
• ORACLE-BASE
  How to execute SQL tuning task on SQL_ID
  with id optimization oracle sql sql_id task tuning
• ORACLE-BASE - SQL Performance Analyzer in Oracle Database 11g Release 1
  Creating SQL Tuning Sets using the DBMS_SQLTUNE Package
  with 11g 11gr2 dbms_sqltune oracle package performance sql tuning
• ORACLE-BASE - SQL trace, 10046, trcsess and tkprof in Oracle
  SQL trace, 10046, trcsess and tkprof in Oracle The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility. Trace files are found in v$diag_info view
  with 10046 capture event file files oracle sql time tkprof trace trc user utility v$diag_info
• SQL Access Advisor (SAA) | SQL Panda
  SAA is tuning base on the single SQL statement but the SAA consider the overall system. For example, when SAA recommend to create the index on the table. The SAA would also consider the index could cause the impact for other query.
  with access advisor query recommend saa sql statement system table tuning
• SQL Access Advisor versus SQL Tuning Advisor
  SQL Access Advisor versus SQL Tuning Advisor sql tuning set workload recommendations
  with access advisor recommendations set sql tuning versus workload
• Trace a Concurrent Request And Generate TKPROF File « Thirst for Oracle !!!
  Another example: To get (TKPROF) sorted by longest running queries first and limits the results to the “Top 10″ long running queries $ tkprof raw_trace_file.trc output_file sys=no explain=apps/ sort=’(prsela,exeela,fchela)’ print=10 Usage: tkprof
  with exeela explain fchela longest print prsela running tkprof usage
• How to Quantify Scalability - Neil Gunther
  Universal Scalability Law -- spreadsheets and newer content, links to Guerilla Capacity planning, etc.
  with alpha analysis beta excel performance scalability spreadsheet throughput visualization
• Oracle DBMS_SQLTUNE ADDM Grid
  Access information on SQL Tuning Tasks previously executed
  with advisor explain oracle plans recommendations sql sta tuning
• rebuild
  Search Results | Richard Foote's Oracle Blog On Index Rebuilds
  with blog footes index oracle rebuilds richard

Bookmarks 1 - 20 Next »