| |
 |
|
Oracle Tips by Burleson |
Oracle 10g Automated Storage
Management Viewing Information About Automated Storage Management
There are seven
new v$ views provided in Oracle Database 10g used to monitor ASM
structures. These views are shown in Table 1.2.
|
VIEW |
ASM INSTANCE |
DB INSTANCE |
|
v$ASM_diskgroup |
Describes a
disk group (number, name, size related info, state, and redundancy
type) |
Contains one
row for every open ASM disk in the DB instance. |
|
v$ASM_client |
Identifies
databases using disk groups managed by the ASM instance.
|
Contains no
rows. |
|
v$ASM_disk
|
Contains one
row for every disk discovered by the ASM instance, including disks
that are not part of any disk group. |
Contains rows
only for disks in the disk groups in use by that DB instance. |
|
v$ASM_file
|
Contains one
row for every ASM file in every disk group mounted by the ASM
instance. |
Contains rows
only for files that are currently open in the DB instance. |
|
v$ASM_template |
Contains one
row for every template present in every disk group mounted by the
ASM instance. |
Contains no
rows |
|
v$ASM_alias
|
Contains one
row for every alias present in every disk group mounted by the ASM
instance. |
Contains no
rows. |
|
v$ASM_operation |
Contains one
row for every active ASM long running operation executing in the
ASM instance. |
Contains no
rows. |
In this section we've taken an in depth view of the new Automated
Storage Management features of Oracle Database 10g. These new features
should revolutionize managing the physical database files in Oracle.
Next, we will example the improvements to the Real Application
Clusters installation and configuration.
Get the complete Oracle10g story:
To get the code instantly, click
here:
http://www.rampant-books.com/book_2003_2_oracle10g.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
