Posts by Yury Velikanov

Case Study: DBA under pressure or performance troubleshooting on Friday 13

Friday 13 of June 2012 I was oncall Oracle DBA. I got to work on a high priority client’s request. A financial team of one of my team’s clients 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. I was told that last year the same step completed in 20 minutes. Looking back I think it may be beneficial for someone of you to read how the issue has been troubleshooted and resolved. It may give you a chance to learn something or share some better diagnosing techniques with me and others. Please do not hesitate to use comments section of this blog post.

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

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.

Oracle Direct NFS: How to start

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.

Page 3 of 812345...Last »