Oracle 视图 ALL_SCHEDULER_DB_DESTS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_SCHEDULER_DB_DESTS视图中存储了Oracle调度器中定义的数据库目的地的信息。这种目的地是一种特殊的连接方法，用于运行数据库任务，它由一个连接字符串、一个用户名和一个可选的密码组成。可以通过PooledJobs参数来设置目标，这样任务可以从连接池中获取连接，从而减少创建连接和关闭连接期间的开销。
使用方法:
1. 通过sql查询ALL_SCHEDULER_DB_DESTS视图，可以查看系统中已定义的目标是什么
2. 通过DBMS_SCHEDULER.ADD_DB_DESTCOMMAND可以添加新的DB目标。
3. 通过DBMS_SCHEDULER.ALTER_DB_DEST和DBMS_SCHEDULER.DROP_DB_DEST命令编辑和删除现有的DB目标。
官方英文解释
ALL_SCHEDULER_DB_DESTS displays information about the destination objects accessible to the current user pointing to remote databases.
Related Views
-
DBA_SCHEDULER_DB_DESTSdisplays information about all destination objects in the database pointing to remote databases. -
USER_SCHEDULER_DB_DESTSdisplays information about the destination objects owned by the current user pointing to remote databases. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of this destination object |
|
|
|
|
Name of this destination object |
|
|
|
Connect string to connect to the remote database |
|
|
|
|
Name of the agent through which the connection to the remote database is being made |
|
|
|
|
Indicates whether this destination object is enabled ( |
|
|
|
|
Indicates whether all referenced objects are enabled ( |
|
|
|
|
Optional comment |
See Also:
-
“DBA_SCHEDULER_DB_DESTS”
-
“USER_SCHEDULER_DB_DESTS”
