Oracle Database Discussions

It seems that dbms_xplan does not working in RAC environment, here are proofs

select * from
(
select sql_id from gv$sql_plan
minus select sql_id from v$sql_plan
) where rownum < 10

SQL_ID
-------------
003ssz84yp0fm
008cb6gzakmxk
009f9886jpsup
0103qb611xu3g
0115c20ufk1aj
011bkqb0xaxpp
014g88bbakzst
0171848fya3m1
018mx2ats69yc

SQL> select * from table(dbms_xplan.display_cursor('003ssz84yp0fm'));

PLAN_TABLE_OUTPUT
---------------------------------------------------------------------
SQL_ID: 003ssz84yp0fm, child number: 0 cannot be found

It always says the plan information cannot be found

select * from
(
select sql_id from gv$sql_plan
minus select sql_id from v$sql_plan
) where rownum < 10

SQL_ID
-------------
1w4kqy6ac8007
1w4kqy6ac8007
1w4kqy6ac8007
1ngw1nr5s400s
1ngw1nr5s400s
2huh3td30s02d
2huh3td30s02d
2huh3td30s02d
2huh3td30s02d

SQL> select * from table(dbms_xplan.display_cursor('1ngw1nr5s400s'))

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------
SQL_ID 1ngw1nr5s400s, child number 0
-------------------------------------
INSERT INTO STATS$LIBRARYCACHE ( SNAP_ID , DBID , INSTANCE_NUMBER ,
….

It only works for the sql_ids in v$sql_plan not all the things in the global one

DB version info:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options