10g RAC在ASM实例下查询gv$session,会报错ORA-12850;11g RAC中查询正常!!!
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string +ASM1
/dbbackup@rac1=>+ASM1$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on 14 12:55:40 2017
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select count(1) from gv$session where status='ACTIVE';
select count(1) from gv$session where status='ACTIVE'
*
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 3 needed, 2
allocated
SQL> select count(1) from v$session;
COUNT(1)
----------
38
SQL> select count(1) from v$session where status ='ACTIVE';
COUNT(1)
----------
23
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string +ASM1
/dbbackup@rac1=>+ASM1$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on 14 12:55:40 2017
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select count(1) from gv$session where status='ACTIVE';
select count(1) from gv$session where status='ACTIVE'
*
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 3 needed, 2
allocated
SQL> select count(1) from v$session;
COUNT(1)
----------
38
SQL> select count(1) from v$session where status ='ACTIVE';
COUNT(1)
----------
23