Category Archives: Uncategorized

Unified Audit and Virtual Private Database

Posted on August 3, 2021 by rlockard

It seems not a day goes by where I’m not humbled in some way or another. Frequently this happens due to limits of my knowledge or something I’d forgotten. There is a wrinkle when you combine Unified Auditing and Virtual … Continue reading →

Posted in Uncategorized | Leave a comment

Do you want to know where I’ll be speaking this fall?

Posted on July 22, 2021 by rlockard

Where am I speaking this fall? Poland and Croatia conferences have been confirmed. Waiting for Spain, and ECOUG. Let’s get back to normal and be safe about it. Looks like I’ll be busy for the next several months. Life is … Continue reading →

Posted in Uncategorized | Leave a comment

Life of an Oracle DBA – Test environment.

Posted on October 26, 2012 by rlockard

It’s been a few weeks since I have posted. The short story is my work load has been keeping me from posting. Today I had an interesting conversation regarding a test environment that we are building in a technology refresh. … Continue reading →

Posted in Database Stuff, Uncategorized | Leave a comment

Life of an Oracle DBA – The Basics Access Paths: Index Skip Scan

Posted on September 22, 2012 by rlockard

Normally for Oracle to use an index, the leading column in the index must be in the predicate. There are conditions, where the leading edge of the index is not in the predicate but the remaining columns in the index … Continue reading →

Posted in Uncategorized | Leave a comment

Fix the standby database.

Posted on July 28, 2012 by rlockard

This has happened in the past. A data file get corrupted, or there is a gap in the archive logs. How do you fix it? In the past I would put the tablespace into backup mode, backup of the datafile, … Continue reading →

Posted in Uncategorized | Leave a comment