Re: OEM Table definitions
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <vitalisman@xxxxxxxxx>
- Date: Mon, 13 Jun 2005 08:45:50 -0400
I tried the following:
select ev_ti.target_name,ev.id,ev.name
from oem.smp_vde_event ev, oem.SMP_vde_event_target_info ev_ti
where ev.id=ev_ti.event_id
order by 1
;
However, in some cases an event is listed twice - I also have entries
for databases long ago deleted from OEM....
TARGET_NAME
------------------------------------------------------
ID NAME
---------- -------------------------------------------
cmedmoul
244 cont_alert_log
cmedmoul
263 cont_db
cmedmoul
208 cont_db
>>> Vitalis Jerome <vitalisman@xxxxxxxxx> 6/13/05 8:41:41 AM >>>
I don't know, but have a look at the most plausible tables from this
list:
1* select table_name from dba_tables where owner='repository owner'
and table_name like '%EVENT%'
SQL> /
TABLE_NAME
------------------------------
EPC_CLI_COLLECT_BY_EVENTID
SMP_VDE_EVENT
SMP_VDE_EVENT_ARCHIVE
SMP_VDE_EVENT_ARCHIVE_PURGE
SMP_VDE_EVENT_DETAILS
SMP_VDE_EVENT_LOCK_TAB
SMP_VDE_EVENT_LOG
SMP_VDE_EVENT_OCCURRENCE
SMP_VDE_EVENT_OCCUR_DETAILS
SMP_VDE_EVENT_TARGET_ACK
SMP_VDE_EVENT_TARGET_DETAILS
TABLE_NAME
------------------------------
SMP_VDE_EVENT_TARGET_INFO
SMP_VDE_EVENT_TARGET_STATE
SMP_VDE_EVENT_UPDOWN_QUEUE
SMP_VDE_TRY_REMOVE_EVENT_QUEUE
SMP_VDG_EVENTID_MAP
SMP_VDG_EVENT_DELETE_LIST
SMP_VDG_EVENT_NOTIF_LIST
18 rows selected.
On 6/10/05, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
> When adding a new database and/or server, we always go into OEM
> discoverer it and add our scheduled events. Anybody know which OEM
> table has the registered events and what is using them. I would like
to
> query OEM to ensure that we have scheduled the events on all servers
and
> that similar events for similar databases are scheduled.
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
