OCP-1Z0-053-V13.02-445题
来源:互联网 发布:linux怎么运行sh脚本 编辑:程序博客网 时间:2024/04/23 23:53
445.To set the history retention period for either window logging or job logging individually, which
parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME
Answer: AD
SET_SCHEDULER_ATTRIBUTE Procedure
This procedure sets the value of a Scheduler attribute. This takes effect immediately but the resulting changes may not be seen immediately.
Table 129-97 provides short attribute descriptions for the SET_SCHEDULER_ATTRIBUTE
procedure. For complete descriptions, see section "Setting Scheduler Preferences" in Oracle Database Administrator's Guide.
Syntax
Parameters
Table 129-97 SET_SCHEDULER_ATTRIBUTE Procedure Parameters
attribute
The name of the Scheduler attribute. Possible values are:
'default_timezone':
Repeating jobs and windows that use the calendaring syntax retrieve the time zone from this attribute whenstart_date
is not specified. See "Calendaring Syntax" for more information.'email_server':
The SMTP server address that the Scheduler uses to send e-mail notifications for job state events. E-mail notifications cannot be sent if this attribute isNULL
.'email_sender':
The default e-mail address of the sender of job state e-mail notifications.'email_server_credential':
The schema and name of an existing credential object thatSYS
has execute object privileges on. Default isNULL
. The username and password stored in this credential are used to authenticate with the e-mail server when sending e-mail notifications.This functionality is available with Oracle Database 11g Release 2 (11.2.0.2).
'email_server_encryption':
This attribute indicates whether or not encryption is enabled for this email server connection, and if so, at what point encryption starts, and with which protocol. Values are:NONE
: the default, indicating no encryption usedSSL_TLS
: indicating that eitherSSL
orTLS
are used, from the beginning of the connectionSTARTTLS:
indicating that the connection starts unencrypted, but the commandSTARTTLS
is sent to the e-mail server and starts encryption
This functionality is available starting with Oracle Database 11g Release 2 (11.2.0.2).
'event_expiry_time':
The time, in seconds, before a job state event generated by the Scheduler expires from the Scheduler event queue. IfNULL
, job state events expire after 24 hours.'log_history':
The number of days that log entries for both the job log and the window log are retained. Default is 30 and the range of valid values is 0 through 1000000.'max_job_slave_processes':
This Scheduler attribute is not used.
value
The new value of the attribute
Usage Notes
To run SET_SCHEDULER_ATTRIBUTE
, you must have the MANAGE
SCHEDULER
privilege.
PURGE_LOG Procedure
By default, the Scheduler automatically purges all rows in the job log and window log that are older than 30 days. The PURGE_LOG
procedure is used to purge additional rows from the job and window log.
Rows in the job log table pertaining to the steps of a chain are purged only when the entry for the main chain job is purged (either manually or automatically).
Syntax
Parameters
Table 129-69 PURGE_LOG Procedure Parameters
log_history
This specifies how much history (in days) to keep. The valid range is 0 - 1000000. If set to 0, no history is kept.
which_log
This specifies the log type. Valid values are: job_log
, window_log
, and job_and_window_log
.
job_name
This specifies which job-specific entries must be purged from the jog log. This can be a comma-delimited list of job names and job classes. Whenever job_name
has a value other than NULL
, the which_log
argument implicitly includes the job log.
Usage Notes
This procedure requires the MANAGE
SCHEDULER
privilege.
Examples
The following completely purges all rows from both the job log and the window log:
The following purges all rows from the window log that are older than 5 days:
The following purges all rows from the window log that are older than 1 day and all rows from the job log that are related to jobs in jobclass1
and older than 1 day:
- OCP-1Z0-053-V13.02-445题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- UIApplicationDelegate详解
- Android底部菜单栏(用TabHost一次性加载耗内存)
- 计算程序运行时间的函数clock()
- 【SQL Server DBA】日常巡检1:数据库空间、状态、使用的监控
- 笔记2(字符串翻转)
- OCP-1Z0-053-V13.02-445题
- android 语言国际化 + 点击按钮出现menu + 点击menu出现dialog对话框 + radiobutton 点击事件
- zeromq
- xml、properties配置文件的读取
- 分治法,循环赛日程表
- jquery学习心得,常用的操作
- android JNI学习六
- cocos2dx-jsb 跨语言调用
- notepad++6.5中文绿色汉化版下载