Thank you for all those attended my sessions during Collaborate 2010. Two of the sessions I presented were not mine; but that of Riyaj Shamsuddin. Riyaj was stuck in Denmark thanks to the ash cloud scenario in Europe and asked if I could present his. I agreed to and, with a lot of trepidation, I did. I hope I did justice to the sessions. For questions on those sessions, please reach out to Riyaj directly.
Tony’s Oracle Tips
Sean's Oracle Share
Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).
TitlePresenterSlidesVideo [...]
Arrived at Munich Pasing last night at 0:50am ... finally :-)
So, something else I learned recently...
Say you have a table T:
ops$tkyte%ORA10GR2> create table t ( x int );
Table created.
ops$tkyte%ORA10GR2> insert into t values ( 1 );
1 row created.
ops$tkyte%ORA10GR2> commit;
Commit complete.
and you update a row in that table:
ops$tkyte%ORA10GR2> update t set x = x+1;
1 row updated.
and using an evil autonomous transaction you try to lock that row (in the same session, but a new transaction - one that cannot 'see' the effects of the parent transaction)
Apr 20, 2010 7:00am
What ErrorI have been playing the PL/SQL Challenge quiz every day. It’s a great way to brush up on my PL/SQL skills. After many years of using PL/SQL, I am still learning about features that I have never known before or totally forgotten about. Take for example one of last week’s quiz questions: What is the [...] The exception we never knew we neededIf, by some great random cosmic chance, you are a reader of this blog, but not of Tom Kyte’s, then you would have missed this post: To find out CPU info in Solaris/usr/sbin/psrinfo -v | grep "Status of virtual processor" | wc -l |