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



Luca Canali and ASM Metadata Internals


E-mail this post



Remember me (?)



All personal information that you provide here will be governed by the Privacy Policy of Blogger.com. More...



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:



0 Responses to “Luca Canali and ASM Metadata Internals”

Leave a Reply

      Convert to boldConvert to italicConvert to link

 



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

Previous 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