Home » RDBMS Server » Performance Tuning » ADDM Report (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production on LINUX 32bit server)
ADDM Report [message #576662] Thu, 07 February 2013 01:36 Go to next message
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 #576665 is a reply to message #576662] Thu, 07 February 2013 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You are not connected to the same database
2/ You are not looking at the correct report
3/ You didn't execute the correct queries against the dictionary
4/ There is a bug and open a SR to Oracle

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel
Re: ADDM Report [message #576666 is a reply to message #576662] Thu, 07 February 2013 01:51 Go to previous messageGo to next message
John Watson
Messages: 4082
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 #576668 is a reply to message #576665] Thu, 07 February 2013 01:58 Go to previous messageGo to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
May be its a synonym!!

SQL> create public synonym dept_syn for dept;

Synonym created.

SQL> select * from dept_syn;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 Myname         luk
        60 DSD            SDSD

6 rows selected.

SQL> drop table dept_syn;
drop table dept_syn
           *
ERROR at line 1:
ORA-00942: table or view does not exist

Re: ADDM Report [message #576671 is a reply to message #576668] Thu, 07 February 2013 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
May be its a synonym!!


No it can't be.
Please carefully read the post.

Regards
Michel
Re: ADDM Report [message #576672 is a reply to message #576668] Thu, 07 February 2013 02:21 Go to previous messageGo to next message
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 #576673 is a reply to message #576672] Thu, 07 February 2013 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the table no more exists then why do you care about this ADDM report?

Regards
Michel
Re: ADDM Report [message #576674 is a reply to message #576673] Thu, 07 February 2013 02:54 Go to previous messageGo to next message
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
Re: ADDM Report [message #576679 is a reply to message #576674] Thu, 07 February 2013 03:55 Go to previous message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did not run ADDM for the correct period.

Regards
Michel
Previous Topic: SQL ordered by Elapsed Time
Next Topic: Server Specification
Goto Forum:
  


Current Time: Fri Apr 18 19:04:50 CDT 2014

Total time taken to generate the page: 0.13707 seconds