How To Quickly Terminate A Session Or Cancel A SQL Statement
March 5, 2020Terminating sessions is something that DBAs are asked to do pretty often.Usually the request comes in the form of an… Continue Reading
Tag: Oracle
Four Ways to Startup or Shutdown Your 19c Database
February 20, 2020Can you use Oracle Enterprise Manager Database Express, or Oracle Cloud Database Express to startup or shutdown your database? Think… Continue Reading
SQL Quarantine In Action On Your Laptop
February 14, 2020Last week I gave you a taste for SQL Quarantine. Some of you asked me if I know when this… Continue Reading
Intro To SQL Quarantine
February 6, 2020In the last blog post we talked about Quarantined Objects, which have no relationship whatsoever with today’s topic. I just… Continue Reading
OGB Appreciation Day: Next 3 Things On My List To Learn
October 9, 2019Oct 10th 2019, is Oracle Groundbreakers Appreciation Day, also known as OGB! This is the day to show our appreciation… Continue Reading
How Can DBMS_XPLAN.FORMAT_SIZE Be Useful For You?
October 6, 2019At one of the presentations I attended this year at Oracle Open World, the speaker Franck Pachot, had an interesting… Continue Reading
Fix ORA-04095: Trigger Already Exists On Another Table
September 10, 2019One of my readers asked me what is the cause of the following error, and what is the work around… Continue Reading
What To Do When The Export Fails With ORA-01466?
August 7, 2019The nightly backup job you have scheduled for your database, the datapump export job, starts failing with the following error:… Continue Reading
What Backup Jobs Are Currently Running
July 24, 2019You’ve planned to do some maintenance for the RMAN catalog, which would result in an outage to the RMAN catalog.… Continue Reading
Oracle’s Recycle Bin: Security Considerations
July 10, 2019I planned last week’s post to be the last one on the recycle bin. And then I got a nice… Continue Reading