Oracle Database Discussions

Hi, friends ..


I am using Oracle 11g standars edition(11.2.0.1.0) on solaris 10 platform.I do have a very strange probleem..when iam trying to capture awr report i am getting a blank
awr report contain ing nothing...like below section

---------------------------------------------------------------------------->

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
DISDB 771054785 disdb 1 30-Dec-10 10:12 11.2.0.1.0 NO



Host Name Platform CPUs Cores Sockets Memory (GB)
dissemination-new Solaris Operating System (x86-64) .00


Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1 30-Dec-10 11:30:21
End Snap: 2 30-Dec-10 12:30:52
Elapsed: 60.51 (mins)
DB Time: 0.00 (mins)



Report Summary
Cache Sizes

Begin End
Buffer Cache: M M 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


Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU 0 100.00

Host CPU (CPUs: Cores: Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

Memory Statistics

Begin End
Host Mem (MB):
SGA use (MB):
PGA use (MB):
% Host Mem used for SGA+PGA:


Main Report
Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Back to Top

Wait Events Statistics
Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats
Back to Top

Time Model Statistics
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Operating System Statistics
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Operating System Statistics - Detail
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Foreground Wait Class
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)
Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time
DB CPU 0 100.00

Back to Wait Events Statistics
Back to Top


Foreground Wait Events
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Background Wait Events
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Wait Event Histogram
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Wait Event Histogram Detail (64 msec to 2 sec)
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Wait Event Histogram Detail (4 sec to 2 min)
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Wait Event Histogram Detail (4 min to 1 hr)
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Service Statistics
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top


Service Wait Class Stats
No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top



SQL Statistics
SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text
Back to Top

SQL ordered by Elapsed Time
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by CPU Time
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by User I/O Wait Time
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Gets
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Reads
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Physical Reads (UnOptimized)
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Executions
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Parse Calls
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Sharable Memory
No data exists for this section of the report.

Back to SQL Statistics
Back to Top


SQL ordered by Version Count
No data exists for this section of the report.

Back to SQL Statistics
Back to Top



Complete List of SQL Text

No data exists for this section of the report.

Back to SQL Statistics
Back to Top



Instance Activity Statistics
Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity
Back to Top

Instance Activity Stats
No data exists for this section of the report.

Back to Instance Activity Statistics
Back to Top


Instance Activity Stats - Absolute Values
No data exists for this section of the report.

Back to Instance Activity Statistics
Back to Top


Instance Activity Stats - Thread Activity
No data exists for this section of the report.

Back to Instance Activity Statistics
Back to Top



IO Stats
IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats
Back to Top

IOStat by Function summary
No data exists for this section of the report.

Back to IO Stats
Back to Top


IOStat by Filetype summary
No data exists for this section of the report.

Back to IO Stats
Back to Top


IOStat by Function/Filetype summary
No data exists for this section of the report.

Back to IO Stats
Back to Top


Tablespace IO Stats
No data exists for this section of the report.

Back to IO Stats
Back to Top


File IO Stats
No data exists for this section of the report.

Back to IO Stats
Back to Top



Buffer Pool Statistics
Buffer Pool Statistics
Checkpoint Activity
Back to Top

Buffer Pool Statistics
No data exists for this section of the report.

Back to Buffer Pool Statistics
Back to Top


Checkpoint Activity
No data exists for this section of the report.

Back to Buffer Pool Statistics
Back to Top



Advisory Statistics
Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory
Back to Top

Instance Recovery Stats
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


MTTR Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


Buffer Pool Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


PGA Aggr Summary
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


PGA Aggr Target Stats
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


PGA Aggr Target Histogram
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


PGA Memory Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


Shared Pool Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


SGA Target Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


Streams Pool Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top


Java Pool Advisory
No data exists for this section of the report.

Back to Advisory Statistics
Back to Top



Wait Statistics
Buffer Wait Statistics
Enqueue Activity
Back to Top

Buffer Wait Statistics
No data exists for this section of the report.

Back to Wait Statistics
Back to Top


Enqueue Activity
No data exists for this section of the report.

Back to Wait Statistics
Back to Top



Undo Statistics
Undo Segment Summary
Undo Segment Stats
Back to Top

Undo Segment Summary
No data exists for this section of the report.

Back to Undo Statistics
Back to Top


Undo Segment Stats
No data exists for this section of the report.

Back to Undo Statistics
Back to Top



Latch Statistics
Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics
Back to Top

Latch Activity
No data exists for this section of the report.

Back to Latch Statistics
Back to Top


Latch Sleep Breakdown
No data exists for this section of the report.

Back to Latch Statistics
Back to Top


Latch Miss Sources
No data exists for this section of the report.

Back to Latch Statistics
Back to Top


Mutex Sleep Summary
No data exists for this section of the report.

Back to Latch Statistics
Back to Top


Parent Latch Statistics
No data exists for this section of the report.

Back to Latch Statistics
Back to Top


Child Latch Statistics
No data exists for this section of the report.

Back to Latch Statistics
Back to Top



Segment Statistics
Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Back to Top

Segments by Logical Reads
Total Logical Reads: 1
Captured Segments account for 4.6E+06% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
SYS SYSTEM I_SYSAUTH1 INDEX 15,008 1500800.00
SYS SYSTEM I_OBJ2 INDEX 4,752 475200.00
SYS SYSTEM TAB$ TABLE 2,176 217600.00
SYS SYSTEM I_JOB_NEXT INDEX 1,856 185600.00
SYS SYSTEM SYS_C00646 INDEX 1,664 166400.00

