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…
database advise, step by step guides, how to emails
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…