select '1','0',
r.obj#,
(select value(o) from sys.ku$_schemaobj_view o where
o.obj_num=r.obj#),
r.group_or_subplan,
r.is_subplan,
decode(r.mgmt_p1,4294967295,0,r.mgmt_p1),
decode(r.mgmt_p2,4294967295,0,r.mgmt_p2),
decode(r.mgmt_p3,4294967295,0,r.mgmt_p3),
decode(r.mgmt_p4,4294967295,0,r.mgmt_p4),
decode(r.mgmt_p5,4294967295,0,r.mgmt_p5),
decode(r.mgmt_p6,4294967295,0,r.mgmt_p6),
decode(r.mgmt_p7,4294967295,0,r.mgmt_p7),
decode(r.mgmt_p8,4294967295,0,r.mgmt_p8),
decode(r.active_sess_pool_p1,4294967295,0,r.active_sess_pool_p1),
decode(r.queueing_p1,4294967295,0,r.queueing_p1),
decode(r.parallel_degree_limit_p1,4294967295,0,
r.parallel_degree_limit_p1),
r.switch_group,
decode(r.switch_time,4294967295,0,r.switch_time),
decode(r.switch_estimate,4294967295,0,r.switch_estimate),
decode(r.max_est_exec_time,4294967295,0,r.max_est_exec_time),
decode(r.undo_pool,4294967295,0,r.undo_pool),
r.description, r.status, r.mandatory
from resource_plan_directive$ r
SELECT '1'
, '0'
,
R.OBJ#
,
(SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O WHERE
O.OBJ_NUM=R.OBJ#)
,
R.GROUP_OR_SUBPLAN
,
R.IS_SUBPLAN
,
DECODE(R.MGMT_P1
, 4294967295
, 0
, R.MGMT_P1)
,
DECODE(R.MGMT_P2
, 4294967295
, 0
, R.MGMT_P2)
,
DECODE(R.MGMT_P3
, 4294967295
, 0
, R.MGMT_P3)
,
DECODE(R.MGMT_P4
, 4294967295
, 0
, R.MGMT_P4)
,
DECODE(R.MGMT_P5
, 4294967295
, 0
, R.MGMT_P5)
,
DECODE(R.MGMT_P6
, 4294967295
, 0
, R.MGMT_P6)
,
DECODE(R.MGMT_P7
, 4294967295
, 0
, R.MGMT_P7)
,
DECODE(R.MGMT_P8
, 4294967295
, 0
, R.MGMT_P8)
,
DECODE(R.ACTIVE_SESS_POOL_P1
, 4294967295
, 0
, R.ACTIVE_SESS_POOL_P1)
,
DECODE(R.QUEUEING_P1
, 4294967295
, 0
, R.QUEUEING_P1)
,
DECODE(R.PARALLEL_DEGREE_LIMIT_P1
, 4294967295
, 0
,
R.PARALLEL_DEGREE_LIMIT_P1)
,
R.SWITCH_GROUP
,
DECODE(R.SWITCH_TIME
, 4294967295
, 0
, R.SWITCH_TIME)
,
DECODE(R.SWITCH_ESTIMATE
, 4294967295
, 0
, R.SWITCH_ESTIMATE)
,
DECODE(R.MAX_EST_EXEC_TIME
, 4294967295
, 0
, R.MAX_EST_EXEC_TIME)
,
DECODE(R.UNDO_POOL
, 4294967295
, 0
, R.UNDO_POOL)
,
R.DESCRIPTION
, R.STATUS
, R.MANDATORY
FROM RESOURCE_PLAN_DIRECTIVE$ R
|
|
|