Netvouz / MondoTofu / folder / DB 11g http://netvouz.com/MondoTofu/folder/9169064117513692344/Oracle+DB+11g?feed=rss&pg=1 MondoTofu's bookmarks in folder DB 11g on Netvouz Format Models http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements004.htm#SQLRF00210 Oracle TO_DATE, TO_NUMBER, TO_CHAR with formats and examples Oracle > DB 11g MondoTofu Wed, 19 Mar 2014 17:14:50 GMT How do I force a query to use bind-aware cursor sharing? (Oracle Optimizer) https://blogs.oracle.com/optimizer/entry/how_do_i_force_a How do I force a query to use bind-aware cursor sharing? Oracle > DB 11g MondoTofu Fri, 20 Jun 2014 14:31:09 GMT How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko http://www.bluegecko.net/oracle/how-to-max-out-your-fast-refresh-materialized-views/ DBMS_ADVISOR.TUNE_MVIEW, Oracle > DB 11g MondoTofu Thu, 24 Jul 2014 13:37:22 GMT How to get the last executed SQL statement and bind variable values in oracle http://stackoverflow.com/questions/1707291/how-to-get-the-last-executed-sql-statement-and-bind-variable-values-in-oracle Inspecting the bind variables for a given sql_id in Oracle 11g Oracle > DB 11g MondoTofu Thu, 05 Jun 2014 12:59:46 GMT How to stop a running job of DBMS_JOB ? http://halimdba.blogspot.com/2009/11/how-to-stop-running-job-of-dbmsjob.html Oracle Exclusive Mark it broken and commit Oracle > DB 11g MondoTofu Mon, 11 Mar 2013 17:57:31 GMT improving performance with pipelined table functions http://www.oracle-developer.net/display.php?id=429 Excerpt on pipelined table functions from Feuerstein book on PL/SQL Oracle > DB 11g MondoTofu Fri, 28 Dec 2012 20:10:09 GMT Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Oracle Optimizer) https://blogs.oracle.com/optimizer/entry/incremental_statistics_maintenance_what_statistics strategies for gathering statistics DML new feature 11g; helpful for partitioned tables Oracle > DB 11g MondoTofu Sun, 27 Apr 2014 01:39:24 GMT Kerry Osborne’s Oracle Blog » Blog Archive » Flush A Single SQL Statement – Kerry Osborne’s Oracle Blog 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 Kerry Osborne’s Oracle Blog » Blog Archive » What Did My New Index Mess Up? – Kerry Osborne’s Oracle Blog http://kerryosborne.oracle-guy.com/2009/06/what-did-my-new-index-mess-up/ find significantly different average elapsed times per execution. It uses AWR data and computes a normalized standard deviation between the average elapsed time per execution before and after the date specified by the days_ago parameter Oracle > DB 11g MondoTofu Fri, 06 Jun 2014 15:02:24 GMT listagg function in 11g release 2 http://www.oracle-developer.net/display.php?id=515 Adrian Billington teaches listagg function with examples, GROUP BY , comparison of alternates to listagg, including WM_CONCAT and CAST with COLLECT Oracle > DB 11g MondoTofu Fri, 31 May 2013 13:46:07 GMT