Posts Categorized: Technical Blog
As a third person just asked me how to prepare for OCM exam in the last 2 days, I decided to make my answer publically available. I will leave you to discover the formal path yourself and give you a guideline in terms of how and how long to prepare to the exam.
This process can be used for most 11G upgrade projects. Very often a hardware got updated at the same time as a database version. In such case we migrate a database from an original location to a new server upgrading database version and sometimes changing operational system. If this is your scenario then you can use the upgrade process to minimize system’s downtime to 1 hour independently from size of the database you migrate.
This blog post is a short summary of one of our migration strategies used to migrate Oracle 10g databases to ODA balancing the requirements of minimal downtime and efforts/costs of the project.
Backup is one of the most important topics for any Oracle DBA. It is our primary responsibility to make sure that at any point in time we can recover database. Some time ago I created a survey,”Why do you use RMAN catalog DB for your Oracle DB backups?” In this blog post I am sharing the survey’s results.
SLOB on steroids v0.1 (you use it on your own risk). If you don’t know what is SLOB read here.
Interval partitioning – the ability to create partitions on the fly was introduced in 11g. When the feature came out, there were several nasty bugs. One such particular “limitation” has to do with parallel group by on the partition key. If you want to see just that part, skip towards the end, but I think reading the whole blog will offer some insights in how Oracle Parallel Query works.
First of all if you are using NFS to store Oracle database data files I strongly advice you to enable Oracle Direct NFS (DNFS) to access those files, the main reason is performance. DNFS removes a serialization point over the traditional “kernelized” NFS. However if you are not using NFS then most probably DNFS is out of interest for you and you should stop reading, but if you want to set it up lets go.
A while ago I was paged from a client having backup job failure. Doing my routine as usual I started the investigation by looking at the job execution log. Connected to the box and found a little bit strange output, here it is.
The most recent action I’ve done was upgrading database from 184.108.40.206 to the currently latest 220.127.116.11 version. The database is using ASM but I should notice at the beginning that the configuration is for Stand-Alone Server and not RAC. Basically when doing such action the first things that need to be done are part of the following checklist….
The traditional NoCOUG SQL challenge has been launched this year with a twist: in the wake of the “BigData” trend/buzz, it’s now been upgraded to a “SQL and/vs. NoSQL” challenge. I took on the challenge, treading through my SQL comfort zone, thinking of ways I could bend relational algebra to solve the wicked puzzle suggested this year.