Posts Categorized: Technical Blog
Recently we had a situation where in customer have asked us to move Master Database from Local Drive to SAN drive, I have outlined the steps for the task:
Oracle OpenWorld 2012 is just over a month away and yes we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of the OpenWorld.
MySQL management plugin for EM 12c has been long overdue. I’ve initially migrated the older plugin to EM 12c about 6 months ago and few dozen people received this as initial beta of the plugin. It worked OK but didn’t use any of the 12c new features and its home page was a bit of a mess in the EM 12c Cloud Control web interface.
We have several just two left brand new, unopened ODAs left in our inventory that we need to move. Half of them are gone to our customers but there are few still left
One of the readers of my previous post about Oracle’s Flashback Database, posted a comment noting that the Oracle documentation doesn’t make any reference to the ability of the FLASHBACK DATABASE command to roll the database forward. I knew from experience that the database can be rolled back and forth using the FLASHBACK DATABASE command and decided to have a closer look.
When a new cursor is given to Oracle to execute, it first needs to check if there is already such cursor in the Shared Pool, so we will not need to go to the expensive process of a hard parsing it again. To check this quickly, a hash value is generated from the text of the SQL .
This post is to discuss the Microsoft Planning and Assessment (MAP) toolkit, which is nice little tool with a few extremely useful features.
For the business world , a good RDMS is one that can provide high availability (HA) options with minimal downtime and cheapest licenses. Vendors, usually if not always, provide a set of HA features to satisfy different needs. Usually some of these features are reserved for higher-end editions: Enterprise, Datacenter, cluster or whatever named; of course, those editions are more expensive than their “inferior” counterparts. Most important factors on choosing an edition are:
This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religous fervor in the air, particularly from the point of view of someone more accustomed to Oracle conferences. The companies generating buzz were the small companies built around development of their own open source products. There are a surprising number of them out there, especially relating to multiple forks of a popular product like MySQL or Hadoop.
Recently I have troubleshooted a failing RMAN backups in 18.104.22.168 RAC environment. The backups failed with an error message “ORA-00245: control file backup operation failed”. The solution for the issue is simple. Here it is.