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.