My experience, findings and thoughts in my daily work with Oracle products

« Home

Previous Post »Previous Post »Previous Post »Previous Post »Previous Post »Previous Post »Previous Post »Previous Post »Previous Post »Previous Post » 

Luca Canali and ASM Metadata Internals

Published Wednesday, June 14, 2006 by Radoslav Rusinov.
In a recent technical paper Luca Canali explains how to find the mapping between physical storage, ASM allocation units, and database files by querying the undocumented X$ tables.
By using the information retrieved from X$KFFXP table he succeeded to:
  • Retrieve a file directly from ASM disks
  • Monitor how the extents in a datafile are allocated across ASM disks
  • Monitor how a datafile is spread across ASM disks due rebalancing operations
Here you can find the full version of the document: A peek Inside Oracle ASM Metadata

Luca Canali is working in the IT Department of CERN - European Organization for Nuclear Research Geneva, Switzerland.
Under HAandPerf section of the PSS Group you can find more very interesting white papers and presentations authored by Luca. Links to some of them:
Luca Canali is the author of SQLPython - a command line tool written in python that emulates Oracle's SQL*Plus basic functionalities.

Another interesting link with lot of technical information:
DBA Area of the Physics Database Services Support Group

Labels:


Permanent Link  @ 0 Comments on This Post  @ Comment Here

Christo Kutrovsky's Blog

Published Sunday, June 11, 2006 by Radoslav Rusinov.
If you’ve missed to notice – Christo Kutrovsky started his own professional blog dedicated mainly to the Oracle database.
Christo Kutrovsky is an Bulgarian Oracle professional currently working in Canada as a Senior Database/System Administrator for The Pythian Group.
His blog is a part of the corporate blog of The Pythian Group.
The blog is only two-months old but already has several very good and detailed technical posts:
  • Traceless DB Time Diagnosis -
    Discusses a method of how to find where the database is spending its time for a specific process/operation without using of sql_trace.
  • Quantifying Commit Time -
    Discusses how new 10g commit parameters "batch" and "nowait" can affect performance and how they can be used for measuring of the average commit time.
  • ASM multi-disk performance -
    Very interesting post about how different disk configurations using ASM can affect performance of the I/O operations. This post has already been mentioned by Doug Burns in his blog post Blog Round-Up.
  • Oracle 10g R2 RAC - vip on wrong interface -
    Discusses how to change used network interface for VIPs or private interconnect interface in a 10g RAC environment.
I can recommend it to everyone interested in Oracle, and it is well worth watching in the future.

The blog is still not included in the two most popular Oracle Aggregators: OraBlogs and OraNA :: Oracle News Aggregator but I hope this will change soon.

Labels:


Permanent Link  @ 0 Comments on This Post  @ Comment Here

A Simple Chapter from the "Cost-Based Oracle Fundamentals" is available for download

Published Wednesday, November 02, 2005 by Radoslav Rusinov.
A simple chapter from the Jonathan Lewis's book is available for download at this address: Chapter 05: The Clustering Factor

The book will be available for shipping in 5th of November at Amazon online bookstore: Cost-Based Oracle Fundamentals

Labels: ,


Permanent Link  @ 2 Comments on This Post  @ Comment Here

Oracle Database 10g: Best Practices for Windows Deployments

Published Tuesday, September 27, 2005 by Radoslav Rusinov.


This presentation is given on the Oracle OpenWorld this year. You can download it from here: Oracle Database 10g: Best Practices for Windows Deployments

Another interesting presentation from OOW 2005 is this one: What They Didn't Print in the Doc - HA Best Practices by the Gurus from Oracle Maximum Availability Architecture Team

Labels: ,


Permanent Link  @ 0 Comments on This Post  @ Comment Here

Oracle 10g ASM vs. Linux Filesystems, Part 2

Published Friday, September 09, 2005 by Radoslav Rusinov.

Andrew Carr let me to know that there is an interesting follow up to the ASM vs. LVM article on the Wim Coekaerts Blog: ASM vs LVM
Wim Coekaerts is the Director of Linux Engineering at Oracle.
The post is discussing the interaction between OS buffercache and Oracle buffercache and how they are affected by using ASM or Linux filesystem.

Labels: ,


Permanent Link  @ 2 Comments on This Post  @ Comment Here

Oracle 10g ASM vs. Linux Filesystems for non-RAC systems

