CLUSTER_INTERCONNECTS Specifies the network used for the cluster??™s IPC
traffic.
MAX_COMMIT_PROPAGATION_DELAY Controls how fast committed transactions
are propagated to other nodes. This value is
deprecated as of Oracle Database 11g.
TABLE 10-3 RAC-related Initialization Parameters
Chapter 10: Real Application Clusters 381
Common Database File Views
Some dynamic performance views are the same whether you??™re in a RAC environment or a
single-instance environment; the ASM configuration is a perfect example of this. In this query run
on any database instance in the cluster, you want to verify that all your database files are stored in
one of the two ASM disk groups, +DATA1or +RECOV1:
SQL> select name from v$datafile union
2 select name from v$tempfile union
3 select member from v$logfile union
4 select name from v$controlfile union
5 select name from v$flashback_database_logfile;
NAME
---------------------------------------------------------
+DATA1/rac/controlfile/current.260.631034951
+DATA1/rac/datafile/example.264.631035151
+DATA1/rac/datafile/sysaux.257.631034659
+DATA1/rac/datafile/system.256.631034649
+DATA1/rac/datafile/undotbs1.258.631034665
+DATA1/rac/datafile/undotbs2.265.631035931
+DATA1/rac/datafile/undotbs3.266.631035935
+DATA1/rac/datafile/users.259.631034665
+DATA1/rac/onlinelog/group_1.261.631034959
+DATA1/rac/onlinelog/group_2.262.631034973
+DATA1/rac/onlinelog/group_3.269.631036295
+DATA1/rac/onlinelog/group_4.
Pages:
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599