11Apr/18

Display Any Execution Plan With Ease

April 11, 2018Database, Oracle, OracleDBA, dbms_xplan, execution plan, Oracledianarobete

Ever wondered how to display the execution plan of a SQL Statement quickly? Are you dreading the question “What is the execution plan of this SQL?”? Are you struggling to figure outRead More…

04Apr/18

Intro To Execution Plans

April 4, 2018Database, Oracle, Oracleexecution plan, Oracle, plan hash valuedianarobete

When there is a performance problem in the database, what is the most important thing that you need to know? The execution plan of the SQL Statement that is causing the problem.Read More…

28Mar/18

Is The Latest Bundle Patch for 12.1.0.2 Fixing SQL Plan Directive’s Behavior?

March 28, 2018Uncategorizeddianarobete

Take a guess, you have 50% chances of being right! I was very excited last week, as I got to finally deploy the January 2018 Bundle Patch to the test environment ofRead More…

14Mar/18

What Should You Do With SQL Plan Directive Changes in 12.1?

March 14, 2018Database, OracleAdaptive Features, DBA, Oracle, SQL Plan Directivedianarobete

Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used and maintained. Need an intro to SQL Plan Directives? Check out lastRead More…

07Mar/18

What Are SQL Plan Directives?

March 7, 2018Database, Oracle, OracleDBA, DBMS_SPD, Oracle, SQL Plan Directivedianarobete

If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the bottom of the execution plan: … Note —– – dynamic statistics used:Read More…

21Feb/18

How To Find The SQL ID Of The Statement You Just Ran?

February 21, 2018Database, Oracle, Oracleprev_sql_id, set serveroutput off, sql_id, v$sessiondianarobete

Have you ever had to determine the SQL ID of the query you just ran? I am not talking about finding the SQL ID of a query run in another session, orRead More…

07Feb/18

Declutter Your Database The Right Way

February 7, 2018Database, Oracle, Oracledatabase, declutter, Oracledianarobete

I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to me and said, we have a project to cleanup some databases ofRead More…

24Jan/18

What Is The Relationship Between SCNs and DB Links?

January 24, 2018Database, Oracle, Oracledatabase link, DBA, Oracle, SCNdianarobete

Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised to find out that some databases had very close SCN numbers? TheRead More…

17Jan/18

3 Things You Wish You’ve Learned In School About Oracle’s SCN

January 17, 2018Database, Oracle, OracleOracle, SCNdianarobete

There are things you don’t learn in school. There are things you hear about in school, that are not explored in-depth. There are things you learn in school and then you forgetRead More…

10Jan/18

What Skills Are You Going To Master in 2018?

January 10, 2018Oracle, Personal Growth2018, awesome year, goals, questions, skills to masterdianarobete

We are two weeks into 2018. Most likely you are back to work, in full force, ready to fight the new fires! Are you ready for an AWESOME year, full of challenges,Read More…