Skip to Content
0
Dec 04, 2008 at 12:06 PM

Upgrade to ECC6.0 very slow after EU_IMPORT. initSID.ora

60 Views

Hi,

Tomorrow the 5th I will upgrade from 4.6C to ECC 6.0 .

The phases that perform tp imports are very slow.

The upgrade runtime was 25 hours !!

I type a TOP command and I can see oracle at 99% and R3trans or tp sleeping.

I think the fault maybe are the parameters in initSID.ora

After upgrade the response time is very good so maybe for the upgrade is better to tune some memory parameters.

I have an HP UX with 16Gb RAM 2 processors

In my initSID.ora

shared_pool_size = 1610612736

pga_aggregate_target = 629146000

db_cache_size = 3221225472

Do I have to dicrease the shared_pool_size ?

Could you help me , please ?

Thank you

Albert.