Skip to Content
avatar image
Former Member

Client deletion takes longer time

Hi Gurus,

Our system is 4.6C/ Oracle 8.1.7

I would like to know is there any other way to speed up the client delete process. Last time , I deleted a client of size 51GB and it took 5.5days to complete.

I came accross a SAP note mentioning that deletion time will be reduced if it is done via R3trans command at OS level (R3trans ?w <log file name> -u 1 <command file name >)

I also came to know from note 365304 that deletion will run slow if FULL TABLE SCAN is turned ON in oracle. They recommend to change the Optimizer value to RULE in init.ora

Does anybody ever tried any of the above scenarios? Pls share your experience.

regards,

Vinodh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 04, 2007 at 09:15 AM

    you can give more than one process while scheduling the client deletion. this can help you to reduce the client deletion time.

    cheers,

    -Sunil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2007 at 09:55 AM

    Hello Vinodh,

    Once we had a very bad time deleting the client through OS level (using R3trans).

    Since then we promised ourselfs never to try the R3trans stuff again 😊

    DO NOT forget to choose enough parallel processess for client deletion

    Regards,

    Ammey Kesarkar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vinodh

      I have not selected the "Parameter for parallel processing" while deleting the client, i had schedule in knight.

      RFC required for the logon server group, which is assigned to a number of instances. When users log on, they connect to these groups and are automatically logged on to the instance with the best response time.

      Server groups were used internally in background jobs to distribute the load.

      You can define how many users may work on a particular instance

      Regards

      Anwer Waseem

  • Apr 04, 2007 at 01:41 PM

    Hi Vinodh,

    Refer to SAP Note 70643, Problem 4

    Some steps r recommended under this thread

    URGENT:can I start remote client copy as very very slow client delete

    This would also be helpful

    SAP Note 377633

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2007 at 09:07 AM

    This thread is answered reasonably.

    Add comment
    10|10000 characters needed characters exceeded