ADDM Report [message #576662] |
Thu, 07 February 2013 01:36 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Hi All,
Getting some issue while trying to identify the root cause of performace issue.
As per ADDM report .. we are required to do segment tunning ... please find the log for the same.
FYI
Recommendation 1: Segment Tuning
Estimated benefit is .41 active sessions, 6.89% of total activity.
------------------------------------------------------------------
Action
Run "Segment Advisor" on TABLE "DWHODS.APPFORM_DET_TEST" with object ID
177981.
Related Object
Database object with ID 177981.
Action
Investigate application logic involving I/O on TABLE
"DWHODS.APPFORM_DET_TEST" with object ID 177981.
Related Object
Database object with ID 177981.
Rationale
The I/O usage statistics for the object are: 88 full object scans,
6193741 physical reads, 5807 physical writes and 5990258 direct reads.
When looking into the object .. It doesnt exist into the database & when trying to identify through object ID .. it is point to some other table name(APPFORM_DET)... so just wanted to know where is the gap & how to resolve it .
Thanks
Vimlendu
|
|
|
|
Re: ADDM Report [message #576666 is a reply to message #576662] |
Thu, 07 February 2013 01:51 |
John Watson
Messages: 8963 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If you cannot find the object by name, then (as MC suggests) you must be making a mistake. As for object ID, could you be confusing the object_id with the data_object_id? They do not have to be the same:orcl> select object_id,data_object_id from user_objects where object_name='EMP';
OBJECT_ID DATA_OBJECT_ID
---------- --------------
81149 81149
orcl> alter table emp move;
Table altered.
orcl> select object_id,data_object_id from user_objects where object_name='EMP';
OBJECT_ID DATA_OBJECT_ID
---------- --------------
81149 81775
orcl>
--
John Watson
http://skillbuilders.com
|
|
|
|
|
Re: ADDM Report [message #576672 is a reply to message #576668] |
Thu, 07 February 2013 02:21 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
NO SYNONYM where exist for "APPFORM_DET_TEST" table in Database.
Apart fromk that just wanted to inform you ... that table was exist some time back & 5 days back, we dropped it using purge.
Not sure why it is showing in todays ADDM report.
Please let me know how to procced
Thanks
|
|
|
|
Re: ADDM Report [message #576674 is a reply to message #576673] |
Thu, 07 February 2013 02:54 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Today we are getting some performace issue at database level .. so i have generated the ADDM report to identify the issue/cauase.
Below is the short information from ADDM report..
Recommendation 1: Segment Tuning
Estimated benefit is .41 active sessions, 6.89% of total activity.
------------------------------------------------------------------
Action
Run "Segment Advisor" on TABLE "DWHODS.APPFORM_DET_TEST" with object ID
177981.
Related Object
Database object with ID 177981.
Action
Investigate application logic involving I/O on TABLE
"DWHODS.APPFORM_DET_TEST" with object ID 177981.
Related Object
Database object with ID 177981.
Rationale
The I/O usage statistics for the object are: 88 full object scans,
6193741 physical reads, 5807 physical writes and 5990258 direct reads.
Here the object name in the ADDM report is give is "APPFORM_DET_TEST" & the object ID which is there in ADDM report(177981) is belows to APPFORM_DET table.
SO trying to know where is the gap.... as we dropped "APPFORM_DET_TEST" table a long back so why it showing in current ADDM report with same object ID for APPFORM_DET.
Regards
|
|
|
|