Client Deletion Takes longer Time

[Former Member]

Hi All

I m in process of deleting a client from my Test System. I started deleting the client with following methods

1. Brought the Database into No Archivelog mode ( I use Oracle 9.2 Database)

2. Configured parallel processing : 6

I started deleting client on Aug -1-2008

Total tables 29927

Last entry made was on Aug-03-2008

Its at 27673 .

Deleting a table called CMFP . Its a large table.

Then there is a large table GLPCA.

So its almost 5 days over in client deletion process.

Does anybody has any idea how can it be improved and make the client copy faster ?

Any input is appreciated

Thanks

-Rabindra

[Former Member]

Dear Rabindra,

We had this problem before w/ ckient deletion, SAP responded that we need to update table statistics. Client deletion is working fine now!

Regards,

Mohamed Salah

[former_member185954]

Hello,

If you search on SDN you are more likely to get quick solutions:

SAP Note Number: 857973 - Deleting clients efficiently using Oracle

Also read the related notes:

SAP Note - 541311 CC-INFO: Parallel processes FAQ

SAP Note - 489690 CC INFO: Copying large production clients

SAP Note - 365304 CC-ADMIN: Reports for deleting tables

Regards,

Siddhesh

Edited by: Siddhesh Ghag on Aug 6, 2008 5:17 PM

[Former Member]

Hi Siddhesh

Thanks for valuable input

I will try these options ..... lets see how far these options can be used

I will update if it works well

Thanks lot for the inputs

Thanks

-Rabindra

[former_member185954]

Hello Rabindra,

How big is your client ?

Regards,

Siddhesh

[Former Member]

DBSIZE : 400 GB

Client Size approx = 80GB