Skip to content

Author Archives Tanel Poder

How to CANCEL a query running in another session?

Here’s a treat for Oracle geeks, hackers and maniacs out there…
Update: As the beginning says, this article was meant as something interesting about Oracle’s internals and CTRL+C / OCICancel() handling. There’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 [...]

Posted 18 February 2010 § Uncategorized ‡ Comments Off °

A Free afternoon seminar in Singapore (24th Feb)

If you are in Singapore and have 24th Feb afternoon available then you can register and join a free Oracle performance troubleshooting seminar I’m doing in Singapore Management University’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’t be late)
Registration [...]

Posted 17 February 2010 § Uncategorized ‡ Comments Off °

New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning

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 [...]

Posted 16 February 2010 § Uncategorized ‡ Comments Off °

Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!

I have written the first article to the troubleshooting section of my new website tech.E2SN.com:
It’s about a very valuable Oracle troubleshooting tool -> 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 [...]

Posted 14 February 2010 § Uncategorized ‡ Comments Off °

Future appearances, conferences and seminars

Just to let you know where I’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 – New York
15-17 March – San Francisco

These dates are close, [...]

Posted 11 February 2010 § Uncategorized ‡ Comments Off °

Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris

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’s using, not the real amount of memory used. There will be discrepancies due how memory is actually allocated in OS, [...]

Posted 11 February 2010 § Uncategorized ‡ Comments Off °

Oracle Wait Event reference

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’s less detailed…
I have plans to go deep into some wait events and cover some less common ones in tech.E2SN too… in [...]

Posted 09 February 2010 § Uncategorized ‡ Comments Off °