Back to Segment Statistics
Back to Top


Segments by Physical Reads
Total Physical Reads: 1
Captured Segments account for 400.0% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
SYS SYSAUX WRH$_SYSMETRIC_SUMMARY_INDEX INDEX 3 300.00
SYS SYSTEM KOTAD$ TABLE 1 100.00

Back to Segment Statistics
Back to Top


Segments by Physical Read Requests
Total Physical Read Requests: 1
Captured Segments account for 400.0% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Read Requests %Total
SYS SYSAUX WRH$_SYSMETRIC_SUMMARY_INDEX INDEX 3 300.00
SYS SYSTEM KOTAD$ TABLE 1 100.00

Back to Segment Statistics
Back to Top


Segments by UnOptimized Reads
Total UnOptimized Read Requests: 1
Captured Segments account for 400.0% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total
SYS SYSAUX WRH$_SYSMETRIC_SUMMARY_INDEX INDEX 3 300.00
SYS SYSTEM KOTAD$ TABLE 1 100.00

Back to Segment Statistics
Back to Top


Segments by Optimized Reads
No data exists for this section of the report.

Back to Segment Statistics
Back to Top


Segments by Direct Physical Reads
No data exists for this section of the report.

Back to Segment Statistics
Back to Top


Segments by Physical Writes
Total Physical Writes: 1
Captured Segments account for 1.1E+04% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 27 2700.00
SYS SYSAUX WRH$_SYSMETRIC_HISTORY TABLE 16 1600.00
SYS SYSAUX WRH$_SYSMETRIC_HISTORY_INDEX INDEX 16 1600.00
SYSMAN SYSAUX MGMT_SYSTEM_PERF_LOG_IDX_01 INDEX 9 900.00
SYS SYSAUX SMON_SCN_TIME TABLE 9 900.00

Back to Segment Statistics
Back to Top


Segments by Physical Write Requests
Total Physical Write Requestss: 1
Captured Segments account for 5.1E+03% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Write Requests %Total
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 11 1100.00
SYS SYSAUX SMON_SCN_TIME TABLE 9 900.00
SYSMAN SYSAUX MGMT_SYSTEM_PERF_LOG_IDX_01 INDEX 6 600.00
SYSMAN SYSAUX MGMT_CURRENT_METRICS_PK INDEX 4 400.00
SYS SYSTEM I_JOB_NEXT INDEX 2 200.00

Back to Segment Statistics
Back to Top


Segments by Direct Physical Writes
No data exists for this section of the report.

Back to Segment Statistics
Back to Top


Segments by Table Scans
Total Table Scans: 1
Captured Segments account for 900.0% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total
SYS SYSTEM I_OBJ2 INDEX 9 900.00

Back to Segment Statistics
Back to Top


Segments by DB Blocks Changes
% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot
Owner Tablespace Name Object Name Subobject Name Obj. Type DB Block Changes % of Capture
SYS SYSTEM I_JOB_NEXT INDEX 896 58.95
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 160 10.53
SYSMAN SYSAUX MGMT_CURRENT_METRICS_PK INDEX 112 7.37
SYS SYSAUX SMON_SCN_TIME TABLE 80 5.26
SYSMAN SYSAUX MGMT_SYSTEM_PERF_LOG_IDX_01 INDEX 64 4.21

Back to Segment Statistics
Back to Top


Segments by Row Lock Waits
No data exists for this section of the report.

Back to Segment Statistics
Back to Top


Segments by ITL Waits
No data exists for this section of the report.

Back to Segment Statistics
Back to Top


Segments by Buffer Busy Waits
No data exists for this section of the report.

Back to Segment Statistics
Back to Top



Dictionary Cache Stats
No data exists for this section of the report.


Back to Top



Library Cache Activity
No data exists for this section of the report.


Back to Top



Memory Statistics
Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference
Back to Top

Memory Dynamic Components
No data exists for this section of the report.

Back to Memory Statistics
Back to Top


Memory Resize Operations Summary
No data exists for this section of the report.

Back to Memory Statistics
Back to Top


Memory Resize Ops
No data exists for this section of the report.

Back to Memory Statistics
Back to Top


Process Memory Summary
No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Back to Memory Statistics
Back to Top


SGA breakdown difference
No data exists for this section of the report.

Back to Memory Statistics
Back to Top



Streams Statistics
Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers
Back to Top

Streams CPU/IO Usage
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Streams Capture
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Streams Capture Rate
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Streams Apply
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Streams Apply Rate
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Buffered Queues
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Buffered Queue Subscribers
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Rule Set
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Persistent Queues
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Persistent Queues Rate
No data exists for this section of the report.

Back to Streams Statistics
Back to Top


Persistent Queue Subscribers
No data exists for this section of the report.

Back to Streams Statistics
Back to Top



Resource Limit Stats
No data exists for this section of the report.


Back to Top



Shared Server Statistics
Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers
Back to Top

Shared Servers Activity
No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top


Shared Servers Rates
No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top


Shared Servers Utilization
No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top


Shared Servers Common Queue
No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top


Shared Servers Dispatchers
No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top



init.ora Parameters
No data exists for this section of the report.


Back to Top








Dynamic Remastering Stats
No data exists for this section of the report.


Back to Top


End of Report
---------------------------------------------->>



here intresting is that i also can't have the memory section view also.i trien to clear awr repositary and recreate it..bounce database,also tried taking different snap value.But does notmake any change.can u tell me why tha happening..and how can i get a good awr report.