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 […]

Remote Database Administration On-Shore

Database administration is crucial for most businesses, and recently the trend has returned to keeping all aspects of DBA work on-shore, instead of outsourcing it to companies’ off-shore. There are definite benefits to keeping your rDBA in the same US time-zone as your business, as well as reasons outsourcing is no longer a viable solution. […]