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…

26Oct/16

5 Things About Oracle Proxy User You Wish You Knew Before

October 26, 2016Oracle, Oracleaudit trail, connecting user, oracle proxy user, proxy userdianarobete

Are you a senior DBA that knows about proxy users, and never got a chance to implement them? Or maybe you are just starting out in the DBA world, and haven’t evenRead More…

12Oct/16

What Value Are You Bringing To The DBA Team And Company?

October 12, 2016Database, Oracle, Personal GrowthAdd value, create scripts, DBA, improve process, Oracle, overtimedianarobete

Years ago, I was sitting in the 9:00 am weekly DBA meeting, on a Wednesday. Each one of us got a turn to speak about tasks, projects, challenges we were facing thatRead More…

05Oct/16

All You Need To Know About Oracle Scheduled Jobs

October 5, 2016Database, Oracledba_scheduler_job_args, DBA_SCHEDULER_JOBS, dbms_scheduler, oracle scheduled jobsdianarobete

Do you get frustrated when dealing with dbms_scheduler jobs? Do you forget the data dictionary views that can be queried to find information about database jobs? Do you find yourself looking onRead More…

21Sep/16

The Illusion Of Multitasking For DBAs (and not only)

September 21, 2016Database, Personal GrowthDBA, multitasking, Oracledianarobete

I am sitting in a meeting with multiple teams, some people are on the conference call, others are in the room. Some of the people in the room have a reason toRead More…