??? Oracle has simplified striping in Oracle Database 10g and
newer releases by enabling striping through Enterprise Manager leveraging ASM.
Use tablespaces to clearly segregate and target different types of I/O
Separate table I/O from index I/O by placing these structures in different
tablespaces. Youcan then place the datafiles for these tablespaces on various
disks to provide better performance for concurrent access.
Using tablespaces to segregate objects also simplifies tuning later on. Oracle
implements I/O activity at the level of the datafile, or the physical object the
operating system sees as a file, and each file is a part of only one tablespace, as
described in Chapter 4. Placing specific objects in specific tablespaces allows you
to accurately measure and direct the I/O for those objects by tracking and moving
the underlying datafiles as needed.
For example, consider a database with several large, busy tables. Placing multiple
large tables in a single tablespace makes it difficult to determine which table
is causing the I/O to the underlying datafiles.
Pages:
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363