Team Fly 

Page 340

Ask the Expert

Q: After ASM disk groups are defined, how are they associated with a table?

A: ASM disk groups are referred to during tablespace creation, as in the following example:

1 create tablespace ts1
2   datafile  +diskgrp1 /alias1;

This listing creates tablespace ts1 in disk group diskgrp1. Note that this assumes that both diskgrp1 and alias1 have previously been defined.

A table can now be created in tablespace ts1 and it will use ASM data files.

While ASM can be implemented in a single-node environment, its real power and benefits are realized when used in RAC environments. This powerful combination is the heart of Oracle Database 10g's grid computing database architecture.

CRITICAL SKILL 9.8
Grid Computing: The ''g" in Oracle Database 10g

In this chapter, we have discussed many issues and demands surrounding large databases—performance, maintenance efforts, and so on. We have also discussed the solutions offered by Oracle Database 10g. Now we will have a high-level look at Oracle Database 10g's grid-computing capabilities.

NOTE
Oracle Database 10g's grid computing applies to both database and application layers. We will just be scratching the surface of grid computing and focusing on the database components.

The theory behind grid computing is that all parts of the grid (databases, applications, servers, disks, and so forth) work together in a highly integrated fashion, with each component being able to react appropriately to changes in other components in the grid. This results in efficient use of resources, faster response times, high availability, and so on.

Team Fly 
0359-CRITICAL SKILL 9.8 Grid Computing: The <em>''g"</em> in Oracle Database 10<em>g</em>