Webinar Followup (Nov. 12) – In Search of Plan Stability – Part 2

Sorry for the delay in getting this posted, but thanks to everyone who attended my November 12th webinar entitled In Search of Plan Stability - Part 2. You can download the presentation materials from these links:

Presentation PDF
Recording







Thanks!

Blog articles at Toad World


I just wanted to point you to the blog articles I've been posting over at Toad World in case you're wondering why there aren't many articles showing up here.

So, go take a look!

Karen's Toad World Blog

Webinar Followup (Aug. 27): In Search of Plan Stability – Part 1

Thanks to everyone who attended my August 27th webinar entitled In Search of Plan Stability - Part 1. You can download the presentation materials from these links:

Presentation PDF
Scripts
Q&A

I'll update this post to provide a link to the recording shortly.

Come back in November for Part 2. Hope to see you then!

Thanks!

In Search of Plan Stability (Part 1) – August 27 webinar



Register by clicking here.

Hope you'll join me!

New Oracle Bug alert (Bug 19384287)

Heads up to all the folks running 11.2.0.4 and above if you're using function-based indexes! There's a new Oracle bug 19384287. I'll fill you in with a complete post over at Toad World.

Young Programmer’s Camp

I made a short post over at ToadWorld about bringing my nephew to my office in Dallas this week for a Young Programmer's camp. He had a great time as far as I could gauge the excitement of a 16 year old boy (errrrrr....young man)! He rocked it out creating several different game knock-offs and got a feel for what it would be like to be a software developer. Fun stuff!


Tracing Code with DBMS_MONITOR

Take a look at the follow-up to my DBMS_APPLICATION_INFO post over at ToadWorld. I discuss how to use DBMS_MONITOR to trace the specific sections of code you registered with DBMS_APPLICATION_INFO.  

Instrumenting Your Code using DBMS_APPLICATION_INFO

Head on over to my post at Toad World to read all the details about instrumenting your code with DBMS_APPLICATION_INFO.


Blogging at Toad World

In order to help me stick to my commitment to blog more regularly, I've joined the blogging community at Toad World. I'll link to most posts from there as I make them (I love knocking down two targets with one arrow) and keep on track for at least one post a week moving forward. Yea!

You can read my brief hello over at Toad World here. Stay tuned in the weeks ahead for a series (more...)

Weekly posts – Anyone got any ideas?

I've decided to get back in the groove of making more regular blog posts and have an intention to blog at least once a week in the coming months to get myself back in the habit. While I always seem to have a head full of stuff that never makes it to the blog, I thought I'd ask you all if you have any topic suggestions?

At this point in time, I'm not sure anyone (more...)

Writing SQL Right – May 20 webinar wrap-up

Thanks to everyone for attending today's Writing SQL Right webinar sponsored by Embarcadero. For attendees, Embarcadero will send out a link via email to the recording and PDF of the presentation, but I also wanted to post it here.

Presentation PDF
Webinar recording (posted soon)

Thanks again and stay tuned for additional webinars coming soon!

Upcoming Webinar: Writing SQL Right on May 20

Coming up on May 20, I'll be delivering a webinar entitled Oracle SQL Performance: Writing SQL Right. Registration is now open. Once again the webinar will be hosted by Embarcadero and there will be two sessions - one at 10am ET and one at 2pm ET.


Abstract:
There are many ways to write a SQL statement that may lead to the functionally correct answer. However, we often get stuck in a rut using the same (more...)

Effective Indexing Webinar

Thanks to everyone for attending today's Effective Indexing webinar sponsored by IOUG with Embarcadero. For attendees, IOUG will likely send out a link to the recording and PDF of the presentation, but I also wanted to post it here.

Presentation PDF

Thanks again and stay tuned for my next webinar coming up in another month or so!

Webinar Follow-up: Everyday Oracle Pro

Thanks to everyone who attended the November 12 webinar!

Presentation PDF
Webinar recording (coming soon)


Becoming an Everyday Oracle Pro – November 12 Webinar

Register for my next webinar on November 12 entitled "Becoming an Everyday Oracle Pro".

About the webinar
Whether you are new to Oracle or a seasoned veteran, you want to do your job to the best of your ability. Each one of us can become an everyday Oracle pro if (more...)

Webinar Follow-up: Execution Plans – Learn by Example

Thanks to everyone who attended the September 17 webinar! The answer to the questions asked via Chat will be posted shortly.

Presentation PDF
Webinar recording (available soon)

Stay tuned for details of my November webinar coming soon! 

SQL Tuning Fundamentals: Execution Plans – September 17 Webinar


Register now and join me for my next webinar entitled "SQL Tuning Fundamentals: Execution Plans".

Few tools are as critical to SQL optimization as the execution plan. The ability to read and understand an execution plan allows us to evaluate and optimize SQL performance. Unfortunately, complex plans often seem daunting (more...)

My day with the Ohio Oracle Users Group


Thanks so much to everyone who attended the Ohio Oracle User's Group event with me on July 18. I really enjoyed the opportunity to be there. The group appears to be vibrant and growing and everyone involved made it a top-notch experience (for me at least!).

My topic for (more...)

Follow-up: Visual SQL Tuning Webinar

Thanks to everyone who attended my Visual SQL Tuning webinar. My goal was to keep it simple and show the value of using VST to help you know what execution plans "should" do.

Presentation PDF
Webinar recording (posted soon)

I want to thank:
Kyle Hailey for his extensive work on (more...)

Visual SQL Tuning – July 23 Webinar


Register now and join me on July 23 to discover how Visual SQL Tuning can help you understand execution plans and diagnose performance problems. During the webinar I'll cover:
  • Visual SQL Tuning basics and how to create a VST diagram
  • How to evaluate execution plan effectiveness with Visual SQL Tuning (more...)