Oracle AWR Report Detailed

Transferred from: http://blog.csdn.net/laoshangxyc/article/details/8615187

Continuous update ...

Oracle AWR Report Detailed

Time

DB Name	DB Id	Instance	Inst Num	Startup	Release	RAC
ORCL	1295334343	Orcl	1	September-January-12 18:01	11.2.0.1.0	NO

DB Name: Database name

DB ID: Database ID (Get method select dbid from V$database;)

Instance: Instance Name

Inst Num: Number of instances, here is a single instance

Startup time: Instance start times

Release:oracle database version

RAC: Whether it is a RAC

Host Name	Platform	CPUs	cores	Sockets	Memory (GB)
Xiangyc	Microsoft Windows IA (32-bit)	4	2	1	1.87

Host Name: hostname

Platform: The database is located on the platform, that is, the host system (can be isolated from the v$database).

CPUs: The number of logical CPUs can be viewed from the Oracle database initialization parameters Cpu_count (show parameter Cpu_count).

CORES:CPU number of cores.

SOCKETS:CPU slots (CPU sockets are mainly divided into sockets, slots, these two.) Is the socket used to install the CPU. ）

Memory (GB): Host RAM

time

	snap Id	snap	Sessions	cursors/session
Begin Snap:	679	October-January-12 00:00:56	25	1.1
End Snap:	681	October-January-12 01:04:09	25	1.7
Elapsed:		63.21 (mins)
DB Time:		2.17 (mins)

Snap Id:awr report snapshot Id

Snap Time:awr report snapshot time

Sessions: Number of sessions

Cursors/session: The average number of cursors opened per session (the maximum value for each session open cursor is determined by the parameter open_cursors)

--------------------------------------------------------------------------------------------------------------- -------------------------

Begin snap: Snapshot start

End snap: End of snapshot

Elapsed: Experience time (time from begin Snap to end snap)

DB time: Database times: The database consumes CPU time, including non-idle waits (waiting in CPU usage), DB-The sum of time spent by all logical CPUs,

For example, there are two CPUs, where each CPU time is DB TIME/2, if db time is much less than elapsed, the database is more idle.

Cache Sizes

End

	Begin
Buffer Cache:	264M	264M	STD Block Size:	8K
Shared Pool Size:	212M	212M	Log Buffer:	5,668k

Buffer cache: Cache Size

Shared pool Size: Shared pools sizes

STD Block Size: The data block sizes specified in the initialization parameters (parameter Db_block_size decision)

Log Buffer:redo journal buffer size (parameter Log_buffer determined)

Load profile

Call

		Per Second	Per Transaction	Per Exec	Per
DB time (s):		0.0	0.3	0.01	0.07
DB CPU (s):		0.0	0.0	0.00	0.01
Redo Size:		1,180.3	11,247.1
Logical reads:		35.9	342.4
Block changes:		5.0	47.9
Physical reads:		0.4	3.5
Physical writes:		0.4	3.4
User Calls:		0.5	4.9
Parses:		2.8	27.1
Hard parses:		0.1	0.7
w/a MB processed:		0.1	0.6
Logons:		0.1	1.0
Executes:		4.3	41.2
Rollbacks:		0.0	0.0
Transactions:		0.1

Per Second: Per second

Per Transaction: per transaction

Per Exec: Every execution

Per call: each invocation

---------------------------------------------------

DB Time (s): Database times (in seconds) (per second, per transaction, per execution, per call)

DB CPU (s): CPU time (CPU compute time, removing wait for CPU)

Redo Size:redo Volume (unit byte)

Logical reads: Logical reading (unit block)

Block changes: Amount of data block change

Physical reads: Physical reading (unit block)

Physical writes: Physical Write (unit block)

User calls: Recursive invocation of users (sometimes executing SQL statements may also require additional statements to be executed, called recursive calls, such as when inserting data, where there is not enough space, and the statement that allocates space is called)

Parses: Number of resolutions

Hard parses: Rigid parsing

Amount of data processed in w/a MB Processed:workarea

Logons: Indicates how many users are logged into the database

Executes: number of executions

Rollbacks: Rollback number

Transactions: Number of transactions

Instance efficiency percentages (Target 100%)

Buffer Nowait%:	100.00	Redo NoWait%:	100.00
Buffer Hit%:	99.00	In-memory Sort%:	100.00
Library Hit%:	97.46	Soft Parse%:	97.44
Execute to Parse%:	34.38	Latch Hit%:	99.96
Parse CPU to parse elapsd%:	5.15	% Non-parse CPU:	84.45

Oracle AWR Report Detailed