For the ASH below is it in normal range for log file sync to be in 20.27% of Event under 'Top User Events'?
Also , It is coming in Top Blocking Sessions where
blocking sid (351,1) => 'Log file parallel write'
Event cause: 'log file sync'
I am not sure if this is normal or should be looked onto further. Please suggest.
ASH Report For AES/AES
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| AES |
337083168 |
AES |
1 |
11.2.0.3.0 |
NO |
Reglxorclp04a |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|
| 32 |
10,194M (100%) |
3,904M (38.3%) |
2,496M (24.5%) |
64.0M (0.6%) |
| Sample Time | Data Source |
|---|
| Analysis Begin Time: |
17-Nov-14 17:00:08 |
V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: |
17-Nov-14 17:02:08 |
V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: |
2.0 (mins) |
|
| Sample Count: |
375 |
|
| Average Active Sessions: |
3.13 |
|
| Avg. Active Session per CPU: |
0.10 |
|
| Report Target: |
None specified |
|
Top User Events
| Event | Event Class | % Event | Avg Active Sessions |
|---|
| db file sequential read |
User I/O |
27.73 |
0.87 |
| log file sync |
Commit |
20.27 |
0.63 |
| CPU + Wait for CPU |
CPU |
16.53 |
0.52 |
| db file scattered read |
User I/O |
4.53 |
0.14 |
| direct path read |
User I/O |
3.47 |
0.11 |
Back to Top Events
Top Background Events
| Event | Event Class | % Activity | Avg Active Sessions |
|---|
| db file parallel write |
System I/O |
12.27 |
0.38 |
| log file parallel write |
System I/O |
6.40 |
0.20 |
| CPU + Wait for CPU |
CPU |
1.60 |
0.05 |
Back to Top Events
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 |
28.27 |
"2","46807","1" |
0.27 |
file# |
block# |
blocks |
| log file sync |
20.27 |
"8109","3981550491","0" |
0.80 |
buffer# |
sync scn |
NOT DEFINED |
| db file parallel write |
12.27 |
"1","0","2147483647" |
7.20 |
requests |
interrupt |
timeout |
|
db file parallel write
|
12.27
|
"3","0","2147483647" |
1.60 |
requests
|
interrupt
|
timeout
|
|
db file parallel write
|
12.27
|
"2","0","2147483647" |
1.07 |
requests
|
interrupt
|
timeout
|
| log file parallel write |
6.40 |
"2","6","2" |
1.07 |
files |
blocks |
requests |
| db file scattered read |
4.53 |
"5","144109","8" |
0.27 |
file# |
block# |
blocks |
Top Call Types
| Call Type | Count | % Activity | Avg Active Sessions |
|---|
| V8 Bundled Exec |
154 |
41.07 |
1.28 |
| COMMIT |
59 |
15.73 |
0.49 |
| FETCH |
51 |
13.60 |
0.43 |
| PL/SQL RPC |
14 |
3.73 |
0.12 |
| EXECUTE |
5 |
1.33 |
0.04 |
Top Sessions
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|
| 354,31307 |
8.80 |
db file sequential read |
6.13 |
AES_USER |
wam.exe |
23/120 [ 19%] |
0 |
|
354,31307
|
8.8
|
CPU + Wait for CPU |
1.60 |
AES_USER
|
wam.exe
|
6/120 [ 5%] |
0 |
|
354,31307
|
8.8
|
log file sync |
1.07 |
AES_USER
|
wam.exe
|
4/120 [ 3%] |
0 |
| 679,50953 |
6.93 |
db file scattered read |
4.00 |
AES |
oracle@Reglxor...a (TNS V1-V3) |
15/120 [ 13%] |
0 |
|
679,50953
|
6.93
|
SQL*Net more data to client |
1.60 |
AES
|
oracle@Reglxor...a (TNS V1-V3)
|
6/120 [ 5%] |
0 |
| 351, 1 |
6.40 |
log file parallel write |
6.40 |
SYS |
oracle@Reglxorclp04a (LGWR) |
24/120 [ 20%] |
0 |
| 614,29725 |
4.27 |
db file sequential read |
2.13 |
AES_USER |
wam.exe |
8/120 [ 7%] |
0 |
|
614,29725
|
4.26
|
CPU + Wait for CPU |
1.33 |
AES_USER
|
wam.exe
|
5/120 [ 4%] |
1 |
| 643,23237 |
4.27 |
db file sequential read |
4.27 |
RD_MONITOR |
perl@Reglxutilp036 (TNS V1-V3) |
16/120 [ 13%] |
0 |
Top Blocking Sessions
| Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
|---|
| 351, 1( 1) |
20.27 |
log file sync |
20.27 |
SYS |
oracle@Reglxorclp04a (LGWR) |
16/120 [ 13%] |
0 |
End of Report