Tanelpoder - blog.tanelpoder.com - Tanel Poder's Performance & Troubleshooting blog
General Information:
Latest News:
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too) 23 Aug 2013 | 02:03 am
My previous post was about Oracle 12c SQL Scalar Subquery transformations. Actually I need to clarify its scope a bit: the previous post was about scalar subqueries inside a SELECT projection list onl...
Enkitec is a finalist for the UKOUG Engineered Systems Partner of the Year Award 20 Aug 2013 | 07:52 pm
Enkitec has made it to the shortlist of UKOUG Partner of the Year Awards, in the Engineered Systems category. So if you like what we have done in the Exadata and Engineered Systems space, please cast ...
C-MOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support 19 Aug 2013 | 05:00 pm
So, how many of you do hate the dialog below? Good news – there is a fix! (or well, a hack around it ;) Before showing the fix, you can vote & give your opinion here: Do you love or hate the MOS “p...
Oracle 12c: Scalar Subquery Unnesting transformation 13 Aug 2013 | 07:55 pm
I promised to write about Oracle 12c new features quite a while ago (when 12c got officially released), but I was actually on (a long) vacation then and so many cool 12c-related white-papers and blog ...
Oracle Database 12c R1 (12.1.0.1.0) is finally released! 25 Jun 2013 | 11:39 pm
You can download it from http://edelivery.oracle.com And now I (and other beta testers) can finally start writing about the new cool features in it! :) Looks like only the Linux x86-64, Solaris x86-...
Getting the Most Out of ASH online seminar 6 Jun 2013 | 02:10 am
Just a little reminder – next week (10-11th June) I’ll be delivering my last training session before autumn – a short 1-day (2 x 0.5 days actually) seminar about Getting the Most Out of Oracle’s Activ...
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? 29 May 2013 | 05:38 pm
One of the most common Exadata performance problems I see is that the direct path reads (and thus also Smart Scans) don’t sometimes kick in when running full scans in serial sessions. This is because ...
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? 29 May 2013 | 05:38 pm
One of the most common Exadata performance problems I see is that the direct path reads (and thus also Smart Scans) don’t sometimes kick in when running full scans in serial sessions. This is because ...
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? 29 May 2013 | 05:38 pm
One of the most common Exadata performance problems I see is that the direct path reads (and thus also Smart Scans) don’t sometimes kick in when running full scans in serial sessions. This is because ...
Debugger Dangers – Part 2 27 May 2013 | 10:31 pm
About 5 years ago I wrote about the risks that connecting to Oracle processes via debuggers may cause and what are (in my opinion) the safer and less safer options for taking stack samples from runnin...
