DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
HTDB | 1840233104 | htdb | 1 | 10.2.0.5.0 | NO | ECMora01 |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
32 | 52,432M (100%) | 48,560M (92.6%) | 3,376M (6.4%) | 50.0M (0.1%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 14-10ÔÂ-13 11:00:00 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 25445 |
Analysis End Time: | 14-10ÔÂ-13 11:59:59 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 25446 + V$ACTIVE_SESSION_HISTORY |
Elapsed Time: | 60.0 (mins) | |
Sample Count: | 68,969 | |
Average Active Sessions: | 191.63 | |
Avg. Active Session per CPU: | 5.99 | |
Report Target: | None specified |
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
latch: library cache | Concurrency | 55.02 | 105.45 |
cursor: pin S wait on X | Concurrency | 16.83 | 32.25 |
CPU + Wait for CPU | CPU | 14.28 | 27.37 |
SQL*Net message from dblink | Network | 7.46 | 14.29 |
latch: shared pool | Concurrency | 2.39 | 4.58 |
Back to Top Events
Back to Top
No data exists for this section of the report.
Back to Top Events
Back to Top
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
latch: library cache | 55.12 | "504403212888108880","217","0" | 0.71 | address | number | tries |
cursor: pin S wait on X | 16.83 | "32850666","3526168150016","21474862927" | 0.00 | idn | value | where|sleeps |
SQL*Net message from dblink | 7.46 | "1952673792","1","0" | 7.46 | driver id | #bytes | NOT DEFINED |
latch: shared pool | 2.42 | "504403158534983656","216","0" | 0.26 | address | number | tries |
Back to Top Events
Back to Top
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
SYS$USERS | UNNAMED | 99.04 | UNNAMED | 99.04 |
Back to Load Profile
Back to Top
No data exists for this section of the report.
Back to Load Profile
Back to Top
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 7,165 | 57.57 | 110.32 |
UPDATE | 97 | 2.57 | 4.92 |
INSERT | 66 | 1.89 | 3.62 |
Back to Load Profile
Back to Top
SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
---|---|---|---|---|---|
8tzz6w3889pu7 | 3632441102 | 8.91 | SQL*Net message from dblink | 5.65 | select count(*) from (select r... |
CPU + Wait for CPU | 2.81 |
Plan Hash | % Activity | # of Sampled SQL Versions | Example SQL 1 | Example SQL TEXT 1 | Example SQL 2 | Example SQL TEXT 2 |
---|---|---|---|---|---|---|
4116844999 | 8.33 | 5746 | 004fyvnrvjf7j | select count(distinct id) from... | gzxgg79q2gcum | select count(distinct id) from... |
1014334271 | 5.98 | 4121 | 003ssyu3zgyu0 | select * from ( select distinc... | gzx0aj3gp361s | select * from ( select distinc... |
1778274180 | 3.95 | 2721 | 009fxs1381j4g | select distinct * from ( selec... | gzxtcfnj0qb20 | select distinct * from ( selec... |
4154862089 | 2.09 | 1442 | 01g8xxxk2f09k | select count(*) from (select r... | gydzw672pcaj9 | select count(*) from (select r... |
No data exists for this section of the report.
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
Latch | % Latch | Blocking Sid | % Activity | Max Sampled Wait secs | # Waits Sampled | # Sampled Wts < 10ms | # Sampled Wts 10ms - 100ms | # Sampled Wts 100ms - 1s | # Sampled Wts > 1s |
---|---|---|---|---|---|---|---|---|---|
latch: library cache | 55.12 | Held Shared | 55.12 | 0.32 | 37,395 | 4 | 289 | 37,102 | 0 |
latch: shared pool | 2.42 | Held Shared | 2.42 | 0.59 | 1,632 | 6 | 73 | 1,553 | 0 |
Back to Top Objects/Files/Latches
Back to Top
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
11:00:00 (5.0 min) | 973 | SQL*Net message from dblink | 611 | 0.89 |
CPU + Wait for CPU | 348 | 0.50 | ||
db file sequential read | 7 | 0.01 | ||
11:05:00 (5.0 min) | 1,128 | SQL*Net message from dblink | 816 | 1.18 |
CPU + Wait for CPU | 299 | 0.43 | ||
db file sequential read | 4 | 0.01 | ||
11:10:00 (5.0 min) | 5,439 | latch: library cache | 1,961 | 2.84 |
CPU + Wait for CPU | 1,565 | 2.27 | ||
cursor: pin S wait on X | 421 | 0.61 | ||
11:15:00 (5.0 min) | 5,292 | latch: library cache | 2,254 | 3.27 |
CPU + Wait for CPU | 1,211 | 1.76 | ||
SQL*Net message from dblink | 650 | 0.94 | ||
11:20:00 (5.0 min) | 3,530 | latch: library cache | 1,273 | 1.85 |
CPU + Wait for CPU | 1,144 | 1.66 | ||
SQL*Net message from dblink | 542 | 0.79 | ||
11:25:00 (5.0 min) | 2,362 | CPU + Wait for CPU | 808 | 1.17 |
SQL*Net message from dblink | 675 | 0.98 | ||
latch: library cache | 532 | 0.77 | ||
11:30:00 (5.0 min) | 4,671 | latch: library cache | 2,500 | 3.62 |
CPU + Wait for CPU | 902 | 1.31 | ||
SQL*Net message from dblink | 522 | 0.76 | ||
11:35:00 (5.0 min) | 13,968 | latch: library cache | 9,494 | 13.77 |
cursor: pin S wait on X | 2,935 | 4.26 | ||
CPU + Wait for CPU | 916 | 1.33 | ||
11:40:00 (5.0 min) | 18,848 | latch: library cache | 12,122 | 17.58 |
cursor: pin S wait on X | 4,130 | 5.99 | ||
CPU + Wait for CPU | 1,439 | 2.09 | ||
11:45:00 (5.0 min) | 12,195 | latch: library cache | 7,874 | 11.42 |
cursor: pin S wait on X | 2,777 | 4.03 | ||
CPU + Wait for CPU | 1,043 | 1.51 | ||
11:50:00 (5.0 min) | 282 | CPU + Wait for CPU | 160 | 0.23 |
SQL*Net message from dblink | 94 | 0.14 | ||
db file sequential read | 8 | 0.01 | ||
11:55:00 (5.0 min) | 281 | CPU + Wait for CPU | 146 | 0.21 |
SQL*Net message from dblink | 119 | 0.17 | ||
db file sequential read | 8 | 0.01 |
End of Report