Re: OEM Table definitions

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_at_gmail.com> 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_at_gcrta.org> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l