|
AWR生成report時,沒有數據。請各高手幫忙分析分析!謝謝
附:report代碼
WARNING: Since the DB Time is less than one second, there was
minimal foreground activity in the snapshot period.
Some of the percentage values will be invalid.
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC
------------ ----------- ------------ -------- --------------- ----------- ---
YTCOPDB 3212533285 ytcopdb 1 26-2月 -11 12:18 11.2.0.1.0 NO
Host Name Platform CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
ytcopdb01 Linux x86 64-bit .00
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 10227 09-5月 -11 11:00:49
End Snap: 10229 09-5月 -11 13:00:16
Elapsed: 119.45 (mins)
DB Time: 0.00 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache:MM Std Block Size:K
Shared Pool Size: 0M 0M Log Buffer:K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 0.0 0.0 0.00 0.00
DB CPU(s): 0.0 0.0 0.00 0.00
Redo size:
Logical reads: 0.0 1.0
Block changes: 0.0 1.0
Physical reads: 0.0 1.0
Physical writes: 0.0 1.0
User calls: 0.0 1.0
Parses: 0.0 1.0
Hard parses:
W/A MB processed: 0.0 0.0
Logons:
Executes: 0.0 1.0
Rollbacks:
Transactions: 0.0
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: Redo NoWait %:
Buffer Hit %: In-memory Sort %:
Library Hit %: Soft Parse %:
Execute to Parse %: 0.00 Latch Hit %:
Parse CPU to Parse Elapsd %: % Non-Parse CPU:
Shared Pool Statisitics Not Available
Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU 0 100.0
Host CPU (CPUs: Cores: Sockets: )
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance:
% of busy CPU for Instance:
%DB time waiting for CPU - Resource Mgr:
Memory Statistics
~~~~~~~~~~~~~~~~~ Begin End
Host Mem (MB):
SGA use (MB):
PGA use (MB):
% Host Mem used for SGA+PGA:
Time Model Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Operating System Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Operating System Statistics - DetailDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-102
No data exists for this section of the report.
-------------------------------------------------------------
Foreground Wait Class DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> s - second, ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Captured Time accounts for % of Total DB time .00 (s)
-> Total FG Wait Time: (s) DB CPU time: .00 (s)
Avg
%Time Total Wait wait
Wait Class Waits -outs Time (s) (ms) %DB time
-------------------- ---------------- ----- ---------------- -------- ---------
DB CPU 0 100.0
-------------------------------------------------------------
Foreground Wait Events DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Background Wait Events DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Wait Event Histogram DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: YTCOPDB/ytcopdb Snaps
No data exists for this section of the report.
-------------------------------------------------------------
Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: YTCOPDB/ytcopdb Snaps:
No data exists for this section of the report.
-------------------------------------------------------------
Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: YTCOPDB/ytcopdb Snaps: 1
No data exists for this section of the report.
-------------------------------------------------------------
Service Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by User I/O Wait TimeDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Physical Reads (UnOptimized)DB/Inst: YTCOPDB/ytcopdb Snaps: 1
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Instance Activity Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: YTCOPDB/ytcopdb Snaps: 102
No data exists for this section of the report.
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: YTCOPDB/ytcopdb Snaps: 1022
No data exists for this section of the report.
-------------------------------------------------------------
IOStat by Function summary DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
IOStat by Filetype summary DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
IOStat by Function/Filetype summaryDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-1022
No data exists for this section of the report.
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
File IO Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Checkpoint Activity DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
MTTR Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
SGA Target Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Enqueue Activity DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Undo Segment Summary DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Undo Segment Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Latch Activity DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Latch Miss Sources DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Mutex Sleep Summary DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Logical Reads: 1
-> Captured Segments account for 1.5E+10% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SMALL_AP R_KANBAN_TOTAL_T TABLE 40,956,640 4.1E+09
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 25,913,520 2.6E+09
SFISM4 D_SMALL_AP R_KANBAN_PERIOD_T TABLE 14,863,168 1.5E+09
SFISM4 D_SFISM4_D PSEC_UJ8A0_ERROR_COU TABLE 12,145,504 1.2E+09
SFISM4 D_SFISM4_D R_KANBAN_REASON_T TABLE 11,175,504 1.1E+09
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Physical Reads: 1
-> Captured Segments account for 1.9E+09% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 17,832,719 1.8E+09
SFISM4 D_SFISM4_D R_REPAIR_T TABLE 733,127 7.3E+07
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 26,325 2.6E+06
SFISM4 D_UJ8A0_DA R_UJ8A0_ATDMS_DATA_T 2011040506 TABLE 4,610 4.6E+05
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 4,542 4.5E+05
-------------------------------------------------------------
Segments by Physical Read RequestsDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Physical Read Requests: 1
-> Captured Segments account for 3.6E+07% of Total
Tablespace Subobject Obj. Phys Read
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 295,913 3.0E+07
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 26,325 2.6E+06
SFISM4 D_SFISM4_D R_REPAIR_T TABLE 12,077 1.2E+06
SFISM4 D_UJ8A0_DA R_UJ8A0_ATDMS_DATA_T 2011040506 TABLE 4,610 4.6E+05
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 4,542 4.5E+05
-------------------------------------------------------------
Segments by UnOptimized Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total UnOptimized Read Requests: 1
-> Captured Segments account for 3.6E+07% of Total
Tablespace Subobject Obj. UnOptimized
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 295,913 3.0E+07
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 26,325 2.6E+06
SFISM4 D_SFISM4_D R_REPAIR_T TABLE 12,077 1.2E+06
SFISM4 D_UJ8A0_DA R_UJ8A0_ATDMS_DATA_T 2011040506 TABLE 4,610 4.6E+05
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 4,542 4.5E+05
-------------------------------------------------------------
Segments by Optimized Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Direct Physical Reads DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Direct Physical Reads: 1
-> Captured Segments account for 1.9E+09% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 17,797,178 1.8E+09
SFISM4 D_SFISM4_D R_REPAIR_T TABLE 732,642 7.3E+07
-------------------------------------------------------------
Segments by Physical Writes DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Physical Writes: 1
-> Captured Segments account for 6.5E+06% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SHIPPI INDEX 10,644 1.1E+06
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 9,718 9.7E+05
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 9,012 9.0E+05
SFISM4 IDX_8A0_MA IDX_8A0_MACHINESN INDEX 6,602 6.6E+05
SFISM4 IDX_WIP_CA IDX_WIP_CARTON_MODEL INDEX 5,233 5.2E+05
-------------------------------------------------------------
Segments by Physical Write RequestsDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-1022
-> Total Physical Write Requestss: 1
-> Captured Segments account for 5.0E+06% of Total
Tablespace Subobject Obj. Phys Write
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SHIPPI INDEX 8,636 8.6E+05
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 7,840 7.8E+05
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 7,160 7.2E+05
SFISM4 IDX_8A0_MA IDX_8A0_MACHINESN INDEX 4,826 4.8E+05
SFISM4 IDX_WIP_CA IDX_WIP_CARTON_MODEL INDEX 4,760 4.8E+05
-------------------------------------------------------------
Segments by Direct Physical WritesDB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Table Scans DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> Total Table Scans: 1
-> Captured Segments account for 3.7E+05% of Total
Tablespace Subobject Obj. Table
Owner Name Object Name Name Type Scans %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 3,673 3.7E+05
SFISM4 D_SFISM4_D R_REPAIR_T TABLE 69 6.9E+03
-------------------------------------------------------------
Segments by DB Blocks Changes DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> % of Capture shows % of DB Block Changes for each top segment compared
-> with total DB Block Changes for all segments captured by the Snapshot
Tablespace Subobject Obj. DB Block % of
Owner Name Object Name Name Type Changes Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 16,016 11.86
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SHIPPI INDEX 14,528 10.76
SFISM4 D_SFISM4_D R_KANBAN_REASON_T TABLE 12,112 8.97
SFISM4 D_SN_DETAI R_SN_DETAIL_T 2011040506 TABLE 11,808 8.75
SFISM4 IDX_DETAIL IDX_DETAIL_INSTATION INDEX 11,152 8.26
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 D_UJ8A0_SN IDX_8A0_SN INDEX 26 23.21
SFISM4 IDX_WIP_CA IDX_WIP_CARTON_MODEL INDEX 20 17.86
SFISM4 IDX_WIP_SH IDX_WIP_SHIPSN INDEX 15 13.39
SFISM4 IDX_KEY_PA IDX_KEY_PART_NO INDEX 9 8.04
SFISM4 IDX_DETAIL IDX_SN_DETAIL_SN INDEX 7 6.25
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> % of Capture shows % of ITL waits for each top segment compared
-> with total ITL waits for all segments captured by the Snapshot
Tablespace Subobject Obj. ITL % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SFISM4 IDX_SMTTES IDX_SMTTEST_TESTDATE INDEX 1 100.00
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SFIS1 D_SFIS1_DA C_KANBAN_CONFIG TABLE 7 29.17
SFISM4 D_SMALL_AP R_KANBAN_TOTAL_T TABLE 7 29.17
SFISM4 IDX_DETAIL IDX_DETAIL_INSTATION INDEX 3 12.50
SFISM4 D_SFISM4_D R_LINE_REPAIR_T TABLE 2 8.33
SYS SYSTEM AUD$ TABLE 1 4.17
-------------------------------------------------------------
...................
Resource Limit Stats DB/Inst: YTCOPDB/ytcopdb Snap: 10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Activity DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Rates DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Utilization DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Common Queue DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Dispatchers DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
Dynamic Remastering Stats DB/Inst: YTCOPDB/ytcopdb Snaps: 10227-10229
No data exists for this section of the report.
-------------------------------------------------------------
End of Report |
|