Category: Databases

Fog Computing

Unless you’ve been living under a rock, you know that everything is about the Cloud now. At least that’s the hype vendors and the media want us to believe. Earlier this week, I was clued into a new term. Just as people are working towards Cloud Computing comes the newer Fog Computing. So what is …

Continue reading

The Data Guardian

This morning, I was reading this article about employees lack of understanding how critical it is to protect business data. The article got me to think about a few different points. As a DBA, I’ve always tried to be my company’s Data Guardian. To me, the data inside the databases I manage is a valuable …

Continue reading

SEC_CASE_SENSTIVE_LOGON in 12c

Oracle 12c deprecates the SEC_CASE_SENSITIVE_LOGON parameter. It is still there for backwards compatibility. But Oracle would like to see everyone use case sensitive logons in the future. The one thing that did surprise me was when I recently upgraded a test db from 11.2.0.4 to 12.1.0.1 using the DBUA. At the end of the DBUA, …

Continue reading

SQL Server Outage

Just like many Oracle DBA’s, I have to support other database platforms as well, which in my case does include SQL Server. My shop has regularly scheduled maintenance windows every Wednesday evening. Last night, our SysAdmins were replacing some disk in our production SQL Server box. The disk wasn’t one that SQL Server uses so …

Continue reading

What’s a Major Version Anyway?

We all know that Oracle 12c was released quite awhile ago. Oracle 12.1.0.1 was the next major version in the Oracle database life cycle. But what’s in a major version anyway?   It used to be that a major version was a big deal. ACME Corporation released their wonderful Widget 4.0 which did many things, …

Continue reading

DB Popularity

I ran across this web page that ranked databases by popularity: http://db-engines.com/en/ranking Some of them are absence of legitimate eating regimen, unfortunate living style, http://pamelaannschoolofdance.com/hilary-nelson/ cialis generika cigarette smoking, and propensity for having abundance liquor. Here, some of the major benefits of kamagra online Kamagra needs to be taken under medical instructions for better and …

Continue reading

Oracle Big Data SQL

Oracle announced a new product called Big Data SQL that will be available in the Fall. I think this product will be interesting. The one downside I see is that it appears to only run on an Oracle appliance which means you are forced to use their hardware as well. For more information, see the …

Continue reading

Reconstruct Standby DB

After a recent power outage at our DR site, I discovered that a standby there had stopped applying logs. Apparently in the archived redo logs was a transaction which grew a datafile but the disk at the standby site did not have enough disk space to allow that transaction to complete. So the standby terminated …

Continue reading

Brand New Production Database

Every once in a while, no matter which company I work for, I am asked to set up a new production database. I was working on this very task today when I started thinking about how much work it was to create a brand new database in that past, how much the DBCA handles for …

Continue reading

Wait Event: asynch descriptor resize

In my recently upgraded production database, I am seeing a number of SQL statements that are now experiencing high waits on the “asynch descriptor resize” event. I recently upgraded from 11.1.0.7 to 11.2.0.2 and SQL statements that never waited on this event are now getting caught. Oracle 11.2 slightly changed the way the database and …

Continue reading