Oracle

Opening the Door Without the Keys

This week, my DBA team fulfilled a request to restore 1 month old lost data.  A review of the RMAN backups showed that we indeed had a valid level 0 from the requested day, which was 33 days ago.  However, upon recovery, the necessary archive logs to bring the database to a consistent point were…

IOUG Collaborate 2013 Wrap-Up

Personal highlights from Collaborate 2013 in Denver. Discussion of networking with old and new friends, technical sessions (performance forecasting and multi-block read internals) and the Pythian RAC Attack class.

A Look at SQL Plan Management

The goal of SQL Plan Management is to provide a consistent execution plan regardless of changes made to the database environment. While consistency is great in the face of changes to an environment, it is important not to miss out when changes would improve the runtime execution. SQL Plan Management has three components that meet this goal.

Log Buffer #314, A Carnival of the Vanities for DBAs

It is an industry norm, supported by analyst researches, that blogs are the best informal medium to share the information.  This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.

Page 17 of 140« First Page...10...1516171819...30...Last Page »