select a.task_id as task_id,
a.instance_number as instance_number,
a.instance_name as instance_name,
a.host_name as host_name,
a.status as status,
a.database_time as database_time,
a.active_sessions as active_sessions,
a.perc_active_sess as perc_active_sess,
a.meter_level as meter_level,
a.local_task_id as local_task_id
from wri$_adv_addm_inst a
SELECT A.TASK_ID AS TASK_ID
,
A.INSTANCE_NUMBER AS INSTANCE_NUMBER
,
A.INSTANCE_NAME AS INSTANCE_NAME
,
A.HOST_NAME AS HOST_NAME
,
A.STATUS AS STATUS
,
A.DATABASE_TIME AS DATABASE_TIME
,
A.ACTIVE_SESSIONS AS ACTIVE_SESSIONS
,
A.PERC_ACTIVE_SESS AS PERC_ACTIVE_SESS
,
A.METER_LEVEL AS METER_LEVEL
,
A.LOCAL_TASK_ID AS LOCAL_TASK_ID
FROM WRI$_ADV_ADDM_INST A
|
|
|