22Jun/17

To Drop Or Not To Drop A Column – Find Out The Answer

June 22, 2017Uncategorizeddrop column, unused columndianarobete

Don’t you love it when people come to you for advice? I sure do! I got a call the other day from a developer. He didn’t understand why adding a column isRead More…

14Jun/17

What Do You Do When You Get Asked Questions You Don’t Know The Answer?

June 14, 2017Personal GrowthDBA, questionsdianarobete

Do you look forward for other teams to come to you and ask technical questions? Or Do you panic, and secretly wish you could hide in the corner, so nobody would evenRead More…

13Jun/17

What Would YOU Like To Know About Oracle Performance Tuning?

June 13, 2017Database, Oracle, OracleSurvey, your questionsdianarobete

I get emails, questions and requests every week about different topics related to Oracle. How do I a find out the query a user is running? How do I interpret execution plans?Read More…

07Jun/17

DBA Documentation-3 Most Common Questions Answered: Why,Where,What

June 7, 2017UncategorizedDBA documentationdianarobete

Last week’s post got tremendous response! If you missed it, you can check it out here! Thank you to all of you who commented or responded, your feedback is valuable! I learnedRead More…

31May/17

There Are 2 Types Of DBAs, Which Type Do You Belong To?

May 31, 2017Database, Personal GrowthDBA that documents, documentationdianarobete

You feel excited as you start your new job today! You are ready to roll! This is your dream DBA position! You go to the office, you start getting initiated on theRead More…

24May/17

The Ultimate Guide For DBAs To adrci Tool

May 24, 2017Database, Oracle, OracleADR, adrci, Automatic Diagnostic Repository, DBA, Oracledianarobete

What? Another tool? Yes! And this one is your friend! Do you know why? Because it makes your job easier! How? That is what you’ll find out today! Last week, I wroteRead More…

17May/17

5 Things That Every Good DBA Needs To Know About The ADR

May 17, 2017Database, Oracle, OracleADR, ADR_BASE, ADR_HOME, Automatic Diagnostic Repository, DBA, Oracledianarobete

If you are an Oracle DBA, most likely you know what Automatic Diagnostic Repository aka ADR is, or at least you heard of it. If you are OCP certified, then you mustRead More…

10May/17

All You Really Need To Know About Constraints

May 10, 2017Database, Oracleconstraintsdianarobete

Not long ago I had a conversation with another team member (non-DBA), and had to explain in easy to understand terms some information about constraints. In order to provide accurate information, IRead More…

19Apr/17

SQL Profiles – The Secret That Only Few DBAs Are Aware Of – Part 3

April 19, 2017Database, Oracle, Oraclecoe_xfr_sql_profile.sql, Oracle, SQL Profilesdianarobete

What if I told you there is a way to move SQL Profiles between databases zooming fast, without using the export/import method, would you believe me? Not many DBAs are aware ofRead More…

05Apr/17

4 Steps To Move SQL Profiles Between Databases – Part 2

April 5, 2017Database, Oracle, OracleDBA, move profiles, Oracle, SQL Profilesdianarobete

Welcome back for another week on SQL Profiles. If you don’t feel comfortable around SQL Profiles, or you just need a refresher on SQL Profiles, check out last week’s post 3 BasicRead More…