Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

December 6, 2007

UKOUG DAY 3

Filed under: Oracle Events — H.Tonguç Yılmaz @ 8:31 am

Up to now both Birmingham and Ukoug conference were very satisfactory, I enjoyed the first three days very much. After a 30-45 minutes random walk we found at the end of the New Street the St Martin’s Church, a beautiful scene since it is Christmas time, and two books stores near the Church which I will be mining tonight after Ukoug ends. Also as they told me, “Once pubed, never stopped”, this is a reality in fact, and can easily ruin the conference :)

DB Time Performance method by Graham Wood

Programming real applications with Application Express by Andrew Woodward

Every Performance Problem Is One Of Two Things by James Morle

And here comes my second great presentation at Ukoug, John was prepared well and he was excellent during the presentation. Debugging APEX Applications by John Scott

Modelling on the cheap by Andrew Clarke

Real World Database Recovery – An Experience by James Hetherington

Understanding and Interpreting Deadlocks: What to do with an ORA-00060 by Mark Bobak

PL/SQL Tracking and Tracing Instrumentation for Developers by Tim Scott

Extending Security with Oracle Database Vault by Joel Goodman

Swingbench, When you need a load by Dominic Giles After this presentation since I am a PL/SQL dinasour :) I thought this can be done easily within Oracle, why not an open source project based on DBMS_SCHEDULER and APEX technology for inputs of load and reports. Hüsnü has already a loading Oracle series, and maybe there is already some.

After surviving 10 sessions on my third day today it will be a child play I guess :) But because of the long way waiting back to home I plan to post the last day’s notes on this Sunday.

4 Comments »

  1. I saw Johns presentation at OOW, he did really well and it was very interesting! I like his style of showing things.

    BTW, instead of “if v(‘DEBUG’) = ‘YES’ then” you can also use the global variable “if apex_application.g_debug then” which is a little bit nicer because there is not so much hard coding. Anyway, the IF can be skipped if the apex_application.debug procedure is used for logging, because it will automatically do the IF inside the procedure.

    Have fun in UK
    Patrick

    Comment by Patrick Wolf — December 6, 2007 @ 8:52 am | Reply

  2. Thanks for the very kind feedback, it was a *HUGE* hall and it was really difficult to see the audience to see whether people where yawning or looking with interest!

    Patrick,

    You must have been jetlagged at OOW as I covered g_debug there and mentioned about the hard-coding too ;)

    John.

    Comment by John Scott — December 6, 2007 @ 11:12 am | Reply

  3. For many practical purposes it may be good to use a PL/SQL based loading toolkit. But notice that when you measure with a tool within the environment itself you also measure the latencies, waits, execution time due to PL/SQL or DBMS_SCHEDULER functionality. So measuring with a tool out of the test environment will be a better approach as SW does.

    Comment by kocakahin — December 7, 2007 @ 1:01 am | Reply

  4. John, I remember that you said that during your presentation. You had 100% of my attention! :-)

    I just wanted to point it out again. Because Tonguç nodes also contain the “hard-coded” version, but which in my personal opinion isn’t the best version and shortest version to use.

    Patrick

    Comment by Patrick Wolf — December 9, 2007 @ 5:45 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: