http://www.netvouz.com/MondoTofu/folder/8988893024450568004/Oracle+Optimization?feed=rss&pg=1 MondoTofu's bookmarks in folder Optimization on Netvouz http://www.oracle-base.com/articles/11g/automatic-sql-tuning-11gr1.php Automatic SQL Tuning in Oracle Database 11g Release 1 Oracle > Optimization MondoTofu Fri, 20 Jul 2012 15:34:19 GMT http://www.oracle-base.com/articles/10g/automatic-sql-tuning-10g.php How to execute SQL tuning task on SQL_ID Oracle > Optimization MondoTofu Mon, 12 May 2014 16:15:44 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-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof.php 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 Oracle > Optimization MondoTofu Thu, 28 Aug 2014 13:59:45 GMT http://www.sqlpanda.com/2013/02/sql-access-advisor-saa.html 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. Oracle > Optimization MondoTofu Tue, 30 Aug 2016 13:21:02 GMT http://blog.yannickjaquier.com/oracle/sql-access-advisor-versus-sql-tuning-advisor.html SQL Access Advisor versus SQL Tuning Advisor sql tuning set workload recommendations Oracle > Optimization MondoTofu Wed, 12 Aug 2015 17:53:45 GMT http://fshaikh.wordpress.com/2011/01/09/trace-a-concurrent-request-and-generate-tkprof-file/ 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 Oracle > Optimization MondoTofu Wed, 10 Sep 2014 02:37:18 GMT http://www.perfdynamics.com/Manifesto/USLscalability.html Universal Scalability Law -- spreadsheets and newer content, links to Guerilla Capacity planning, etc. Oracle > Optimization MondoTofu Mon, 10 Dec 2012 13:25:25 GMT http://psoug.org/reference/dbms_sqltune.html Access information on SQL Tuning Tasks previously executed Oracle > Optimization MondoTofu Thu, 10 Apr 2014 13:51:13 GMT https://richardfoote.wordpress.com/?s=rebuild&searchbutton=go%21 Search Results | Richard Foote's Oracle Blog On Index Rebuilds Oracle > Optimization MondoTofu Tue, 20 Feb 2018 19:18:25 GMT