Re: OEM Table definitions

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=3D'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.
>=20
>=20
>=20
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

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