Database Refresh Part 3 – RMAN
April 24, 2019This is the final part of the Database Refresh series, and you guessed it, it is about database refresh using… Continue Reading
Tag: Oracle
Database Refresh Part 2 – Datapump
April 18, 2019Last week’s post was about automating the database refresh process. I recommended you to document every detail you follow, when… Continue Reading
Database Refresh Part 1 – What Method To Use?
April 10, 2019Refreshing databases is part of the DBA’s job. Since this is a repetitive task (you execute it many times, again… Continue Reading
What Is Average Active Session aka AAS?
March 17, 2019Are you familiar with AAS aka Average Active Session Metric? If not, don’t worry you are not the only one.There… Continue Reading
7 Steps To Setup Privilege Analysis
February 26, 2019Last week I showed you how Privilege Analysis can help you sort out and standardize security in your database. Today,… Continue Reading
What Is Privilege Analysis?
February 13, 2019I like order, I like patterns, I like consistency in general, but especially in the databases I manage. Most of… Continue Reading
5 Steps To Automate Listen.log Mining
January 31, 2019If you read last week’s article, then you most likely understand the importance and the benefit of reviewing the listener.log… Continue Reading
5 Reasons You Should Review The listener.log File
January 22, 2019Many years ago, I found an article written by Arup Nanda, on mining the listener log file. If you have… Continue Reading
Cheat Sheet For Common And Local Users, Roles, Profiles
December 17, 2018When you transition from a single instance, non-CDB database to a multitenant database architecture, working with users, roles and profiles… Continue Reading
4 Things You Need To Know About Database Restricted Mode
November 15, 2018For certain database operations, you need to place your database in restricted mode.There are two ways to proceed to accomplish… Continue Reading