Published Thursday, September 01, 2005 by Radoslav Rusinov.

Bert Scalzo has published an interesting article in Linux Journal that compares the performance of non-RAC Linux systems, which are using the new Oracle 10g feature - ASM versus using of Linux filesystems: Optimizing Oracle 10g on Linux: Non-RAC ASM vs. LVM

Labels: ,


Permanent Link  @ 2 Comments on This Post  @ Comment Here

A Big Set of Oracle Presentations from NYOUG

Published Friday, August 26, 2005 by Radoslav Rusinov.

On the web site of The New York Oracle Users Group (NYOUG) you can find some very interesting presentations from the recent NYOUG events:

June 2005
Things You “Know” - from Tom Kyte, Oracle Corporation

Resource Mapping: A Wait Time-Based Methodology for Database Performance Analysis – from Matt Larson, Confio Software
Presents the Resource Mapping Methodology and how it can be used for Wait-Event Analysis.

March 2005
Interpreting Execution Plans – from the OCM DBA in Oracle9i Tanel Põder, integrid.info

December 2004
Backup and Recovery - A Completeness Check - from Michael S. Abbey, The Pythian Group
What must be the strategy for checking of your backups.

Oracle Real Application Clusters: Expert Advice on Using RAC – from Darron Clark, Oracle Corporation
Why should I choose Real Application Clusters?

If you want to understand why the RAC may be is not the best solution for you, take a look here: You Probably Don't Need RAC

New and Improved Methods for Administering Your Database - from Howard Horowitz, HGH
Consulting
Good overview of some of the new features coming with Oracle 10g.

November 2004
Change Data Capture in Oracle 10g - from Jack Raitto, CDC Development Manager, Oracle Corporation
Sometimes you need to know what information has been changed in your database. It may be for reports or as a part of an elaborate ETL process. If the database wasn't designed with this in mind, you may have to develop a custom solution. This can be a costly and error-prone process including triggers and big inefficient queries. The alternative is to use Oracle's 9i feature - Change Data Capture (CDC). This is a nice solution and completely independent from the rest of the database design.

June 2004
Oracle 10g Feature: RMAN Incrementally Updated Backups - from Dave Anderson, SkillBuilders

Using 10046 trace data to resolve Oracle performance issues - A review of three case studies (Paper, Presentation) - from Jeff Holt and Gary Goodman, Hotsos Enterprises, Ltd.

Oracle 10g (OCP) Certification Preparation - from Howard Horowitz
The best information that I have ever found for 1Z0-040 exam, 91 pages full with examples, screenshots and helpful information for everyone who is planning to go for this exam.

The same document but with added notes inside the presentation: Oracle 10g (OCP) Certification Preparation

Another document from the same author: Oracle Certification Preparation (OCP) / Hidden Treasures

Some of the old ones:
V$Views: Don't Leave $Home Without Them - Michael Bell, BMC

ORA-3113's, 600's and 7445's Oh My! - Anita Bardeen, Oracle Corporation
Very helpful info (coming from Oracle employee) about three scary Oracle errors: ORA-3113 - "end-of-file on communication channel", ORA-600 and ORA-7445 - "exception encountered core dump"

Special: Oracle Support Answers Your Questions (Presentation, Paper) – Mike Fleck, Oracle Support
If you want to understand what are the common reasons for TAR requests and what are the roles and responsibilities inside the Oracle Support team.

For a full set of the NYOUG presentations: NYOUG Presentations
Note: Some of the links for the presentations are broken.

Labels:


Permanent Link  @ 2 Comments on This Post  @ Comment Here

About me

  • » I'm Radoslav Rusinov
  • » From Sofia, Bulgaria
  • » Employer TechnoLogica Ltd.
  • » I am working as a Database Consultant in Sofia, Bulgaria. My main professional interests are in the database area and especially in the Oracle RDBMS, including database design, development, security and administration.
  • » The views expressed on this blog are my own and do not necessarily reflect the views of my employing company and its affiliates
  • » My profile

RSS 2.0 Feed

Search This Blog with Google

Search This Blog with Free Find


powered by FreeFind

Search This Blog with Technorati

Recent Posts

Archives

Articles & Presentations

Discover Bulgaria

Oracle News & Blogs Aggregators

Oracle Resources

Remote DBA

Oracle User Groups

Oracle Blogs

Oracle Forums

Security Resources

Professional CV

Blog Statistics

              

              

               Page Rank Checker