http://netvouz.com/MondoTofu/tag/advisor?feed=rss MondoTofu's bookmarks tagged "advisor" on Netvouz https://blogs.oracle.com/UPGRADE/entry/how_to_select_statements_from How to pick SQL statements out of AWR to create a workload for DBMS_Advisor runs Oracle > Optimization MondoTofu Thu, 09 Apr 2015 20:19:53 GMT http://kerryosborne.oracle-guy.com/2008/09/flush-a-single-sql-statement/ Flush A Single SQL Statement DBMS_SHARED_POOL.PURGE Oracle > DB 11g MondoTofu Tue, 23 Aug 2016 13:24:23 GMT http://hrivera99.blogspot.com/2012/01/ora-00700-kesqsmakesql-invstatcputime.html ORA-00700 [kesqsMakeSql-invstat:cpuTime] Oracle > DB 11g MondoTofu Mon, 20 Aug 2012 13:16:51 GMT 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.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://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://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 http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm#CBBJHIGH Segment space advisor, DBA_RECOMMENDATIONS shrink compact savings Oracle > DB 11g MondoTofu Wed, 15 Oct 2014 16:09:05 GMT