When refreshing the Job/Script Monitor page, it is taking a long time and it appears that Space Manager GUI hangs.
Underlying query that takes a long time to run is:
select sid from gv$session
module = 'Quest Server Agent' and
action = 'Daemon' and
status in ('ACTIVE', 'INACTIVE');
The same query runs slow when executed directly on the server via SQLPlus. This is a RAC environment.
This is more of an environmental issue. Check the explain plan of the query and see if further tuning can be done. One user case was resolved by modifying the cluster_interconnects parameter and adding another IP address of the RAC instance. Please refer to the Oracle documentation for more details of this parameter.