<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Striving for Optimal Performance</title>
	<link>http://antognini.ch</link>
	<description></description>
	<lastBuildDate>Mon, 08 Mar 2010 21:23:42 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Inserts Experiencing an Increasing CPU Consumption</title>
		<description><![CDATA[Last week I had to analyze a strange performance problem. Since the cause/solution was somehow surprising, at least for me, I thought to share it with you.
Let me start by quickly describing the setup and what was done to reproduce the problem:

Database version: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 (64-bit)
Operating system: Solaris 10 (SPARC)
To [...]]]></description>
		<link>http://antognini.ch/2010/03/inserts-experiencing-an-increasing-cpu-consumption/</link>
			</item>
	<item>
		<title>Tracing VPD Predicates</title>
		<description><![CDATA[Even though a number of articles and blog posts have already been written on this topic (e.g. on Pete Finnigan’s site I found references dating back from 2003), from time to time I’m still asked “How to trace predicates generated by VPD?”. Hence, here’s yet another blog post about this topic…
Let’s setup the scene before [...]]]></description>
		<link>http://antognini.ch/2010/02/tracing-vpd-predicates/</link>
			</item>
	<item>
		<title>The Art of Application Performance Testing</title>
		<description><![CDATA[ If you are looking for a book that describes how to approach and carry out a performance testing project, don&#8217;t look further. Get a copy of The Art of Application Performance Testing: Help for Programmers and Quality Assurance (O&#8217;Reilly, 2009). In it Ian Molyneaux manages to cover, in 160 pages, a crucial topic that [...]]]></description>
		<link>http://antognini.ch/2010/01/the-art-of-application-performance-testing/</link>
			</item>
	<item>
		<title>Does the Query Optimizer Cost PX Distribution Methods?</title>
		<description><![CDATA[The short answer to this question is &#8220;yes&#8221;, it does. Unfortunately, the distribution costs are not externalized through the execution plans and, as a result, this limitation (yes, it is really a limitation in the current implementation, not a bug) confuses everyone that carefully look at the information provided in an execution plan of a [...]]]></description>
		<link>http://antognini.ch/2010/01/does-the-query-optimizer-cost-px-distribution-methods/</link>
			</item>
	<item>
		<title>Edition-Based Redefinition</title>
		<description><![CDATA[Upgrading critical applications can be very difficult. One of the main problems is that for reasons of availability, long downtimes cannot be periodically scheduled. Therefore, for such applications, it is desirable to implement online upgrades. This requires that the application in question, as well as any software used by the application (e.g. the database engine) [...]]]></description>
		<link>http://antognini.ch/2010/01/edition-based-redefinition/</link>
			</item>
	<item>
		<title>Join Elimination</title>
		<description><![CDATA[In some specific situations the query optimizer is able to completely avoid executing a join even if a SQL statement explicitly calls for it. Two are the cases currently covered by this optimization technique, which is called join elimination. The first one was introduced in Oracle Database 10g Release 2, the second one in Oracle [...]]]></description>
		<link>http://antognini.ch/2010/01/join-elimination/</link>
			</item>
	<item>
		<title>Chinese Edition of TOP Available!</title>
		<description><![CDATA[
Few weeks ago the Chinese Edition of my book, Troubleshooting Oracle Performance, was published by China-Pub! Honestly, this is something I did not expect when publishing the book.
Even though I still have to touch one of them myself, let me spend few words about it&#8230;
I still remember when I saw for the first time part [...]]]></description>
		<link>http://antognini.ch/2009/12/chinese-edition-of-top-available/</link>
			</item>
	<item>
		<title>Does CREATE INDEX Gather Global Statistics?</title>
		<description><![CDATA[You can add the COMPUTE STATISTICS clause to the CREATE INDEX statement. It instructs the SQL statement to gather and store index statistics in the data dictionary, while creating the index. This is useful because the overhead associated with the gathering of statistics while executing this SQL statement is negligible. In Oracle9i, the gathering of [...]]]></description>
		<link>http://antognini.ch/2009/12/does-create-index-gather-global-statistics/</link>
			</item>
	<item>
		<title>Instance Caging</title>
		<description><![CDATA[Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, for the first time, to limit the number of CPUs that can be used by a given instance. (By the way, note that this limit has no “impact” on the number of [...]]]></description>
		<link>http://antognini.ch/2009/11/instance-caging/</link>
			</item>
	<item>
		<title>Zero-Size Unusable Indexes and the Query Optimizer</title>
		<description><![CDATA[Zero-size unusable indexes and index partions is a small but useful feature of Oracle Database 11g Release 2. Simply put, its aim is to save space in the database by immediately releasing the segment associated to unusable indexes or index partitions. To illustrate this, let&#8217;s have a look to an example…

Create a partitioned table, insert [...]]]></description>
		<link>http://antognini.ch/2009/11/zero-size-unusable-indexes-and-the-query-optimizer/</link>
			</item>
</channel>
</rss>
