Confio Software Support Site http://support.confio.com Database performance management with Confio Software and Ignite products. Copyright 2012 Confio Software Wed, 16 May 2012 23:05:34 PDT Qcodo Development Framework 0.3.21 (Qcodo Beta 3) http://blogs.law.harvard.edu/tech/rss http://support.confio.com/assets/images/confio-logo.gif Confio Software Support Site http://support.confio.com Welcome to the Confio Database Performance Blog http://support.confio.com/blog/post_view.php?intPostId=5 You are looking at a new feature for the Confio Support site, one that is intended to benefit not just our Ignite using customers, but also other DBAs looking for fresh perspectives on best practice... Don B. General http://support.confio.com/blog/post_view.php?intPostId=5 Tue, 01 Jul 2008 02:20:00 PDT Why Execution Plans with Predicates are an Important Tuning Tool http://support.confio.com/blog/post_view.php?intPostId=6 Dean R. Case Studies http://support.confio.com/blog/post_view.php?intPostId=6 Wed, 02 Jul 2008 12:45:00 PDT <![CDATA[The Proper Care & Feeding Of Ignite Monitors.]]> http://support.confio.com/blog/post_view.php?intPostId=7 Janis G. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=7 Mon, 07 Jul 2008 09:36:00 PDT Solving Waits on "enq: TM - contention" http://support.confio.com/blog/post_view.php?intPostId=8 Dean R. Wait Time Analysis http://support.confio.com/blog/post_view.php?intPostId=8 Mon, 14 Jul 2008 04:55:00 PDT Using DBMS_APPLICATION_INFO for More Detailed Wait Analysis http://support.confio.com/blog/post_view.php?intPostId=9 Sometimes Ignite for Oracle and other tools will show waits associated with a PL/SQL call, e.g. BEGIN CONCAP.QUICKPOLL ('ORA102_TESTBOX', TRUE); END; In our case, the QUICKPOLL procedure is very... Dean R. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=9 Fri, 25 Jul 2008 12:25:00 PDT Tuning "IS NULL" Query Criteria with Clever Indexing Strategy http://support.confio.com/blog/post_view.php?intPostId=10 Dean R. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=10 Mon, 28 Jul 2008 03:47:00 PDT Using Histograms to Help Oracle Cost-Based Optimizer Make Better Decisions http://support.confio.com/blog/post_view.php?intPostId=11 Dean R. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=11 Thu, 07 Aug 2008 03:54:00 PDT Ignite Errors when Collecting Plan Information http://support.confio.com/blog/post_view.php?intPostId=12 Dean R. General http://support.confio.com/blog/post_view.php?intPostId=12 Fri, 08 Aug 2008 01:13:00 PDT Why Won't My Oracle Jobs Run? http://support.confio.com/blog/post_view.php?intPostId=13 Janis G. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=13 Wed, 13 Aug 2008 04:02:00 PDT Top Objects finds PK Index http://support.confio.com/blog/post_view.php?intPostId=14 Dallas D. Wait Time Analysis http://support.confio.com/blog/post_view.php?intPostId=14 Fri, 31 Oct 2008 10:54:00 PDT Looking at Linux Utilization with sar and Oracle’s V$OSSTAT http://support.confio.com/blog/post_view.php?intPostId=15 (This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.) With the advent of the new... Guest . Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=15 Thu, 26 Feb 2009 08:36:00 PST Comparing and Merging Divergent Data; Just Darn Fun! http://support.confio.com/blog/post_view.php?intPostId=16 (This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.) Extracting and loading data from... Guest . General http://support.confio.com/blog/post_view.php?intPostId=16 Fri, 13 Mar 2009 11:10:00 PDT Extended Optimizer Statistics in 11g http://support.confio.com/blog/post_view.php?intPostId=17 (This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.) Better execution plans for faster... Guest . Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=17 Tue, 14 Apr 2009 08:48:00 PDT Finding Usable Oracle Database Indexes http://support.confio.com/blog/post_view.php?intPostId=18 (This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.) The rules of slap-happy data... Guest . Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=18 Wed, 29 Apr 2009 01:23:00 PDT SQL Saturdays http://support.confio.com/blog/post_view.php?intPostId=19 Janis G. General http://support.confio.com/blog/post_view.php?intPostId=19 Fri, 01 May 2009 09:02:00 PDT Invisible Indexes in Oracle 11g http://support.confio.com/blog/post_view.php?intPostId=20 Don B. Wait Time Analysis Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=20 Fri, 15 May 2009 09:24:00 PDT Wait Time and Response Time http://support.confio.com/blog/post_view.php?intPostId=21 Don B. Wait Time Analysis General http://support.confio.com/blog/post_view.php?intPostId=21 Thu, 28 May 2009 08:48:00 PDT Oracle Wait Event Explained: Direct Path Read Temp http://support.confio.com/blog/post_view.php?intPostId=22 This discussion of an Oracle Wait Event comes from James Koopmann of Pinehorse, Inc., an Oracle expert consultant and friend of Confio. Understanding Oracle Wait Events is important in diagnosing... Don B. Wait Time Analysis General http://support.confio.com/blog/post_view.php?intPostId=22 Thu, 11 Jun 2009 10:03:00 PDT Performance Improvements with Oracle 11g Data Types http://support.confio.com/blog/post_view.php?intPostId=23 Performance Improvements with 11g Data Type Numeric operations in Oracle are a great opportunity for performance improvement. Oracle 11g provides a new data type that will reduce some of the... Don B. Performance Strategies General http://support.confio.com/blog/post_view.php?intPostId=23 Mon, 20 Jul 2009 04:33:00 PDT Row Cache Lock Wait Understood http://support.confio.com/blog/post_view.php?intPostId=24 Don B. Wait Time Analysis General http://support.confio.com/blog/post_view.php?intPostId=24 Wed, 19 Aug 2009 05:17:00 PDT The Best Things About Ignite...(from a customer) http://support.confio.com/blog/post_view.php?intPostId=25 Don B. General http://support.confio.com/blog/post_view.php?intPostId=25 Fri, 18 Sep 2009 01:49:00 PDT Error install Oracle 11g on CentOS - libmawt.so: Can't load IA 32-bit .so on IA 32bit platform http://support.confio.com/blog/post_view.php?intPostId=26 I am setting up an Oracle 11g database environment on CentOS linux and ran into the following error from the runInstaller script: java.lang.UnsatisfiedLinkError:... Dean R. General http://support.confio.com/blog/post_view.php?intPostId=26 Fri, 04 Dec 2009 11:24:00 PST Web Monitoring from within PL/SQL and Ignite http://support.confio.com/blog/post_view.php?intPostId=27 Dean R. Performance Strategies General http://support.confio.com/blog/post_view.php?intPostId=27 Thu, 10 Dec 2009 11:13:00 PST Over-allocated Space for Tables in Oracle http://support.confio.com/blog/post_view.php?intPostId=28 Dean R. Performance Strategies http://support.confio.com/blog/post_view.php?intPostId=28 Wed, 06 Jan 2010 10:23:00 PST 1000% Performance Improvement Using Oracle 11g Result Cache http://support.confio.com/blog/post_view.php?intPostId=29 Dean R. Wait Time Analysis Performance Strategies Case Studies General http://support.confio.com/blog/post_view.php?intPostId=29 Tue, 09 Feb 2010 09:05:00 PST Ignite 8 is Here http://support.confio.com/blog/post_view.php?intPostId=30 The latest version of Ignite Goes Beyond Response-Time Metrics to Deliver Comprehensive Database Performance Analysis. In past product versions, Ignite was often used in conjunction with other... Don B. General http://support.confio.com/blog/post_view.php?intPostId=30 Tue, 02 Mar 2010 02:33:00 PST