<?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>Sat, 17 Dec 2011 23:42:45 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Ad: The Oracle Query Optimizer 2-Day Seminar</title>
		<description><![CDATA[The 31st of January and 1st of February 2012 I will present a 2-day seminar about the Oracle query optimizer in Ballerup (DK). The event is organized by Miracle A/S. The content, which is based on the chapters 2, 4, 5, 6, 9 and 10 of my book, is the following:

Chapter 1 describes the life [...]]]></description>
		<link>http://antognini.ch/2011/12/ad-the-oracle-query-optimizer-two-day-seminar/</link>
			</item>
	<item>
		<title>Challenges and Chances of the 11g Query Optimizer</title>
		<description><![CDATA[Challenges and Chances of the 11g Query Optimizer is the name of a presentation I gave at several events (e.g. Trivadis Performance Days, Oracle OpenWorld, DOAG Konferenz, UKOUG Conference) throughout 2011. Its abstract is the following:
With every new release, the query optimizer is enhanced. Oracle Database 11g Release 1 and Release 2 are no exception [...]]]></description>
		<link>http://antognini.ch/2011/12/challenges-and-chances-of-the-11g-query-optimizer/</link>
			</item>
	<item>
		<title>Ad: Trivadis TechEvent 2011</title>
		<description><![CDATA[All Trivadis employees meet twice a year near Zurich for a unique conference called TechEvent.
The TechEvents, with up to 15 parallel sessions, are among the largest IT conferences in Switzerland. During two days, employees can attend sessions about a wide range of both technical and non-technical subjects.
Watch the following (German spoken) video to know more [...]]]></description>
		<link>http://antognini.ch/2011/12/ad-trivadis-techevent-2011/</link>
			</item>
	<item>
		<title>SQL Trace and Oracle Portal</title>
		<description><![CDATA[Recently I was involved in a project where I had to trace the database calls of an application based on Oracle Portal 10.1.4. The basic requirements were the following:

Tracing takes place in the production environment
Tracing has to be enable for a single user only
Instrumentation code cannot be added to the application

Given that Oracle Portal uses [...]]]></description>
		<link>http://antognini.ch/2011/11/sql-trace-and-oracle-portal/</link>
			</item>
	<item>
		<title>Debugging PL/SQL and Java Stored Procedures with JPDA</title>
		<description><![CDATA[In 2003 I published a paper entitled Debugging PL/SQL and Java Stored Procedures with JPDA. Its aim was to describe how to debug PL/SQL and Java code deployed into the database with JDeveloper 9i. Two weeks ago a reader of my blog, Pradip Kumar Pathy, contacted me because he tried, without success, to do something [...]]]></description>
		<link>http://antognini.ch/2011/10/debugging-plsql-and-java-stored-procedures-with-jpda/</link>
			</item>
	<item>
		<title>Ad: Der Oracle DBA &#8211; Handbuch für die Administration der Oracle Database 11gR2</title>
		<description><![CDATA[The book Der Oracle DBA (Hanser, 2011), which was written in German, is at last available!
I say “at last” because the authors worked on this project for not less than two years.
Who are the authors? Several colleagues of mine at Trivadis (Mirko Hotzy, Konrad Häfeli, Daniel Steiger, Sven Vetter, Peter Welker), Andrea Held, Lutz Fröhlich, [...]]]></description>
		<link>http://antognini.ch/2011/10/ad-der-oracle-dba-handbuch-fur-die-administration-der-oracle-database-11gr2/</link>
			</item>
	<item>
		<title>Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing</title>
		<description><![CDATA[The STATISTICS_LEVEL parameter controls a bunch of features. In addition to the documentation, also the V$STATISTICS_LEVEL view provides a list of the ones it controls.
SQL&#62; SELECT statistics_name, description, activation_level
  2  FROM v$statistics_level
  3  ORDER BY 3 DESC, 1;

STATISTICS_NAME              [...]]]></description>
		<link>http://antognini.ch/2011/09/impact-of-statistics_level-on-cardinality-feedback-and-adaptive-cursor-sharing/</link>
			</item>
	<item>
		<title>optimizer_secure_view_merging and VPD</title>
		<description><![CDATA[At page 189 of TOP I wrote the following piece of text:
In summary, with the initialization parameter optimizer_secure_view_merging set to TRUE, the query optimizer checks whether view merging could lead to security issues. If this is the case, no view merging will be performed, and performance could be suboptimal as a result. For this reason, [...]]]></description>
		<link>http://antognini.ch/2011/09/optimizer_secure_view_merging-and-vpd/</link>
			</item>
	<item>
		<title>ITL Waits – Changes in Recent Releases (script)</title>
		<description><![CDATA[A reader of this blog, Paresh, asked me  how I was able to find out the logic behind ITL waits without having access to Oracle code. My reply was: I wrote a test case that reproduce ITL waits and a piece of code that monitors them.
Since other readers might be interested, here is the [...]]]></description>
		<link>http://antognini.ch/2011/06/itl-waits-%e2%80%93-changes-in-recent-releases-script/</link>
			</item>
	<item>
		<title>Ad: DOAG Berliner Expertenseminare (Last Call)</title>
		<description><![CDATA[I was just informed that there are still some free seats for the 2-day seminar I will present in Berlin in two weeks (June 7-8). Hence, do not wait too long if you want to join us&#8230;
The content is based on the chapters 4, 5, 6 and 7 of my book, i.e. part 3: Query [...]]]></description>
		<link>http://antognini.ch/2011/05/ad-doag-berliner-expertenseminare-last-call/</link>
			</item>
</channel>
</rss>

