Books for you

You should consider the system profile in
spreading the system overhead over multiple drives. For example, if the application
generates a lot of data changes versus data reads, the I/O to the rollback
segments may increase due to higher writes for changes and higher reads for
consistent read functionality.
Sort activity can also affect disk I/O. Prior to Oracle Database 10g, youwou ld
get the majority of sorts to occur in memory through tuning the SORT_AREA_
SIZE parameter in the initialization file. Oracle constantly queries and updates
the data dictionary stored in the SYSTEM tablespace, and this information is
cached in the shared pool section of the SGA, so sizing your shared pool
properly is a key to overall performance. As of Oracle Database 10g, Oracle can
automatically and dynamically size the different pools in the SGA.
Use a different device for archiving and redo log files
To avoid archiving performance issues due to I/O contention, make sure that the
archive log destination uses different devices from those used for the redo logs
and redo log mirrors.


Pages:
341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365