How to do a COMPUTE STATISTICS with Oracle Connector Stage

[eph]

Hi all,

I was wondering how to perform a 'COMPUTE STATISTICS' with the brand new Oracle Connector stage. As I can see, it's available in the 'old' Oracle Enterprise Stage but not in the new one. Is that automatic? Or is it the 'Index maintenance option' that is doing the job?

I'm doing a bulk load with bulk load options :

Code: Select all

'Allow concurrent load sessions' = Yes, 
'Index maintenance option' = Skip all, 
'Disable logging' = Yes, 
'Perform operations before bulk load' = Yes,
         'Disable constraints' = Yes,
         'Disable triggers' = Yes,
'Perform operations after bulk load' = Yes,
         'Rebuild indexes' = Yes,
                   'Parallel clause' = PARALLEL
                   'Degree of parallelism' = 4
         'Logging clause' = NOLOGGING
         'Enable consatraints' = Yes
         'Enable triggers' = Yes

Thanks in advance
eph

[eph]

Hi all,

Is there no one using this stage to do bulk load? Let me know if you have a better idea, my requirements are:
- parallel bulk load after truncate
- with constraints, indexes and triggers off
- rebuild (switch on) of previous constraints, indexes and triggers in parallel mode
- compute statistics

Regards,
eph

[eph]

Hi folks,

Does anyone got an idea/tip?

Thanks
eph

[ray.wurlod]

I'm sure they'd post it if they do, next time they log in.