5 Reasons You Will Love SQLcl And Start Using It
August 17, 2016As a DBA you probably use SQL*plus everyday. Because SQL*plus is available on any database server, you use it for… Continue Reading
Category: Oracle
A Good DBA Automates (Almost Everything)
August 10, 2016Do you want to get more done in a day, at work? Automate. Do you want to free up some… Continue Reading
When, Why And How To Use DBMS_METADATA Oracle Package
July 27, 2016Never in DBA history has there been a better time than now. There are so many GUI tools available for… Continue Reading
3 Challenges DBAs Are Facing Today. What Are Yours?
July 20, 2016Would you like to work in a place where everything was working perfectly? No issues with the upgrade? No performance… Continue Reading
5 Things That Awesome DBAs Do, And You Can Too
July 13, 2016Did you ever wanted to be THE DBA in your team? You know who I am talking about…The one that… Continue Reading
Limitations Of The IN Clause In Oracle – ORA-01795
July 6, 2016Did you ever get the error “ORA-01795 maximum number of expressions in a list is 1000“? I didn’t. Truth be… Continue Reading
Step By Step Blueprint For Oracle Table Reorg – Index Rebuild
June 29, 2016I am so excited to share with you the blueprint, or the plan that you can use to implement the… Continue Reading
7 Things To Consider When Reorganizing Tables And Rebuilding Indexes
June 22, 2016It would be so easy to do the maintenance on a database if you only deal with regular tables, with… Continue Reading
Reorganize Tables And Rebuild Indexes, The Oil Change For Your Database
June 15, 2016Imagine what would happen to your car, if you never changed the oil. At the beginning your car would work… Continue Reading
What Permissions Do I Need To Compile Invalid Objects In Another Schema?
June 8, 2016Did you know that Compile Any Object permission doesn’t exist? I looked for it, and couldn’t find it. As a… Continue Reading