http://netvouz.com/MondoTofu/tag/statement?feed=rss MondoTofu's bookmarks tagged "statement" on Netvouz 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://www.orafaq.com/forum/t/58536/ ORA-02287: sequence number not allowed here Oracle > PL/SQL MondoTofu Fri, 28 Aug 2015 15:21:42 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 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