What Happens To Undo Tablespace During DataPump Import And How To Fix
Published: Thu, 01/26/17
A request to refresh a specific schema in the test environment came in. This is going to be a breeze, you think.You prepare the scripts and the…
Diana Robete
database advise, step by step guides, how to emails
Three DBA Scripts For Instant Answers: Who, What, How
Published: Thu, 01/19/17
Today’s post was written based on your emails, comments and feedback for last week’s post Mistakes Happen – How To Cancel Alter Database Datafile…
Mistakes Happen – How To Cancel Alter Database Datafile Resize Command
Published: Thu, 01/12/17
You are running a datapump import into a database, and the UNDO tablespace running out of free space (more on that, in another post).As you notice the…
3 Things You Must Do In Any DBA Job Interview
Published: Thu, 01/05/17
Imagine going to a DBA job interview, making a good first impression, feeling confident about yourself, and getting the position.How does that feel?…
3 Things DBAs Can Do At Christmas Time, When Things Slow Down
Published: Thu, 12/22/16
I love the month of December, especially if it’s not -30C outside. This statement might seem unreal for people living in warmer climates, but those of…
Things You Didn’t Know About 12c init.ora Parameters!
Published: Thu, 12/15/16
Have you ever wondered why we, (DBAs) keep using the words “init.ora parameters”, when referring to instance parameter. When in fact, nobody is…
12c Multitenant Architecture Explained With Mind Maps
Published: Thu, 12/01/16
Oracle 12c is out for 3 years, as of this writing. Have you been upgrading your databases? If you haven’t, don’t sweat it, you are not the only one.
Statspack, For Solving Problems Like A PRO
Published: Thu, 11/24/16
A performance problem is reported to you, that occurred 2 days ago, at 5:00 pm, in the HR database. What do you do?If you have Diagnostic and Tuning…
5 Tips To Achieve More Balance In Your DBA Life
Published: Thu, 11/10/16
In a world where we believe we are required to be available 24/7, achieving work-life balance seems daunting. We feel the need to respond to emails…
Database Links – When And How To Recreate Them
Published: Thu, 11/03/16
A security audit has identified the password for schema APP_USER, in HRPRD database has not been changed in the past 2 years. In order to pass the…