http://netvouz.com/MondoTofu/tag/sql?feed=rss&pg=1 MondoTofu's bookmarks tagged "sql" on Netvouz https://docs.oracle.com/database/121/TGSQL/tgsql_profiles.htm#TGSQL613 Transporting a SQL Profile Oracle > Optimization MondoTofu Sat, 25 Apr 2015 14:40:45 GMT http://www.dba-oracle.com/oracle_tips_unused_indexes.htm Find unused Indexes by querying AWR Oracle > DB 11g MondoTofu Tue, 24 Mar 2015 19:56:09 GMT http://ora-performance-tuning.blogspot.com/2013/12/awr-reports-introduction-awr.html Descriptive information in AWR 11g special scripts Automatic Workload Repository Report awrrpt.sql Automatic Database Diagnostics Monitor Report addmrpt.sql ASH Report ashrpt.sql AWR Diff Periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql Oracle > Optimization MondoTofu Fri, 17 Jul 2015 16:38:12 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://docs.oracle.com/cd/E11882_01/appdev.112/e16760/d_sqltun.htm DBMS_SQLTUNE Package 11.2 PL/SQL package description Oracle > Optimization MondoTofu Mon, 21 Apr 2014 15:11:04 GMT http://psoug.org/reference/hints.html Decent overview of hints you can use in either PL/SQL or SQL routines. Especially helpful for me was CACHE hint that I used in Subquery factoring (WITH clause). Oracle > PL/SQL 11g MondoTofu Fri, 12 Jul 2013 18:13:52 GMT http://aberdave.blogspot.com/2010/05/importing-iso-8061-timestamps-using.html Troubleshooting and Tuning: Importing ISO 8061 timestamps using sqlldr CDISC MondoTofu Fri, 08 Nov 2013 21:24:29 GMT http://www.thatjeffsmith.com/data-modeling/ http://www.thatjeffsmith.com/data-modeling/ Oracle > Oracle Tips > Data Modeling MondoTofu Fri, 14 Aug 2015 14:21:39 GMT http://www.thatjeffsmith.com/archive/2013/07/oracle-sql-developer-4-0-is-finally-here/ Notes on new features, workarounds, bugs in Early Adopter release of SQL Developer 4.0 ( started July 2013) Oracle > Oracle Tips > SQL Developer MondoTofu Mon, 29 Jul 2013 16:06:25 GMT http://docs.oracle.com/cd/E35137_01/index.htm Oracle > DB 11g MondoTofu Fri, 05 Apr 2013 00:39:16 GMT