Over 10 Million Study Resources Now at Your Fingertips


Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Language:EN
Pages: 2

The file now open and the database process initializes the file

Chapter 12 ■ tuning the Storage SubSyStem

4
+ASM1 SSKY1 3 DBWR 7

SAN switch

ASMB +ASM2

SSKY2

LMSn
1
6
ARBn CSS
EVM
RBAL
2 CSS EVM
5
CRS CRS
DBWR

Vote Disk

AA_00 AB_01 AC_02 AD_03 AE_04 AF_05 AG_06

AH_07

During the RDBMS instance startup process, this information is used by the RDBMS instance to retrieve all diskgroup information from the ASM instance.

4. When a user adds a new disk to an existing diskgroup, the RBAL background process will create a map to reorganize the extents in the diskgroup. The RBAL process will then send a message to the ARBn background process to reorganize the extents. The number of ARBn background processes started is based on the parameter ASM_POWER_LIMIT.

a. The DBA issues a statement to create a tablespace or add a datafile; the database requests ASM for file creation.

b. An ASM foreground process creates a Continuing Operation Directory (COD) entry and allocates space for the new file across the diskgroup.

9. Based on user activity on the database instance, any updates to the data on the ASM devices are performed by the DBWR process on the RDBMS instance. Such activity is performed using the layout obtained by the RDBMS instance from the ASM instance (illustrated in Step 6 above).

Allocation Units

•� 16 AUs for extents above 40,000

For the first 20,000 extents within a file, each extent contains one allocation unit. Extents are allocated on different disks in a round robin fashion in order to spread the file and distribute I/O during read/write operations. Beyond the first 20,000 extents, space is allocated in groups of eight extents at a time. Each extent contains four allocation units for the second 20,000 extents, or 16 allocation units for all extents beyond 40,000. Extents are still allocated on different disks to spread the file out, but, in addition, each allocation unit is written in turn to a different extent until each set of eight extents is filled. The result is that consecutive allocation units will always be in different extents.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Payment
Make payment
Document download
Download File
PageId: ELI4C39F99
img
Uploaded by :
AmQBknME
Page 1 Preview
the file now open and the database process initial
Sell Your Old Documents & Earn Wallet Balance