Prev | Current Page 190 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

The
default, for a traditional Oracle instance, is RDBMS.
DB_UNIQUE_NAME The default value for the DB_UNIQUE_NAME parameter is +ASM and is the
unique name for a group of ASM instances within a cluster or on a single node.
ASM_POWER_LIMIT To ensure that rebalancing operations do not interfere with ongoing user I/
O, the ASM_POWER_LIMIT parameter controls how fast rebalance operations occur. The values
range from 1 to 11, with 11 being the highest possible value; the default value is 1 (low I/O
overhead). Because this is a dynamic parameter, you may set this to a low value during the day
and set it higher overnight whenever a disk-rebalancing operation must occur.
ASM_DISKSTRING The ASM_DISKSTRING parameter specifies one or more strings, operating
system dependent, to limit the disk devices that can be used to create disk groups. If this value is
NULL, all disks visible to the ASM instance are potential candidates for creating disk groups. For
the examples in this chapter for our test server, the value of the ASM_DISKSTRING parameter is /
dev/raw/*:
SQL> select name, type, value from v$parameter
2 where name = 'asm_diskstring';
NAME TYPE VALUE
--------------- ---------- -------------------------
asm_diskstring 2 /dev/raw/*
ASM_DISKGROUPS The ASM_DISKGROUPS parameter specifies a list containing the names
of the disk groups to be automatically mounted by the ASM instance at startup or by the alter
diskgroup all mount command.


Pages:
178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202
owerloki Pozycjonowanie przechowalnie seo twoje-miasto-poznan.pl mapa