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”
标签：队列,视图,用户,名称,可以使用