SQL>select name from v$services; NAME ------------------------------ SYS$BACKGROUND SYS$USERS ebs_accnt accnt cdbXDB cdb accnt_ebs_patch 7 rows selected. SQL> select name from dba_services; NAME ------------------------------ SYS$BACKGROUND SYS$USERS accntXDB cdb cdbXDB cdb.skead.no ebs_PATCH 7 rows selected.New services were added and few services were stopped recently.
Answer:
The difference is due to the following:
* DBA_SERVICES - This view lists all the services that are in the database. This includes both started and stopped services.
* V$SERVICES - This view lists only the services that were started some time since the instance startup. When you stop a running service, that service will still be listed in this view until the next instance restart.
Oracle states that "The difference between these outputs does not pose any issue."
Source: Differences in outputs between DBA_SERVICES and V$SERVICES view (Doc ID 1496074.1) found at support.oracle.com
No comments:
Post a Comment