性能测试中发现oracle11g数据库每天22点,oralce进程CPU占用率突增

[glen_guest]

每天都会报以下信息（alert.log）：
CJQ0 started with pid=37, OS id=15515
Fri Nov 07 22:00:00 2008
Setting Resource Manager plan SCHEDULER[0x2C0D]:DEFAULT_MAINTENANCE_PLAN via schedul
er window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Nov 07 22:00:04 2008
Fri Nov 07 22:00:04 2008
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 37201
168
Sat Nov 08 02:00:00 2008
Clearing Resource Manager plan via parameter
Sat Nov 08 03:11:46 2008
Stopping background process CJQ0

已经查看了检查系统参数resource_manager_plan，没有打开。

也没有使用通过调度窗口启动过资源管理，都不知道怎么用它。

[hebo2005]

看看是否有后台有存储过程JOB之类的在跑

[wiler]

select * from dba_jobs;

[hebo2005]

像我们以前也遇到过后台用脚本在跑的情况（.SH）
我们有几个JOB跑的时候，系统就会变得狂慢

[microsoft_fly]

很有可能是表自动分析的功能引起的，以前我也碰到过

[BlueskyWide]

好象是Oracle自身体验显示的信息。详细参考：

http://tech.it168.com/db/o/2007-07-17/200707171742500.shtml


[Quote=引用楼主 glen_guest 的帖子:]
每天都会报以下信息（alert.log）：
CJQ0 started with pid=37, OS id=15515
Fri Nov 07 22:00:00 2008
Setting Resource Manager plan SCHEDULER[0x2C0D]:DEFAULT_MAINTENANCE_PLAN via schedul
er window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Nov 07 22:00:04 2008
Fri Nov 07 22:00:04 2008
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownS…
[/Quote]

[liuyi8903]

Found that the query it's been executed by this shadow process is:

SELECT EXECUTION_ID, STATUS, STATUS_DETAIL FROM MGMT_JOB_EXEC_SUMMARY
WHERE JOB_ID = :B3 AND
TARGET_LIST_INDEX = :B2 AND EXPE
CTED_START_TIME = :B1

This query is also shown at the dbconsole as the most intensive cpu usage query.

[hnsls33]

ding

[glen_guest]

请问，是否有方法规避它，谢谢。

[yonghengdizhen]

系统维护任务没法规避

[yonghengdizhen]

应该是在执行表分析之类的任务

[sleepzzzzz]

Oracle自身体验

[jxlbx]

可以禁 用