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 …
Category: Databases
Jul 27
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 …
Jan 23
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, …
Jan 22
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 …
Dec 29
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, …
Aug 04
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 …
Jul 15
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 …
Aug 14
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 …
Dec 13
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 …
Dec 12
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 …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
