Managing Database Load

Introduction One of the most common issues with Oracle databases that result in major business issues happen when database resources are overwhelmed with work. When this happens, some or all of the following can happen: Response time can increase to the point where no SQL operations are completing from any connected sessions, The database and […]

Enhanced purging of the Oracle recyclebin

Introduction In the Oracle RDBMS v10, the ‘recyclebin’ for segments was introduced. If the recyelebin=on parameter is set, and a table is dropped, it is not actually dropped – it is renamed to a system-generated name. This can really help in situations where a table is accidentally dropped, as it can be easily recovered. However, […]

Leveraging Your Remote DBA as a Partner

In today’s business world, management not only has to work with their current employees but a plethora of vendors. Properly managing vendors has become a crucial task for upper management, and when it comes to managing your database, the CIO must effectively communicate with the DBA vendor. Having access to the right remote DBA vendor […]

Best Practices for Backing up Your Database

It’s almost the end of the workday and the employees are cranking out the last of the reports when every computer screen in the office goes dark. Some employees are checking the CPU connections while others are tapping on keyboards to see if something happens. When the database finally comes back online, there are large […]

Collaborate IOUG 2015 Session Material

I had the pleasure and the honor of presenting “DBA 3.0 or How to Become a Real-World Exadata DBA” at Collaborate 2015 – IOUG’s annual user conference – in Las Vegas. It was a fantastic experience for me, personally, and I thoroughly enjoyed answering questions and talking about all things Exadata with the audience both during and after my […]