BDLS runtime/performance

[Former Member]

hello - has anyone came up w/ some ways to improve BDLS runtime/performance? we have an 4.7 system on Oracle that is about 8TB allocated. BDLS is taking a long time....over 1 day and still running

any idea on how much changing the #entries/commit will help? default is 1 million records/commit....wondering how high i can go, and how much , if any, that would help

thanks

[Former Member · Accepted solution]

Hi,

>any idea on how much changing the #entries/commit will help? default is 1 million >records/commit....wondering how high i can go, and how much , if any, that would help

I'm afraid that you are on your own on this subject.

This is a tuning completely dependent from your specific configuration.

The biggest entries#/commit the better for performance but until you break down the undo segment limit (for Oracle of course).

You have to experiment to find the better parameter for your setup.

BDLS on a 8 TB database, it just can be very time consuming...

Regards,

Olivier

[Former Member · Accepted solution]

thanks yes...it's still running btw - 2+ day

- is running BDLS required if you do a system copy and are not changing the SID? (i.e. the logical system name)

[Former Member · Accepted solution]

On our 1.2 TB database, it lasts about 12 hours...

If you don't change the SID and you use the same client, you should not need to run BDLS.

But I think it is a dangerous idea to keep the same SID for a test system : too error prone for my taste !

Regards,

Olivier

[Former Member · Accepted solution]

Hello Ben,

How much time did it took for BDLS to complete in your system. We have the same setup and our database is 8.5 TB.

Please let me know because in my system it is running for past 35 hours.

Regards

Prerna