oracle数据库占用率高,windows下oracle cpu 使用率奇高 爆满， 求解决方法

不会用awr的话看这个：

http://docs.oracle.com/cd/E11882 ... stat.htm#PFGRF94203

5.3.6.1 Generating an AWR Report

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot IDs.

To generate an AWR report:

At the SQL prompt, enter:

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

Specify whether you want an HTML or a text report:

Enter value for report_type: text

In this example, a text report is chosen.

Specify the number of days for which you want to list snapshot IDs.

Enter value for num_days: 2

A list of existing snapshots for the specified time range is displayed. In this example, snapshots captured in the last 2 days are displayed.

Specify a beginning and ending snapshot ID for the workload repository report:

Enter value for begin_snap: 150

Enter value for end_snap: 160

In this example, the snapshot with a snapshot ID of 150 is selected as the beginning snapshot, and the snapshot with a snapshot ID of 160 is selected as the ending snapshot.

Enter a report name, or accept the default report name:

Enter value for report_name:

Using the report name awrrpt_1_150_160

In this example, the default name is accepted and an AWR report named awrrpt_1_150_160 is generated.