| Run ASH Report |
 |
| Specify the time period for the report. |  |
|
| | Report Results | |
|
|
ASH Report For ORCL/orcl | DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| ORCL | 1193379843 | orcl | 1 | 10.2.0.3.0 | NO | SACHCHIDA-PC | | CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|
| 2 | 584M (100%) | 360M (61.6%) | 184M (31.5%) | 4.0M (0.7%) |
| Sample Time | Data Source |
|---|
| Analysis Begin Time: | 24-Sep-08 10:22:32 | V$ACTIVE_SESSION_HISTORY | | Analysis End Time: | 24-Sep-08 10:27:32 | V$ACTIVE_SESSION_HISTORY | | Elapsed Time: | 5.0 (mins) | | | Sample Count: | 11 | | | Average Active Sessions: | 0.04 | | | Avg. Active Session per CPU: | 0.02 | | | Report Target: | None specified | | ASH Report
Back to Top
Top Events Back to Top Top User Events | Event | Event Class | % Activity | Avg Active Sessions |
|---|
| db file sequential read | User I/O | 54.55 | 0.02 | | CPU + Wait for CPU | CPU | 36.36 | 0.01 |
Back to Top Events
Back to Top Top Background Events | Event | Event Class | % Activity | Avg Active Sessions |
|---|
| os thread startup | Concurrency | 9.09 | 0.00 |
Back to Top Events
Back to Top Top Event P1/P2/P3 Values | Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|
| db file sequential read | 54.55 | "1","27757","1" | 9.09 | file# | block# | blocks | | | | "1","60501","1" | 9.09 | | | | | | | "3","3834","1" | 9.09 | | | |
Back to Top Events
Back to Top Load Profile Back to Top Top Service/Module | Service | Module | % Activity | Action | % Action |
|---|
| SYS$USERS | Admin Connection | 72.73 | UNNAMED | 72.73 | | | emagent.exe | 18.18 | UNNAMED | 18.18 | | SYS$BACKGROUND | UNNAMED | 9.09 | UNNAMED | 9.09 |
Back to Load Profile
Back to Top Top Client IDs | Client ID | % Activity | Avg Active Sessions | User | Program | Service |
|---|
| SYS@Sachchida-PC@Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US | 72.73 | 0.03 | SYS | OMS | SYS$USERS |
Back to Load Profile
Back to Top Top SQL Command Types - 'Distinct SQLIDs' is the count of the distinct number of SQLIDs with the given SQL Command Type found over all the ASH samples in the analysis period
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|
| PL/SQL EXECUTE | 1 | 72.73 | 0.03 | | INSERT | 1 | 9.09 | 0.00 | | SELECT | 1 | 9.09 | 0.00 |
Back to Load Profile
Back to Top Top SQL Back to Top Top SQL Statements | SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|
| 8u809k64x3nzd | | 72.73 | db file sequential read | 45.45 | begin DBMS_WORKLOAD_REPOSITORY... | | | | 72.73 | CPU + Wait for CPU | 27.27 | begin DBMS_WORKLOAD_REPOSITORY... | | 3kmkqn10x3m0x | 1983056714 | 9.09 | db file sequential read | 9.09 | INSERT INTO DBSNMP.MGMT_SNAPSH... | | cp5caasd2udnw | 3838994914 | 9.09 | CPU + Wait for CPU | 9.09 | /* OracleOEM */ SELEC... |
Back to Top SQL
Back to Top |
Top SQL using literals No data exists for this section of the report. Back to Top SQL
Back to Top Complete List of SQL Text | SQL Id | SQL Text |
|---|
| 3kmkqn10x3m0x | INSERT INTO DBSNMP.MGMT_SNAPSHOT_SQL( SNAP_ID, SQL_ID, HASH_VALUE, CHILD_NUMBER, ELAPSED_TIME, EXECUTIONS) SELECT :B2 , SQL_ID, HASH_VALUE, -1, ELAPSED_TIME, EXECUTIONS FROM V$SQLAREA WHERE EXECUTIONS > :B1 AND PARSING_USER_ID NOT IN (SELECT USER_ID FROM DBA_USERS WHERE USERNAME IN ('SYS', 'SYSMAN', 'DBSNMP')) | | 8u809k64x3nzd | begin DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end; | | cp5caasd2udnw | /* OracleOEM */ SELECT TO_CHAR(CAST(md.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, md.user_wait_time_pct, md.db_time_ps db_time_users, md.cpu_time_ps db_cpu_users, DECODE(:1, 'TRUE', md.host_cpu_usage_pct, NULL) host_cpu_usage_pct, wcd.users userio_users, :2 max_cpu_cnt FROM (SELECT DISTINCT wait_class_id FROM v$event_name WHERE wait_class = 'User I/O' AND :3 = 'TRUE') wcn, (SELECT wait_class_id, intsize_csec, end_time, time_waited / intsize_csec users FROM v$waitclassmetric_history WHERE end_time >= SYSDATE - 15/(60*24)) wcd, (SELECT intsize_csec, end_time, SUM(CASE WHEN metric_name = 'Database Wait Time Ratio' THEN value ELSE 0 END) user_wait_time_pct, SUM(CASE WHEN metric_name = 'Database Time Per Sec' THEN value / 100 ELSE 0 END) db_time_ps, SUM(CASE WHEN metric_name = 'CPU Usage Per Sec' THEN value / 100 ELSE 0 END) cpu_time_ps, SUM(CASE WHEN metric_name = 'Host CPU Utilization (%)' THEN value ELSE 0 END) host_cpu_usage_pct FROM v$sysmetric_history WHERE metric_name IN ('Database Wait Time Ratio', 'Database Time Per Sec', 'CPU Usage Per Sec', 'Host CPU Utilization (%)') AND group_id = 2 AND end_time >= SYSDATE - 15/(60*24) GROUP BY intsize_csec, end_time) md WHERE wcn.wait_class_id = wcd.wait_class_id AND wcd.intsize_csec = md.intsize_csec AND wcd.end_time = md.end_time AND :4 != 'BASIC' ORDER BY md.end_time ASC | Back to Top SQL
Back to Top Top PL/SQL Procedures - 'PL/SQL entry subprogram' represents the application's top-level entry-point(procedure, function, trigger, package initialization or RPC call) into PL/SQL.
- 'PL/SQL current subprogram' is the pl/sql subprogram being executed at the point of sampling . If the value is 'SQL', it represents the percentage of time spent executing SQL for the particular plsql entry subprogram
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|
| SYS.DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT#1 | 63.64 | UNKNOWN_PLSQL_ID <9278,17> | 36.36 | | | | SQL | 27.27 | | DBSNMP.MGMT_RESPONSE.GET_METRIC_CURS | 9.09 | SQL | 9.09 |
Back to Top
Top Sessions Back to Top Top Sessions - '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
- 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
- For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics.
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|
| 143, 346 | 72.73 | db file sequential read | 45.45 | SYS | OMS | 5/300 [ 2%] | 2 | | | | CPU + Wait for CPU | 27.27 | | | 3/300 [ 1%] | 1 | | 139, 16 | 18.18 | CPU + Wait for CPU | 9.09 | DBSNMP | emagent.exe | 1/300 [ 0%] | 0 | | | | db file sequential read | 9.09 | | | 1/300 [ 0%] | 1 | | 162, 1 | 9.09 | os thread startup | 9.09 | SYS | ORACLE.EXE (CJQ0) | 1/300 [ 0%] | 0 |
Back to Top Sessions
Back to Top |
Top Blocking Sessions
No data exists for this section of the report.
Back to Top Sessions
Back to Top
Top Sessions running PQs
No data exists for this section of the report.
Back to Top Sessions
Back to Top
Top Objects/Files/Latches
Back to Top
Top DB Objects
- With respect to Application, Cluster, User I/O and buffer busy waits only.
| Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
|---|
| 9087 | 36.36 | db file sequential read | 36.36 | SYS.WRH$_OSSTAT_NAME (TABLE) | SYSAUX |
| 335 | 9.09 | db file sequential read | 9.09 | SYS.KOTTD$ (TABLE) | SYSTEM |
| 9640 | 9.09 | db file sequential read | 9.09 | DBSNMP.MGMT_SNAPSHOT (TABLE) | SYSAUX |
Back to Top Objects/Files/Latches
Back to Top
Top DB Files
- With respect to Cluster and User I/O events only.
| File ID | % Activity | Event | % Event | File Name | Tablespace |
|---|
| 3 | 45.45 | db file sequential read | 45.45 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF | SYSAUX |
| 1 | 9.09 | db file sequential read | 9.09 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF | SYSTEM |
Back to Top Objects/Files/Latches
Back to Top
Top Latches
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
Activity Over Time
- Analysis period is divided into smaller time slots
- Top 3 events are reported in each of those slots
- 'Slot Count' shows the number of ASH samples in that slot
- 'Event Count' shows the number of ASH samples waiting for that event in that slot
- '% Event' is 'Event Count' over all ASH samples in the analysis period
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
|---|
| 10:22:32 (28 secs) | 1 | os thread startup | 1 | 9.09 |
| 10:25:00 (1.0 min) | 3 | db file sequential read | 3 | 27.27 |
| 10:26:00 (1.0 min) | 7 | CPU + Wait for CPU | 4 | 36.36 |
| | | db file sequential read | 3 | 27.27 |
Back to Top
End of Report
No comments:
Post a Comment