|
ut
specifying a number lists all completed snapshots.
Listing all Completed Snapshots
Snap
Instance Snap Id Snap Started Level Comment
------------ --------- ----------------- ----- --------------------
dg2 1 23 Apr 2014 14:36 5
2 23 Apr 2014 14:46 5
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1
Enter value for end_snap: 2
End Snapshot Id specified: 2
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sb_dg2_dg2_1_2. To use this name,
press to continue, otherwise enter an alternative.
Enter value for report_name: standby_report
Using the report name standby_report
STATSPACK Statistics Report for Physical Standby
Database
~~~~~~~~
DB Unique Name Instance Startup Time Release RAC
------------------------------ ------------ --------------- ----------- ---
dg2 dg2 23-Apr-14 14:22 11.2.0.4.0 NO
Host Name: dg-two Num CPUs: 1 Phys Memory (MB): 997
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 1 23-Apr-14 14:36:59 29 .9
End Snap: 2 23-Apr-14 14:46:05 29 .9
Elapsed: 9.10 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 176M Std Block Size: 8K
Shared Pool: 100M Log Buffer: 4,368K
Load Profile Total Per Second
~~~~~~~~~~~~ ------------------ -----------------
DB time(s): 10.9 0.0
DB CPU(s): 2.6 0.0
Redo MB applied: 1.6 0.0
Logical reads: 29,038.0 53.2
Physical reads: 43.0 0.1
Physical writes: 1,587.0 2.9
User calls: 1,009.0 1.9
Parses: 1,445.0 2.7
Hard parses: 899.0 1.7
W/A MB processed: 15.1 0.0
Logons: 1.0 0.0
Executes: 9,526.0 17.5
Rollbacks: 0.0 0.0
Instance Efficiency Indicators
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %:
Buffer Hit %: 99.88 Optimal W/A Exec %: 100.00
Library Hit %: 81.20 Soft Parse %: 37.79
Execute to Parse %: 84.83 Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 44.96 % Non-Parse CPU: 36.12
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 88.16 88.60
% SQL with executions>1: 82.35 55.45
% Memory for SQL w/exec>1: 84.19 76.76
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
Standby redo I/O 543 8 15 37.6
control file parallel write 587 7 12 33.3
CPU time 3 15.8
db file async I/O submit 24 1 52 5.9
db file sequential read 31 1 23 3.3
-------------------------------------------------------------
Host CPU (CPUs: 1)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
0.55 0.47 3.05 1.62 95.20 0.80
Note: There is a 20% discrepancy between the OS Stat total CPU time and
the total CPU time estimated by Statspack
OS Stat CPU time: 436(s) (BUSY_TIME + IDLE_TIME)
Statspack CPU time: 546(s) (Elapsed time * num CPUs in end snap)
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 1.21
% of busy CPU for Instance: 25.23
%DB time waiting for CPU - Resource Mgr:
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 996.9 996.9
SGA use (MB): 298.7 298.7
PGA use (MB): 240.4 240.5
% Host Mem used for SGA+PGA: 54. |