 |
|
Oracle Tips by Burleson |
Oracle Disk I/O Tuning
Chapter 5: Cluster File System
A shared
Oracle home also permits trace files and configuration files to be
shared so that system administrators can work from any single node
and access the whole system. Furthermore, patches need be applied
only once. Oracle9i has a new feature called ‘External Tables.’ The
external table feature allows data in simple flat files to be
treated as an Oracle table. It also allows the select command to be
used on External Tables. Furthermore, External Tables can be
accessed with Intra-node Parallel Query, taking advantage of the
full processing power of the cluster. Without the CFS, the facility
of External Tables becomes very limited. An External Table can be
created in a non-clustered file system but the access to it will be
limited to one node.
What is Context Dependent Symbolic Link?
When we
begin using the shared cluster file system, we have just one copy of
the entire directory structure. We have one set of directories where
the data files, control files, redo log files, and archive log files
are located. This is advantageous in many respects. However,
sometimes we may want the relationship between a set of files or a
directory and the shared CFS directory to be unique for each
node/host within the cluster.
The above text is
an excerpt from:
Oracle Disk I/O Tuning
Disk IO Performance & Optimization for Oracle
Databases
ISBN
0-9745993-4-4
by Mike Ault
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
