DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on V$MYSTAT

Line 6334: where sid = (select min(sid) from v$mystat where rownum < 2);

6330: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6331: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6332: into l_pdml_state, l_pq_state
6333: from v$session
6334: where sid = (select min(sid) from v$mystat where rownum < 2);
6335:
6336: commit;
6337: execute immediate 'alter session disable parallel query';
6338: execute immediate 'alter session disable parallel dml';

Line 6483: where sid = (select min(sid) from v$mystat where rownum < 2);

6479: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6480: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6481: into l_pdml_state, l_pq_state
6482: from v$session
6483: where sid = (select min(sid) from v$mystat where rownum < 2);
6484:
6485: commit;
6486: end if;
6487:

Line 6507: where sid = (select min(sid) from v$mystat where rownum < 2);

6503: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6504: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6505: into l_pdml_state, l_pq_state
6506: from v$session
6507: where sid = (select min(sid) from v$mystat where rownum < 2);
6508:
6509: commit;
6510: execute immediate 'alter session enable parallel query';
6511: execute immediate 'alter session enable parallel dml';