09Aug/17

5 Things To Better Understand Selectivity And Cardinality

August 9, 2017Database, Oracle, Oraclecardinality, Oracle DBA, selectivitydianarobete

If you really want to confuse a candidate for a DBA job interview, just ask the question: “Can you explain to me the difference between selectivity and cardinality?” and look for theirRead More…

03Aug/17

OUI and OPatch What Are They Used For?

August 3, 2017Database, OracleOpatch, Oracle, oracleDBA, OUIdianarobete

The last two weeks I’ve been talking about the Central Oracle Inventory and the Local Oracle Inventory. I have mentioned two Oracle tools that are reading/updating some files within these inventories: OracleRead More…

26Jul/17

All You Need To Know About The Local Oracle Inventory

July 26, 2017Database, Oracle, OracleDBA, Local Oracle Inventory, Oracledianarobete

Most DBAs have heard of the Central Oracle Inventory, even if they don’t know details about it. But, have you heard of the Local Oracle Inventory? If not, you are not theRead More…

20Jul/17

All You Need To Know About The Central Oracle Inventory

July 20, 2017Database, Oracle, OracleCentral Oracle Inventory, inventory.xml, oraInst.loc, OUIdianarobete

Where do you look when you don’t know what Oracle software is installed on the server? Have you been put on the spot and caught off guard by not being able toRead More…

12Jul/17

How To Maintain The Fast Recovery Area

July 12, 2017UncategorizedDBA, Fast Recovery Area, FRA in action, Oracledianarobete

You understand what the Fast Recovery Area aka FRA is, what files are stored there and how to enable it. If you need a refresher, check out last week’s post here: 3Read More…

28Jun/17

3 Questions Answered About FRA – What, Who, How?

June 28, 2017UncategorizedDBA, Fast Recovery Area, Flash Recovery Area, FRA, Oracledianarobete

Is it Flash Recovery Area or Fast Recovery Area? Well, you are not wrong calling it either or, but better call it FRA (then everyone knows what you are talking about). BackRead More…

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…