DBA_AQ_AGENTS

DBA_AQ_AGENTS displays information about all registered AQ agents in the database.

Column	Datatype	NULL	Description
AGENT_NAME	VARCHAR2(30)	NOT NULL	Name of the AQ agent
HTTP_ENABLED	VARCHAR2(4)		Indicates whether the agent is allowed to access AQ through HTTP (YES) or not (NO)
SMTP_ENABLED	VARCHAR2(4)		Indicates whether the agent is allowed to access AQ through SMTP (YES) or not (NO)

Note:

1. Query all registered AQ agents in the database:

SELECT * FROM DBA_AQ_AGENTS;

AGENT_NAME	HTTP_ENABLED	SMTP_ENABLED
SCHEDULER$_EVENT_AGENT	NO	NO
SERVER_ALERT	NO	NO
HAE_SUB	NO	NO

Oracle data dictionary views

Oracle dynamic performance views