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…

29Mar/17

3 Basic Things DBAs Need To Know About SQL Profiles – Part 1

March 29, 2017Database, Oracle, Oraclebetter execution plan, DBA_SQL_PROFILES, hints, Oracle, SQL Profilesdianarobete

When it comes to SQL Profiles are you afraid to deal with them? Do you secretly wish you never heard of them, and that you will never ever need to touch them?Read More…

22Mar/17

How To Pass Init.ora Parameters Through Oracle HINTS

March 22, 2017Database, Oracle, Oracle_push_join_predicate, /*+ OPT_PARAM('_push_join_predicate' 'FALSE') */, ORA-00600, Oracle Hintsdianarobete

Few days after patching and Oracle database to 11.2.0.4, I get an email from a user reporting ORA-00600 errors when selecting from a few views. I can reproduce the error, which looksRead More…

16Mar/17

Unhiding The Oracle Hidden Parameters

March 16, 2017Database, Oracle, OracleOracle hidden parameter, underscore parameter, undocumented parameter, v$parameter, x$ksppcv, x$ksppidianarobete

At one point in your DBA journey, you will come across Oracle hidden parameters, whether you want it or not. An upgrade will happen, and all of a sudden query performance goesRead More…

08Mar/17

6 Oracle Background Processes Every Good DBA Needs To Know.

March 8, 2017Database, Oracle, OracleDBW, LGWR, Oracle background processes, PMON, SMONdianarobete

Sometimes I get these crazy ideas about interview questions. Ask a Senior DBA the following question, sit back and watch their reaction: “What does SMCO stand for and what is its purpose?”Read More…

01Mar/17

DBMS_LOB For DBAs – Conquer Your Fear Of LOBS

March 1, 2017Database, OracleBLOB, CLOB, dbms_lob, dbms_lob.compare, LOBSdianarobete

Are LOBS your favorite data type? Not for me. And I strongly believe not for you either. Why is that? First of all, we don’t work with LOBS on a daily basis,Read More…

15Feb/17

7 Things DBAs Must Know About The Recycle Bin

February 15, 2017Database, Oracle, OracleDBA, DBA_RECYCLEBIN, FLASHBACK TABLE, oracle recycle bin, PURGEdianarobete

If you are an Oracle DBA, you are familiar with the concept of the recycle bin. You familiarized yourself with these concepts before, since it’s available starting with version 10g. What youRead More…

08Feb/17

Writing Skills For DBAs: How To Write Emails That Get Read And Answered

February 8, 2017Oracle, Personal Growthbetter email, DBA, writing skillsdianarobete

Everyone thinks their emails are great…until they realize the opposite. Our jobs, as DBAs, require good writing skills, which implies the ability to write good emails. Are we all good at writingRead More…