270.631036303
+DATA1/rac/onlinelog/group_5.267.631036273
+DATA1/rac/onlinelog/group_6.268.631036281
+DATA1/rac/tempfile/temp.263.631035129
+RECOV1/rac/controlfile/current.256.631034953
+RECOV1/rac/onlinelog/group_1.257.631034965
+RECOV1/rac/onlinelog/group_2.258.631034977
+RECOV1/rac/onlinelog/group_3.261.631036301
+RECOV1/rac/onlinelog/group_4.262.631036307
+RECOV1/rac/onlinelog/group_5.259.631036277
+RECOV1/rac/onlinelog/group_6.260.631036285
22 rows selected.
SQL> show parameter spfile
NAME TYPE VALUE
--------------------- ----------- --------------------------
spfile string +DATA1/rac/spfilerac.ora
SQL>
382 Oracle Database 11g DBA Handbook
Cluster-Aware Dynamic Performance Views
The GV$ views make it easy to view each instance??™s characteristics in a single SELECT statement,
while at the same time filtering out nodes that you do not want to see; these views also make it
easier to aggregate totals from some or all of the nodes in the cluster, as in this example:
SQL> select nvl(to_char(inst_id),'TOTAL') INST#,
2 count(inst_id) sessions from gv$session
3 group by rollup(inst_id)
4 order by inst_id;
INST# SESSIONS
-------- ----------
1 48
2 48
3 44
TOTAL 140
4 rows selected.
From this query, you can see the number of sessions per instance and the total number of
instances for the cluster using the view GV$SESSION.
RAC Maintenance
Most of the maintenance operations you perform on a single-node instance apply directly to a
multiple-node RAC environment.
Pages:
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600