| AWR report [message #488603] |
Mon, 10 January 2011 03:14  |
seema.taunk
Messages: 96
Registered: October 2006
|
Member |
|
|
Dear all,
In AWR report, tehre is one table (GLDM_NEW1) not present in database, still coming in buffer busy & Row lock waits section.
Also
2) it is showing object name unavaiable for different object
Will you please help.
Segments by CR Blocks Received
-> Total CR Blocks Received: 4,697,799
-> Captured Segments account for 72.4% of Total
CR
Tablespace Subobject Obj. Blocks
Owner Name Object Name Name Type Received %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
TSDATA_100 GLDM_NEW1 TABLE 152,507 3.25
** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 128,191 2.73
-------------------------------------------------------------
Thanks
[Updated on: Mon, 10 January 2011 03:18] Report message to a moderator |
|
|
|
| Re: AWR report [message #489016 is a reply to message #488603] |
Wed, 12 January 2011 22:20  |
seema.taunk
Messages: 96
Registered: October 2006
|
Member |
|
|
Dear all,
Tables is not temp table/dropped. It is not present in reccyle bin.
I have checked dba_segemnts & dba_objects but GLDM_NEW1 object don't exist anywhere.
Also in AWR report, for some object it shows unavailable & undef.
Is it bug related to AWR report?
Thanks & regards,
Seema
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
