Author: Yury Velikanov

Are There Performance Penalties Running Oracle ASM on NFS?

In this blog post I am publishing my SLOB tests results and conclusions testing Oracle database IO performance placing data files on NFS directly and on ASM disk group located on NFS.

Read More >

Reasons to Use ASM on NFS

My tweet few days ago – “Personally I don’t see the point building ASM on (d)NFS. ASM suppose to exclude unnecessary layers. In NAS case it adds an additional layer.” Since then Oracle people in my Social Media environment helped me to find several legitimate reasons to run ASM on NAS. Thank you folks very much. Now I am sharing our common thoughts with the rest of the community.

Read More >

My Agenda for AUSOUG Conference in Perth

There is a very strong Oracle Community in Perth, Australia. I admire many Perth based Oracle User Group volunteers who year from your organizing a great Oracle event. This year it isn’t an exception. I just spent 30 minutes going through the program and I should say the lineup of speakers is very impressive. Here’s the schedule.

Read More >

Oracle Direct NFS Configuration File Explained

While Oracle tech folks doing their best to explain meaning of not so many DNFS configuration file (oranfstab) parameters I still find an official description a bit confusing. Therefore I decided to share my understanding of the DNFS configuration parameters in hope that it will help someone or if my understanding is wrong someone corrects me :) So, if I am wrong please please please feel free to leave comments.

Read More >

DNFS: wtmax = /proc/fs/nfsd/max_block_size

This is one of those posts that you find via google using an error message for direct hit search. If you didn’t reach this post that way I would advise you to stop reading here. If you are still reading then you (as I did) faced error messages below and got frustrated as it isn’t obvious what exactly Oracle means by wtmax/fsinfo/rt/rtp/wt/wtp etc. It all has been very confusing to me as I am Oracle DBA and still need to learn a lot on system administration level side of things.

Read More >

SNAPSHOT CONTROLFILE Isn’t Just a Backup Copy of a Control File Anymore

Recently I have troubleshooted failing RMAN backups in a 11.2.0.2 RAC environment. The backups failed with the error message “ORA-00245: control file backup operation failed”. The solution for the issue is simple. Here it is!

Read More >

Case Study: DBA Under Pressure for Performance Troubleshooting on Friday 13

On Friday 13 of June 2012, I was an on-call Oracle DBA. I got to work on a high priority client’s request. One of our client’s financial team was executing final steps of a year closing process in their ERP production environment and had a problem. The step that I received a complain about took 2 hours and still didn’t complete.

Read More >

How to Prepare for Oracle Database 11g Certified Master Exam

Since a third person just asked me how to prepare for OCM exam in last 2 days, I decided to make my answer publicly available. I will leave you to discover the formal path yourself and give you a guideline in terms of the how-to and length of the preparation.

Read More >

Minimal Downtime Option for Upgrading Oracle 9i/10G Databases to 11G

Often, a hardware is updated at the same time as a database version. In such cases, we migrate a database from an original location to a new server upgrading the database version and sometimes changing operational system. If this is your situation, you can use the upgrade process to minimize the system’s downtime to 1 hour, independently from the size of the database you migrate.

Read More >

Migrating Your 10G Database to ODA with Minimal Downtime

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.

Read More >
Page 3 of 812345...Last Page »