How To Setup Externally Authenticated Users in A Multitenant Database
January 9, 2019It is not very often that a DBA creates externally authenticated users. Creating such users in a multitenant database, needs… Continue Reading
Category: Oracle
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
How To Display Dates Relative To Current Day
November 7, 2018It doesn’t happen very often that DBAs need to write reports based on dates, but when they do, they might… Continue Reading
5 Things To Know About Chained And Migrated Rows
October 25, 2018We hear it all the time that chained or migrated rows are not good. But if someone would challenge you… Continue Reading
Who Is Holding The Lock On The Table?
October 10, 2018Did you ever get an email or a phone call from a developer telling you they are getting an error… Continue Reading
What Can You Use DBMS_UTILITY.EXPAND_SQL_TEXT For?
October 3, 2018Have you ever worked through a tuning exercise (I’d like to call them exercises instead of problems), where the SQL… Continue Reading
How To Export The AWR Repository
September 26, 2018Last week I asked the question: “What do you do with the AWR data?” Here are some of the responses… Continue Reading
What Do You Do With The AWR Data?
September 19, 2018How do you use your AWR data or Statspack data? Do you retain it longer than the default retention? Do… Continue Reading
Why The Child Cursor Is Not Reused: ROLL_INVALID_MISMATCH
September 5, 2018While investigating a performance problem, have you ever wondered why a parent cursor has many child cursors associated with it?… Continue Reading