ORACLE_OCM.MGMT_DB_LL_METRICS dependencies on V$PROCESS

Line 1222: select length(addr)*4 into l_word_length from v$process where rownum=1;

1218: ' dv_status_code ';
1219: END IF;
1220:
1221: -- the word length denotes 32 or 64-bit
1222: select length(addr)*4 into l_word_length from v$process where rownum=1;
1223: IF l_word_length = 64 THEN
1224: l_is_64bit := 'Y';
1225: ELSE
1226: l_is_64bit := 'N';

Line 1351: '(select length(addr)*4 word_len from gv$process where rownum=1) addr, ' ||

1347: 'CDB_PROPERTIES e, ' ||
1348: 'gv$nls_parameters nlsp1, ' ||
1349: 'gv$nls_parameters nlsp2, ' ||
1350: 'CDB_PROPERTIES p, ' ||
1351: '(select length(addr)*4 word_len from gv$process where rownum=1) addr, ' ||
1352: 'pdbview pdb, ' ||
1353: 'gv$pdbs vpb ' ||
1354: 'WHERE b.banner LIKE ''%Oracle%'' ' ||
1355: 'AND nlsp1.parameter = ''NLS_CHARACTERSET'' ' ||