I am listing the differences as they appear from top to bottom of an AWR report.  The differences are of 3 kinds:

  1. difference in location in the report
  2. new information
  3. information gone


In 11.2.0.3, the "Cache Sizes" lines appear first:

Cache Sizes

 

Begin

End

 

 

Buffer Cache:

304M

304M

Std Block Size:

8K

Shared Pool Size:

608M

608M

Log Buffer:

24,588K

While in 11.2.0.3, you find them further down (after "Memory Statistics).

 

"Load Profile" has 15 lines in 11.2.0.3 and 19 lines in 11.2.0.4, because there are 5 new lines in 11.2.0.4:

SQL Work Area (MB):

Read IO requests

Read IO (MB)

Write IO requests

Write IO (MB)

And W/A MB processed  disappeared in 11.2.0.4.

 

"Shared Pool Statistics" changed location: it is between "Instance Efficiency Percentages" and "Top 5 Timed Foreground Events" in 11.2.0.3, while in 11.2.0.4, it has moved to the bottom of the "Report Summary", right before the "Main Report" section.


The "Top 5 Timed Foreground Events" table of 11.2.0.3 has been replaced with 2 tables:

 

« Top 10 Foreground Events by Total Wait Time”:

Event

Waits

Total Wait Time (sec)

Wait Avg(ms)

% DB time

Wait Class

db file sequential read

178,619

281,8

2

41.8

User I/O

db file scattered read

68,622

168,4

2

25.0

User I/O

DB CPU

 

109,4

 

16.2

 

direct path read

3,885

16,1

4

2.4

User I/O

log file switch (checkpoint incomplete)

33

14,2

430

2.1

Configuration

log file switch completion

147

4,2

29

.6

Configuration

read by other session

89

1,5

17

.2

User I/O

cursor: pin S wait on X

37

1,3

35

.2

Concurrency

db file parallel read

26

,8

31

.1

User I/O

log file sync

187

,7

4

.1

Commit

 

And “Wait Classes by Total Wait Time” :

Wait Class

Waits

Total Wait Time (sec)

Avg Wait (ms)

% DB time

Avg Active Sessions

User I/O

254,484

488

2

72.4

0.1

DB CPU

 

109

 

16.2

0.0

System I/O

43,396

49

1

7.2

0.0

Configuration

184

19

102

2.8

0.0

Concurrency

361

2

6

.3

0.0

Commit

189

1

4

.1

0.0

Application

25

0

14

.1

0.0

Network

27,064

0

0

.1

0.0

Other

344

0

1

.0

0.0

Scheduler

1

0

3

.0

0.0

 

After the “Host CPU” and “Instance CPU” sections, which are identical in both versions, we have in 11.2.0.4  a new section, called "IO Profile":

IO Profile

 

Read+Write Per Second

Read per Second

Write Per Second

Total Requests:

156.3

86.2

70.1

Database Requests:

142.7

76.3

66.4

Optimized Requests:

0.0

0.0

0.0

Redo Requests:

1.5

0.0

1.5

Total (MB):

3.3

2.11.2

Database (MB):

2.6

1.90.7

Optimized Total (MB):

0.0

0.00.0

Redo (MB):

0.5

0.00.5

Database (blocks):

334.2

245.2

89.0

Via Buffer Cache (blocks):

290.1

201.5

88.6

Direct (blocks):

44.1

43.7

0.4

 

For the "Time Model Statistics" table, its number of lines varies, but I cannot determine if it varies because of the change from 11.2.0.3 to 11.2.0.4 or because of the activity recorded by each AWR report.

 

The whole SQL section seems to me identical from one version to the other.

 

Then the " Instance Activity Statistics" has been revamped.  In 11.2.0.3, we have:

While in 11.2.0.4 we have:

This new "Key Instance Activity Stats" section of 11.2.0.4 is a selection of statistics that are key according to Oracle:

Statistic

Total

per Second

per Trans

db block changes

11,620,235

3,225.92

12,882.74

execute count

42,189

11.71

46.77

logons cumulative

100

0.03

0.11

opened cursors cumulative

28,169

7.82

31.23

parse count (total)

14,413

4.00

15.98

parse time elapsed

2,316

0.64

2.57

physical reads

883,276

245.21

979.24

physical writes

320,511

88.98

355.33

redo size

1,847,700,304

512,943.60

2,048,448.23

session cursor cache hits

23,893

6.63

26.49

session logical reads

24,834,290

6,894.29

27,532.47

user calls

28,797

7.99

31.93

user commits

902

0.25

1.00

user rollbacks

0

0.00

0.00

Workarea executions - onepass

0

0.00

0.00

Workarea executions - optimal

8,125

2.26

9.01

 

 

The "Tablespace IO Stats"  table in 11.2.0.4 has 2 extra columns:

 

Tablespace

Reads

Av Rds/s

Av Rd(ms)

Av Blks/Rd

1-bk Rds/s

Av 1-bk Rd(ms)

Writes

Writes avg/s

Buffer Waits

Av Buf Wt(ms)

IxxxxT

137,197

38

1.91

4.43

54,507

19.31

1

15

25

27.20

DxxxxT

89,046

25

1.25

1

62,224

24.72

1

17

40

6.25

 

The "FileIO Stats"  table in 11.2.0.4 has 2 extra columns: "1-bk Rds/s" and "Av 1-bk Rd(ms)":

Tablespace

Filename

Reads

Av Rds/s

Av Rd(ms)

Av Blks/Rd

1-bk Rds/s

Av 1-bk Rd(ms)

Writes

Writes avg/s

Buffer Waits

Av Buf Wt(ms)

DxxxxR

/dxxxx1.dbf

181

0

2.65

1.34

0

2.47

14

0

0

0.00

DxxxxX

/dxxxx1.dbf

29

0

0.34

1.00

0

0.34

14

0

0

0.00

 

And that is all I could spot.  Do not hesitate to point out if something is missing or wrong.