Skip to Content
author's profile photo Former Member
Former Member

SCOT runs for a longer time

Environment

===========

SAP Enterprise Extn Set 1.10

Redhat Linux 4.0

Oracle 9.2.x

Transcation SCOT (SAPConnect Administration)runs for a longer period of time and times-out after an hour of runtime.

Has anyone seen this symptom before ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 31, 2006 at 09:40 AM

    Hello,

    this case is often seen with Oracle DB. Please update statistics on the following DB Tables:

    SOFM , SOOS , SOES, SOST, SOOD.

    Best regards,

    Dezso Pap

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2006 at 12:49 PM

    DEZSO,

    I have checked the status of statistics of these tables through DB20 and noticed that statistics are current. (I get green indicator in the status column for all tables you mentioned.) . Do you think that statistics for these tables have to be updated even status is green ?

    Thanks

    Rajan S

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      I would do a "compute statistics" for all of the tables.

      If the problem is not solved with that, I would create an SQL Trace (ST01) about the problem.

      Turn on the trace in modus 1 , start Tr. SCOT in modus 2 what was opened befor the trace was turned on, stop the trace in ST01 and check the result. Use explain SQL for the red lines. >> Here you should see which table causes the delay. Please also consider to reorganise these tables.

      You can find an overwiev in SAP note: #728063.

      Regards,

      Dezso

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 10:45 AM

    DEZSO,

    I have tried the COMPUTE STATISTICS and it did not help.

    Then, I have attempted to run REPORT RSSORE00 as described in Notes 728063 to perform SAPoffice Re-org and noticed that it runs for a longer time. I have started this three hours before and it is not completed yet. Is this something Ok ? Does it run usually for a longer time ? Please send me your comments.

    Thanks

    Rajan S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:09 AM

    DESZO,

    Please find below the details

    950,479 - SOFM

    1,512,246 -SOST

    621,136 - SOES

    I see that BCST_SR table is being shown in SM50.

    Thanks for your help

    Rajan S

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.