25Jan/17

What Happens To Undo Tablespace During DataPump Import And How To Fix It

January 25, 2017Database, Oracle, Oracledisable, enable, impdp, primary key constraints, undo tablespacedianarobete

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 environment. The datapump exportRead More…

18Jan/17

Three DBA Scripts For Instant Answers: Who, What, How

January 18, 2017Database, Oracle, Oraclekill session, sessions, sql text, sql_iddianarobete

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 Resize Command. I have received a tremendous amountRead More…

11Jan/17

Mistakes Happen – How To Cancel Alter Database Datafile Resize Command

January 11, 2017Database, Oracle, Oraclealter database datafile resize, Oracledianarobete

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 space being chewed upRead More…

04Jan/17

3 Things You Must Do In Any DBA Job Interview

January 4, 2017Database, Personal GrowthDBA, Job interview, on time, Oracle, positive attitude, to the pointdianarobete

Imagine going to a DBA job interview, making a good first impression, feeling confident about yourself, and getting the position. How does that feel? It feels great, isn’t? But, what do youRead More…

21Dec/16

3 Things DBAs Can Do At Christmas Time, When Things Slow Down

December 21, 2016Database, OracleDBA, Merry Christmas, Oracle, time to plan, time to restdianarobete

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 you living in Canada, can relate.Read More…

14Dec/16

Things You Didn’t Know About 12c init.ora Parameters!

December 14, 2016Oracle, Oracle12c, init.ora, memory parameters, Oracle, spfiledianarobete

Have you ever wondered why we, (DBAs) keep using the words “init.ora parameters”, when referring to instance parameter. When in fact, nobody is actually using an init.ora file to startup an OracleRead More…

30Nov/16

12c Multitenant Architecture Explained With Mind Maps

November 30, 2016Database, Oracle, OracleCDB, multitenant architecture, oracle 12c, PDB, Seeddianarobete

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. There are lotsRead More…

23Nov/16

Statspack, For Solving Problems Like A PRO

November 23, 2016Database, Oracle, OracleDBA, Oracle, statspackdianarobete

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 Pack you knowRead More…

09Nov/16

5 Tips To Achieve More Balance In Your DBA Life

November 9, 2016Personal GrowthDBA, unplug from work, work-life balancedianarobete

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 after hours, we feel the needRead More…

02Nov/16

Database Links – When And How To Recreate Them

November 2, 2016Database, Oraclecreate database link, drop database link, Oracle database linkdianarobete

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 security audit, the password needsRead More…