Oracle User CheatSheet – Look Like An Expert, Even If You Are A Junior DBA
May 18, 2016Have you ever found yourself in a situation where you quickly had to figure out specific information about an Oracle… Continue Reading
Category: Oracle
3 Strategies For Dropping Database User Accounts
May 11, 2016Last week I covered the 5 Things To Consider When Dropping Database User Accounts. If you didn’t get a chance… Continue Reading
5 Things To Consider When Dropping Database User Accounts
May 4, 2016Dropping users in the database is a common task in the life of a DBA. Before jumping into executing the… Continue Reading
How To Conquer The 3 Roadblocks To Getting Certified
April 27, 2016I am a fan of database certifications, and people who know me, know that. I do feel it is important… Continue Reading
How Good Is Your Rollback Strategy? – 5 Ingredients For A Successful Rollback
April 19, 2016Have you ever found yourself in the middle of a change and all of a sudden the decision to rollback… Continue Reading
Dangers of Password Change – Wait Event: library cache lock
April 14, 2016Database user password change is a pretty common task, right? In 99% of the time I’d say it’s even boring… Continue Reading
DBMS_SCHEDULER – Did the time change mess with your database jobs?
November 5, 2014It is that time of year again, when the time changes, and you end up having an extra hour for… Continue Reading
Gather Stats: The Script That Keeps Your Users Happy
October 30, 2014How can a script keep the users of the database happy? Well, up-to-date stats on the database=good performance, and the reverse… Continue Reading
Gather Stats – All The Information You Need To Know At First
October 22, 2014What information related to statistics do you need to know when you look at the database. Below are the questions… Continue Reading
Gather Stats – The Job That Keeps Stats Up-To-Date
October 16, 2014What are optimizer statistics, which one is the default statistics collection job, how do I disable it and why would… Continue Reading