Oracle RAC SQL Query value incorrect (4310708)

We have a RAC with 2 nodes. On node1 we need to execute this command

SQL> select count(1) as count from v$sqlarea
2 where users_executing > 0 and sql_text like '%checkpoint%' and sql_text not like '%select%' ;

COUNT
----------
1

To get the status of a job running. Foglight cannot seem to return the correct results when done from the RAC level. How can we work around this?

The UDC (user defined collections) in RAC configuration connects randomly to one of the instances and there is no option to force connection to the specific instance.

The below sql should provide the desired information:

select count(1) as count from gv$sqlarea
where users_executing > 0 and sql_text like '%checkpoint%' and sql_text not like '%select%'
and inst_id=1;