Home arrow Oracle arrow Page 6 - Getting Started with Oracle Database 10g

ASM and Data Dictionary Views - Oracle

This chapter explains the "g" in 10g and how to upgrade to 10g. Learn about the SYSAUX Tablespace, automatic storage management and Oracle Database 10g Real Application Clusters (chapter 1 from the book, Oracle Database 10g New Features, by Robert Freeman, McGraw/Hill-Osborne, 2004, ISBN: 0072229470).

TABLE OF CONTENTS:
  1. Getting Started with Oracle Database 10g
  2. Upgrading to Oracle Database 10g
  3. The Database Configuration Assistant
  4. Automatic Storage Management
  5. Setting Up ASM Disks
  6. ASM and Data Dictionary Views
  7. Oracle Database 10g Real Application Clusters
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 24
July 07, 2004

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Several new data dictionary views exist to help you manage ASM. These data dictionary views are available both when connected to the ASM instance as well as to any Oracle Database 10g database. Each view is slightly different in its presentation depending on whether the instance you are looking at is an ASM instance or a database instance (and some views are only used in the ASM instance). Let's quickly look at these views.

V$ASM_ALIAS

When you are connected to an ASM instance, the V$ASM_ALIAS view displays a single row for every alias present in every disk group mounted by the ASM instance. This view is not used when connected to a normal database instance (no rows will be displayed).

V$ASM_CLIENT

When you are connected to an ASM instance, the V$ASM_CLIENT view displays a single row for every database instance using a disk group managed by the ASM instance. When you are connected to a normal database instance and the database has open ASM files, the V$ASM_CLIENT view displays a single row for the ASM instance.

V$ASM_DISK

When you are connected to an ASM instance, the V$ASM_DISK view displays a single row for every disk discovered by the ASM instance, including disks that are not part of any disk group. When you are connected to a normal database instance, the V$ASM_DISK view only displays rows for disks in disk groups in use by the database instance.

V$ASM_DISKGROUP

When you are connected to an ASM instance, the V$ASM_DISKGROUP view displays a single row for each disk group discovered by the ASM instance. When you are connected to a database instance, the V$ASM_DISKGROUP view displays a single row for every ASM disk group mounted by the local ASM instance.

V$ASM_FILE

When you are connected to an ASM instance, the V$ASM_FILE view displays a single row for every ASM file in every disk group mounted by the ASM instance. This view is not used when connected to a normal database instance (no rows will be displayed).

V$ASM_OPERATION

When you are connected to an ASM instance, the V$ASM_OPERATION view displays a single row for every active ASM long-running operation executing in the ASM instance. This view is not used when connected to a normal database instance (no rows will be displayed).

V$ASM_TEMPLATE

When you are connected to an ASM instance, the V$ASM_TEMPLATE view displays a single row for every template present in every disk group mounted by the ASM instance. When you are connected to a database instance, the V$ASM_TEMPLATE view displays a single row for every ASM disk group mounted by the local ASM instance.

This is just a quick introduction to the power of ASM. A small book probably could be written on just this new feature alone. Still, I hope I have gotten you interested in it!

This chapter is from Oracle Database 10g New Features, by Robert Freeman (McGraw-Hill/Osborne, 2004, ISBN: 0072229470). Check it out at your favorite bookstore today. Buy this book now.



 
 
>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: