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…

25Jan/17

What Happens To Undo Tablespace During DataPump Import And How To Fix It

January 25, 2017Database, Oracle, Oracledisable, enable, impdp, primary key constraints, undo tablespacedianarobete

A request to refresh a specific schema in the test environment came in. This is going to be a breeze, you think. You prepare the scripts and the environment. The datapump exportRead More…

18Jan/17

Three DBA Scripts For Instant Answers: Who, What, How

January 18, 2017Database, Oracle, Oraclekill session, sessions, sql text, sql_iddianarobete

Today’s post was written based on your emails, comments and feedback for last week’s post Mistakes Happen – How To Cancel Alter Database Datafile Resize Command. I have received a tremendous amountRead More…

11Jan/17

Mistakes Happen – How To Cancel Alter Database Datafile Resize Command

January 11, 2017Database, Oracle, Oraclealter database datafile resize, Oracledianarobete

You are running a datapump import into a database, and the UNDO tablespace running out of free space (more on that, in another post). As you notice the space being chewed upRead More…