Oracle 视图 ALL_QUEUE_SCHEDULES 官方解释，作用，如何使用详细说明
本站中文解释
？
Oracle视图ALL_QUEUE_SCHEDULES描述了当前用户可用的所有队列调度。它是DBA_QUEUE_SCHEDULES和USER_QUEUE_SCHEDULES的一个联合视图，包括拥有者名称，队列的编号，队列名称，时间表，激活或禁止状态，和备注。
使用Oracle视图ALL_QUEUE_SCHEDULES可以方便地查询和管理用户队列调度。 DBA可以使用它来监控和管理用户队列调度，以确保它们在时间表中运行，并且没有意外情况。
该视图可以使用以下SQL语句来检索涉及的信息：
SELECT OWNER, SCHEDULE_NAME, SCHEDULE_PACE, ACTIVE
FROM ALL_QUEUE_SCHEDULES
WHERE OWNER = ‘USERNAME’
AND SCHEDULE_PACE=’HOURLY’;
此查询将返回指定用户的每小时调度名称，调度速度和活动状态。
官方英文解释
ALL_QUEUE_SCHEDULES describes the propagation schedules whose source queues are accessible to the current user.
Related Views
-
DBA_QUEUE_SCHEDULESdescribes all propagation schedules in the database. -
USER_QUEUE_SCHEDULESdescribes the propagation schedules whose source queues are owned by the current user. This view does not display theSCHEMAcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Source queue owner |
|
|
|
|
Source queue name |
|
|
|
|
Destination name, currently limited to be a |
|
|
|
|
Date at which to start propagation |
|
|
|
|
Time of day at which to start propagation (in |
|
|
|
|
Duration for the propagation window (in seconds) |
|
|
|
|
Function to compute the start of the next propagation window |
|
|
|
|
Maximum wait time to propagate a message during the propagation window |
|
|
|
|
Indicates whether the schedule is disabled ( |
|
|
|
|
Name of the process executing the schedule; |
|
|
|
|
Session ID and session serial number of the job executing this schedule (SID, SERIAL#); |
|
|
|
|
Cluster database instance number executing the schedule |
|
|
|
|
Date of the last successful execution |
|
|
|
|
Time of day of the last successful execution (in |
|
|
|
|
Date at which the current window of this schedule was started |
|
|
|
|
Time of day at which the current window of this schedule was started (in |
|
|
|
|
Date at which the next window of this schedule will be started |
|
|
|
|
Time of day at which the next window of this schedule will be started (in |
|
|
|
|
Total time spent by the system in executing this schedule (in seconds) |
|
|
|
|
Total number of messages propagated in this schedule |
|
|
|
|
Total number of bytes propagated in this schedule |
|
|
|
|
Maximum number of messages propagated in a propagation window |
|
|
|
|
Maximum number of bytes propagated in a propagation window |
|
|
|
|
Average number of messages propagated in a propagation window |
|
|
|
|
Average size of a propagated message (in bytes) |
|
|
|
|
Average time to propagate a message (in seconds) |
|
|
|
|
Number of consecutive times schedule execution has failed, if any. After 16 consecutive failures, a propagation job becomes disabled automatically. |
|
|
|
|
Date of the last unsuccessful execution |
|
|
|
|
Time of day of the last unsuccessful execution (in |
|
|
|
|
Error number and error message text of the last unsuccessful execution |
|
|
|
|
Message delivery mode:
|
|
|
|
|
Elapsed dequeue time (in hundredths of a second) |
|
|
|
|
Elapsed pickle time (time taken to linearize a logical change record (LCR) into a stream of bytes that can be sent over the network) (in hundredths of a second) |
|
|
|
|
Name of the Scheduler job |
See Also:
-
“DBA_QUEUE_SCHEDULES”
-
“USER_QUEUE_SCHEDULES”
