ASH Report For ORCL/orcl
DB Name | DB Id | Instance | Inst num | Release | RAC | Host | |||
ORCL | 1173970302 | orcl | 1 | 10.2.0.1.0 | NO | edrsr4p1.us.oracle.com | |||
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
1 | 272M (100%) | 172M (63.2%) | 4,205M (######%) | 2.0M (0.7%) |
| Sample Time | Data Source |
Analysis Begin Time: | 17-Jul-09 16:08:00 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 17-Jul-09 16:13:00 | V$ACTIVE_SESSION_HISTORY |
Elapsed Time: | 5.0 (mins) |
|
Sample Count: | 9 |
|
Average Active Sessions: | 0.03 |
|
Avg. Active Session per CPU: | 0.03 |
|
Report Target: | None specified |
|
ASH Report
Top Events
Top User Events
Event | Event Class | % Activity | Avg Active Sessions |
CPU + Wait for CPU | CPU | 77.78 | 0.02 |
Top Background Events
Event | Event Class | % Activity | Avg Active Sessions |
CPU + Wait for CPU | CPU | 22.22 | 0.01 |
Top Event P1/P2/P3 Values
No data exists for this section of the report.
Load Profile
Top Service/Module
Service | Module | % Activity | Action | % Action |
SYS$USERS | emagent@edrsr4p1.us.oracle.com (TNS V1-V3) | 55.56 | UNNAMED | 55.56 |
SYS$BACKGROUND | UNNAMED | 22.22 | UNNAMED | 22.22 |
orcl.oracle.com | OEM.SystemPool | 11.11 | XMLLoader0 | 11.11 |
| sqlplus.exe | 11.11 | UNNAMED | 11.11 |
Top Client IDs
No data exists for this section of the report.
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 |
SELECT | 3 | 55.56 | 0.02 |
DELETE | 1 | 11.11 | 0.00 |
Top SQL
Top SQL Statements
SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
4055175268 | 22.22 | CPU + Wait for CPU | 22.22 | SELECT TO_CHAR(OLDEST_FLASHBAC... | |
2781794114 | 22.22 | CPU + Wait for CPU | 22.22 | SELECT (100 - sum(percent_spac... | |
895569212 | 11.11 | CPU + Wait for CPU | 11.11 | DELETE FROM MGMT_BLACKOUT_WIND... | |
547098871 | 11.11 | CPU + Wait for CPU | 11.11 | select count(*) from v$active_... |
Top SQL using literals
No data exists for this section of the report.
Complete List of SQL Text
SQL Id | SQL Text |
1jhjvx37tjff7 | DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL IS NULL) AND END_TIME IS NOT NULL AND END_TIME < (SYSDATE - (1/24)) AND STATUS IN (:B2 , :B1 ) |
2ft0vv13g0xkd | SELECT TO_CHAR(OLDEST_FLASHBACK_TIME, 'YYYY-MM-DD HH24:MI:SS') FROM V$FLASHBACK_DATABASE_LOG |
2nkzun1gy8zm8 | SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage |
bmj6d9n0wv3pm | select count(*) from v$active_session_history |
Top Sessions
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 |
113, 2040 | 55.56 | CPU + Wait for CPU | 55.56 | DBSNMP | emagent@edrsr4...m (TNS V1-V3) | 5/300 [ 2%] | 0 |
122, 4281 | 11.11 | CPU + Wait for CPU | 11.11 | SYSMAN | OMS | 1/300 [ 0%] | 1 |
142,15955 | 11.11 | CPU + Wait for CPU | 11.11 | SYS | sqlplus.exe | 1/300 [ 0%] | 0 |
154, 1 | 11.11 | CPU + Wait for CPU | 11.11 | SYS | oracle@edrsr4p...le.com (O000) | 1/300 [ 0%] | 0 |
164, 1 | 11.11 | CPU + Wait for CPU | 11.11 | SYS | oracle@edrsr4p...le.com (SMON) | 1/300 [ 0%] | 0 |
Top Blocking Sessions
No data exists for this section of the report.
Top Sessions running PQs
No data exists for this section of the report.
Top Objects/Files/Latches
Top DB Objects
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Top DB Files
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Top Latches
No data exists for this section of the report.
Back to Top Objects/Files/Latches
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 |
16:08:00 (1.0 min) | 7 | CPU + Wait for CPU | 7 | 77.78 |
16:09:00 (1.0 min) | 1 | CPU + Wait for CPU | 1 | 11.11 |
16:11:00 (1.0 min) | 1 | CPU + Wait for CPU | 1 | 11.11 |
원본 위치 <http://192.168.186.3:1158/em/console/database/instance/ashReport?target=orcl.oracle.com&type=oracle_database&event=viewReport>
댓글 없음:
댓글 쓰기