Feed items
Reminder and Public Appearances 2011
First, a reminder – my Advanced Oracle Troubleshooting v2.0 online seminar starts next week already. Last chance to sign up, I can accept registrations until Sunday :-) I won’t do another AOT seminar before Oct (or Nov) this year. More details and sign-up here: http://tech.e2sn.com/oracle-training-seminars I have rescheduled my Advanced SQL Tuning and Partitioning & [...]
Latch contention troubleshooting case study and Flashback Database performance issues with LOBs
Steve Bamber has written up a case study of library cache latch contention troubleshooting of an Apex application with LatchProf. I’m happy that others also see the value and have had success with my new LatchProf based latch contention troubleshooting approach which takes into account both sides of the contention story (latch waiters and latch [...]
Oracle Database XE (Express Edition) 11.2 beta is out!
Oracle Database XE (Express Edition) 11.2 Beta has been released! Here you go: http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html The documentation is here (the link at oracle.com/technetwork is broken right now…) I’m sure you want to know about it’s limitations, these are documented in the license guide above, but here are the main figures from Oracle XE 11.2 license guide: [...]
Oracle Troubleshooting TV Show: Season 1, Episode 01 ;-)
Ok, it’s official – the first and only Oracle Troubleshooting TV show is live now! The first show is almost 2 hours about the ORA-4031 errors and shared pool hacking. It’s a recording of the US/EMEA timezone online hacking session I did some days ago. There are a couple of things to note: The text [...]
MOATS: The Mother of All Tuning Scripts!
People talk about the Oracle SQL Developer 3 being out, which is cool, but I have something even cooler for you today ;-) I finally figured out how to convert my screen-recordings to uploadable videos, so that the text wouldn’t get unreadable and blurry. So, here’s the first video, about a tool called MOATS, which [...]
An index of my TPT scripts
A lot of people have asked me whether there’s some sort of index or “table of contents” of my TPT scripts (there’s over 500 scripts in the tpt_public.zip file – http://tech.e2sn.com/oracle-scripts-and-tools ) I have planned to create such index for years, but never got to it. I probably never will :) So a good way [...]
Update, things of interest and a couple of blogs to check out
tech.E2SN secret hacking session on Tuesday 22nd March: Just in case you missed it – there’s still chance to sign up to my tomorrow’s ORA-4031 and shared pool hacking session. I initially planned to limit the attendees to 100 per event (as the limited GotoWebinar package is cheaper that way) but over 100 people had [...]
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051)
A few days ago I looked into a SQL Tracefile of some LOB access code and saw a LOBREAD entry there. This is a really welcome improvement (or should I say, bugfix of a lacking feature) for understanding resource consumption by LOB access OPI calls. Check the bottom of the output below: *** 2011-03-17 14:34:37.242 [...]
Implicit datatype conversion in the parsing phase – something new I learned today!
Wow, I wasn’t aware that Oracle can also do an implicit datatype conversion for literal strings during parsing phase! SQL> @desc t Name Null? Type ------------------------------- -------- ---------------------------- 1 A NUMBER(38) SQL> select * from t where a = '1' || RPAD('0',5,'0'); no rows selected SQL> @x Display execution plan for last statement for this [...]
ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!
Free stuff! Free stuff! Free stuff! :-) The awesome dudes at E2SN have done it again! (and yes, Tom, this time the “we at E2SN Ltd” doesn’t mean only me alone ;-) On Tuesday 22nd March I’ll hold two (yes two) Secret Oracle Hacking Sessions – about ORA-04031: unable to allocate x bytes of shared [...]
