http://netvouz.com/MondoTofu/tag/sql?feed=rss&pg=2 MondoTofu's bookmarks tagged "sql" on Netvouz http://carlos-sierra.net/ SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics Oracle > Optimization MondoTofu Sat, 20 Jul 2013 18:56:51 GMT http://www.oracle-base.com/articles/misc/xml-over-http.php XML-Over-HTTP (REST Web Services) From PL/SQL Oracle > WebServices 11g MondoTofu Fri, 11 May 2012 15:29:18 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.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.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.orafaq.com/forum/t/120648/ NEW_TIME function to convert GMT to EST or EDT depending on day light saving time. Oracle > DB 11g MondoTofu Mon, 29 Aug 2016 18:46:41 GMT https://forums.oracle.com/forums/thread.jspa?messageID=10252652 Can't migrate 10g Forms to 11g: ALL SQL ... Oracle > Forms Reports 11gR2 MondoTofu Fri, 11 May 2012 13:33:37 GMT http://www.orafaq.com/maillist/oracle-l/2002/01/10/0795.htm START_DATE CHAR "TO_DATE(:START_DATE,'MM/DD/YY')" Oracle > Utilities MondoTofu Tue, 05 Jan 2016 22:58:28 GMT