Category Archives: Oracle

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 »

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: Short and to the point 🙂

SQL Plan Management – Adding a desired plan

I have just started looking into SQL Plan Management, so the next few posts will probably be focused around it. As a quick background, SQL Plan Management lets you “lock in” a plan for Oracle to use for a specific SQL statement. This way when stats change, or data is added, Oracle will continue to… Read More »

Third International NoCOUG SQL & NoSQL Challenge – Coming Soon

Iggy Fernandez just let me know that the Third International NoCOUG SQL & NoSQL Challenge will be starting on Monday. I really enjoy these challenges and seeing the creative answers people come up with. I am sure this year will be no different. —- The Third International NoCOUG SQL & NoSQL Challenge sponsored by Pythian—Love… Read More »

NEOOUG Oracle Training Seminar – Day 2

NEOOUG wrapped up yesterday, with 2 talks each by Cary Millsap and Rich Niemiec. I have seen Cary speak before, and never get tired of it. He is a natural teacher, making everything so simple to understand. Rich is a very entertaining speaker as well, and it was fun hearing about stories from Oracle’s early… Read More »

NEOOUG Oracle Training Seminar – Day 1

Day 1 is complete. The venue at Cleveland State is awesome, and the presentations were all high quality as well. My presentation went through decently, although I stumbled in a few spots. The questions I got were good, and makes me feel I need to add more to the presentation about how to use the… Read More »