AWR reports question
- From: "CRISLER, JON A" <JC1706@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Sep 2011 22:01:49 +0000
Given the following snippit from a 11gR1 db, the line "Block changes"- does
that include redo as well ?
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 126,976M 126,976M Std Block Size: 8K
Shared Pool Size: 23,040M 23,040M Log Buffer: 138,300K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 9.1 0.4 0.01 0.00
DB CPU(s): 0.7 0.0 0.00 0.00
Redo size: 294,701.7 13,914.8
Logical reads: 43,820.4 2,069.1
* Block changes: 1,829.8 86.4
Physical reads: 46.2 2.2
Physical writes: 114.7 5.4
User calls: 2,585.1 122.1
Parses: 519.3 24.5
Hard parses: 13.8 0.7
W/A MB processed: 25,411,313.0 1,199,836.5
Logons: 1.1 0.1
Executes: 1,627.6 76.9
Rollbacks: 1.8 0.1
Transactions: 21.2
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: AWR reports question
- From: Hemant K Chitale
- Re: AWR reports question
- References:
- testing recovery
- From: Zelli, Brian
- RE: testing recovery
- From: Michael McMullen
- RE: testing recovery
- From: Zelli, Brian
- RAC 11gR1 changing control files
- From: CRISLER, JON A
- RE: RAC 11gR1 changing control files
- From: Chitale, Hemant Krishnarao
- RE: RAC 11gR1 changing control files
- From: CRISLER, JON A
- RE: RAC 11gR1 changing control files
- From: Bobak, Mark
- Re: RAC 11gR1 changing control files
- From: Radoulov, Dimitre
- testing recovery
Other related posts:
- » AWR reports question - CRISLER, JON A
- » Re: AWR reports question - Hemant K Chitale