SQL Tuning – Intro

I have recently been doing presentations about SQL tuning, but haven’t really written anything on the topic here. Therefore, I have decided to put together a series of posts over the next few weeks on the process I use for tuning SQL. I plan to cover: – Viewing and interpreting the current execution plan for… Read More »

GLOC – Pictures

I finally got around to getting a few pictures I took during my time at GLOC uploaded so I thought I would share. First, the hotel that the conference had a discount for was the Hyatt Regency Cleveland at The Arcade. Now, typically I don’t care much about what hotel I stay in, but this… Read More »

GLOC – Days 1 and 2

The conference was a great event. I learned about several new things, and now I have some homework to do to get further into the details. My favorite sessions were the 2 from Carlos Sierra on SQLT and Adaptive Cursor Sharing as well as Craig Shallahamer’s session on Child Cursors. It was great to hear… Read More »

GLOC – Day 0

Arrived in Cleveland today for the Great Lakes Oracle Conference pre-conference workshops. I attended Craig Shallahamer‘s presentation on Oracle Performance. A lot of great information packed into 2 hours. More than anything, I like that from this quick presentation I was able to get a sense of how Craig does his performance troubleshooting. He clearly… Read More »

SQL Patching

I have finally caught up on my backlog of blog posts I have been meaning to read, and am quite glad I did. One of the posts I ran across was by the Oracle Optimizer team about SQL Patching. This allows you to have Oracle apply a hint to a query without having to modify… Read More »

DAY-O Presentations

I have finished my presentations at DAY-O and think they went fairly well. I got a good amount of participation and even better questions. Their members do a good job talking with each other about new features or issues they are having, which is really what Users Groups should be about. I look forward to… Read More »

Upcoming Presentations

I will be presenting twice at the Dayton Oracle Users Group on Thursday, April 25. My presentations will be on reading execution plans and SQL Tuning. I have never presented at Dayton before, so I look forward to meeting the people there and seeing what kind of group they have going. Check out the full… Read More »

Using roles to prevent disaster

I was reading Rene Antunez’s post about some things you can do with tools you use to help make you aware when you are in Production. The idea is that you want to do everything you can to prevent yourself from getting confused when you are working with several different windows open at the same… Read More »

Looking Forward – Goals for 2013

I didn’t do very well on my goals for 2012. I didn’t read the books or get my certification. However, I did do the 2 users group presentations as well as my first conference presentation, all which was very enjoyable. I also got a new job as an Applications DBA, which I am quite enjoying.… Read More »

Resetting passwords on 11g to existing pw

I ran across this post today with good information about some differences in how to reset a password in 11g using the hash values, and didn’t want to lose it: http://blog.flimatech.com/2011/07/17/changing-oracle-password-in-11g-using-alter-user-identified-by-values/ Short and to the point 🙂