Category Archives: Uncategorized
Unified Audit and Virtual Private Database
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
Do you want to know where I’ll be speaking this fall?
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
Life of an Oracle DBA – Test environment.
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
Life of an Oracle DBA – The Basics Access Paths: Index Skip Scan
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
Fix the standby database.
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