[OAUGNet]-Re: FW: Multi-org conversion process

[Darrieus Bertrand <DarrieusB@mail.europcar.com>]

Hi Mark,
I did it last year over 8 different instances in R11.0.3
It was after a drastic purge campaign of AR,AP and GL, except for one
instance.
A small instance, say 25 Gb, took about 1h15 on the large boxes I was
running at that time.
A medium instance, around 40Gb, took 3h00 to 3h15, and the largest instance,
200 Gb, took 40h00 (fourty hours).
We were usually running 5 parallel workers. The cumulated runtime over the 5
workers for the largest instance was 83hours. This unpurged instance had
over 36,000,000 rows in RA_CUST_TRX_LINE_GL_DIST_ALL table and 7,000,000
rows in AP_INVOICE_DISTRIBUTIONS_ALL table
It's a rather straightforward process. You have to carefully monitor table
extents and decide about the rollback segments on line. We set the usual
rollback segments off line and had a unique xtra large rollback for the
Convert to Multi-Org.
I would recommend you run it as part of AR implementation, once AR is empty.
Nevertheless, it's quite easy with AR in production. Just monitor the tricky
AR_JOURNAL_INTERIM_ALL table which never purges, should the Journal Entries
report fail for any reason. This is true since I rolled-out a R9.3 years
ago, and still true in R11.5.8 !!!!
Hope this helps. Feel free to contact me directly should you need further
details.

Bertrand Darrieus 
Europcar Key Account Director "Support"
*   33 (0)1 30 44 95 31
*   DarrieusB@mail.europcar.com
Fax 33 (0)1 39 44 60 09

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited and may be a
violation of law. If you received this transmission in error, please contact
the sender by reply e-mail and delete and destroy all copies of the
material, including all copies stored in the recipient's computer, printed
or saved to disk. Thank you.
Software virus: Europcar has taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own virus
checks on any attachment to this message. Europcar cannot accept liability
for any loss or damage caused by software viruses.
Intellectual Property: Europcar has built up a significant reputation in the
name "Europcar" and has a number of trademark applications and registrations
in many countries. No trademarks, service marks, and trade names owned or
licensed by Europcar or its affiliates may be copied, reproduced,
republished, uploaded, posted, transmitted, or distributed in any way,
without the prior written consent of Europcar.


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>