OCP 1Z0 053 111
来源:互联网 发布:公主联盟静态数据 编辑:程序博客网 时间:2024/04/29 07:02
A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
B. The user cannot set privileges on persistent lightweight jobs.
C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run
infrequently.
E. The use of a template is mandatory to create persistent lightweight jobs.
Answer: BCE
http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN13368
Lightweight Jobs
Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain.
Lightweight jobs have the following characteristics:
Unlike regular jobs, they are not schema objects.
They have significantly better create and drop times over regular jobs because they do not have the overhead of creating a schema object.
They have lower average session create time than regular jobs.
They have a small footprint on disk for job metadata and run-time data.
You designate a lightweight job by setting the job_style
job attribute to 'LIGHTWEIGHT
'. The other job style is 'REGULAR
', which is the default.
Like programs and schedules, regular jobs are schema objects. In releases before Oracle Database 11g Release 1, the only job style supported by the Scheduler was regular.
A regular job offers the maximum flexibility but does entail some overhead when it is created or dropped. The user has fine-grained control of the privileges on the job, and the job can have as its action a program or a stored procedure owned by another user.
If a relatively small number of jobs that run infrequently need to be created, then regular jobs are preferred over lightweight jobs.
A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either 'PLSQL_BLOCK
' or 'STORED_PROCEDURE
'. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job.
- OCP 1Z0 053 111
- OCP 1Z0 053 1
- OCP 1Z0 051 111
- OCP 1Z0 052 111
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- MFC学习笔记1
- hdu1907
- poj3020
- python中eval, exec, execfile,和compile [转载]
- C++ linked list 中添加某一个特定位置节点
- OCP 1Z0 053 111
- C++模板函数声明定义分离编译错误详解
- malloc 之后的父子进程之间的空间关系如何
- HDU 1016 Prime Ring Problem(DFS回溯)
- POJ 1753 Flip Game
- Keil串口仿真调试
- 单例模式——懒汉模式和饿汉模式
- Tomcat 启动失败 IllegalArgumentException: Malformed
- eclipse Package的设置