All You Really Need To Know About Constraints
Published: Thu, 05/11/17
Not long ago I had a conversation with another team member (non-DBA), and had to e plain in easy to understand terms some information about…
Diana Robete
database advise, step by step guides, how to emails
SQL Profiles – The Secret That Only Few DBAs Are Aware Of – Part 3
Published: Thu, 04/20/17
What if I told you there is a way to move SQL Profiles between databases zooming fast, without using the e port/import method, would you believe…
4 Steps To Move SQL Profiles Between Databases – Part 2
Published: Thu, 04/06/17
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…
3 Basic Things DBAs Need To Know About SQL Profiles – Part 1
Published: Thu, 03/30/17
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…
How To Pass Init.ora Parameters Through Oracle HINTS
Published: Thu, 03/23/17
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…
Unhiding The Oracle Hidden Parameters
Published: Thu, 03/16/17
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…
6 Oracle Background Processes Every Good DBA Needs To Know
Published: Thu, 03/09/17
Sometimes I get these crazy ideas about interview questions. Ask a Senior DBA the following question, sit back and watch their reaction:“What does…
DBMS_LOB For DBAs – Conquer Your Fear Of LOBS
Published: Thu, 03/02/17
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…
7 Things DBAs Must Know About The Recycle Bin
Published: Thu, 02/16/17
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…
Writing Skills For DBAs: How To Write Emails That Get Read And Answered
Published: Thu, 02/09/17
Everyone thinks their emails are great…until they realize the opposite.Our jobs, as DBAs, require good writing skills, which implies the ability to…