<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Tanel Poder's blog: Core IT for Geeks and Pros</title>
	<link>http://blog.tanelpoder.com</link>
	<description>Oracle troubleshooting, internals and performance tuning</description>
	<lastBuildDate>Sat, 20 Feb 2010 06:10:32 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>How to CANCEL a query running in another session?</title>
		<description><![CDATA[Here&#8217;s a treat for Oracle geeks, hackers and maniacs out there&#8230;
Update: As the beginning says, this article was meant as something interesting about Oracle&#8217;s internals and CTRL+C / OCICancel() handling. There&#8217;s a more practical way for canceling session calls if you are running Oracle Enterprise Edition and are currently using resource manager:
You can set the [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/17/how-to-cancel-a-query-running-in-another-session/</link>
			</item>
	<item>
		<title>A Free afternoon seminar in Singapore (24th Feb)</title>
		<description><![CDATA[If you are in Singapore and have 24th Feb afternoon available then you can register and join a free Oracle performance troubleshooting seminar I&#8217;m doing in Singapore Management University&#8217;s (SMU) campus.
The seminar will be about:

Systematic Oracle Performance Troubleshooting
Identifying performance troublemakers
Understanding execution plans

The date is Wednesday, 24th Feb
The seminar time is from 15:30-19:00 (don&#8217;t be late)
Registration [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/17/a-free-afternoon-seminar-in-singapore-24th-feb/</link>
			</item>
	<item>
		<title>New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning</title>
		<description><![CDATA[The LatchProf and LatchProfX scripts allow you to be more systematic with latch contention troubleshooting and tuning. No more guesswork is needed as these scripts give you exact session IDs and in this version also SQLIDs of the troublemaking applications.
You can download the new versions here:

LatchProf (reads V$ views)
LatchProfX (reads X$ tables, but gives better [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/15/new-versions-of-latchprof-and-latchprofx-for-latch-contention-troubleshooting-and-tuning/</link>
			</item>
	<item>
		<title>Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!</title>
		<description><![CDATA[I have written the first article to the troubleshooting section of my new website tech.E2SN.com:
It&#8217;s about a very valuable Oracle troubleshooting tool -&#62; ERRORSTACK trace.
I cover 4 frequently asked questions there:

Reading the current executing SQL statement text from errorstack trace
Reading the current executing PL/SQL package and PL/SQL source code line number from errorstack trace
Reading the [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/14/oracle-troubleshooting-how-to-read-oracle-errorstack-output/</link>
			</item>
	<item>
		<title>Future appearances, conferences and seminars</title>
		<description><![CDATA[Just to let you know where I&#8217;ll be in the near future :)
Seminars
Advanced Oracle Troubleshooting 2.0
I have rearranged and adjusted the material so it flows smoother,  has even more practical tools and scripts and describes some internals  even deeper ;-)


3-5 March &#8211; New  York
15-17 March &#8211;  San Francisco

These dates are close, [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/11/future-appearances-conferences-and-seminars/</link>
			</item>
	<item>
		<title>Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris</title>
		<description><![CDATA[I just published a new script and article about calculating the real Oracle process memory usage on Solaris.
The problem with V$PROCESS* views (and the V$SESSTAT) is that they will tell you what Oracle thinks it&#8217;s using, not the real amount of memory used. There will be discrepancies due how memory is actually allocated in OS, [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/11/using-process-memory-matrix-script-for-calculating-oracle-process-memory-usage-on-solaris/</link>
			</item>
	<item>
		<title>Oracle Wait Event reference</title>
		<description><![CDATA[Kyle Hailey has started putting together a much needed Oracle wait event reference.
You can access it here.
By the way, Oracle documentation also has a wait event reference section, it has more events, but it&#8217;s less detailed&#8230;
I have plans to go deep into some wait events and cover some less common ones in tech.E2SN too&#8230; in [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/09/oracle-wait-event-reference/</link>
			</item>
	<item>
		<title>Oracle Peformance Visualization&#8230;</title>
		<description><![CDATA[Coskan Gundogar and Karl Arao have written two interesting articles about Oracle performance analysis and visualization, check these out!
Coskan&#8217;s article:

http://coskan.wordpress.com/2010/01/27/working-with-statspack-part-1a-diagnosis/

Karl&#8217;s article:

http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/

Note that in March I will be releasing PerfSheet v3.0, which will have lots of improvements! ;-)
 ]]></description>
		<link>http://blog.tanelpoder.com/2010/02/03/oracle-peformance-visualization/</link>
			</item>
	<item>
		<title>Bind Variable Peeking &#8211; execution plan inefficiency</title>
		<description><![CDATA[In my Beyond Oracle Wait interface article I troubleshooted a test case where an execution plan somehow went &#8220;crazy&#8221; and started burning CPU, lots of logical IOs and the query never completed.
I have uploaded the test case I used to my new website, to a section where I will upload some of my demo scripts [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/02/02/bind-variable-peeking-execution-plan-inefficiency/</link>
			</item>
	<item>
		<title>New seminars and dates announced</title>
		<description><![CDATA[I have been very busy over last months (as you see from the lack of blog entries). Part of the reason is that I&#8217;ve been building new seminar material and now I&#8217;m pleased to announce some first seminar dates!
I have updated new seminar dates and cities in m new webpage:

http://tech.e2sn.com/oracle-training-seminars

From April 2010 I offer total [...]]]></description>
		<link>http://blog.tanelpoder.com/2010/01/27/new-seminars-and-dates-announced/</link>
			</item>
</channel>
</rss>
