View previous topic :: View next topic
|
Author |
Message |
kalaikala
New User
Joined: 21 Jul 2007 Posts: 27 Location: Chennai
|
|
|
|
A table has huge number of data. I want to unload it in a file.
In the table unload I am getting CPU time as 6 mins and Clock time 30 mins. To get better performance I planned to do parallel unload.
Select * from XXXXXXXX.YYYY
When I do parallel unload for all partitions in the tablespace CPU time is so high(~15 mins) and Clock time (3 mins) only.
TEMPLATE UNLDDS DSN &USERID..SMPLUNLD.&TS..T&PART.
UNIT SYSDA DISP (NEW,CATLG,CATLG) SPACE (5000,500) TRK
UNLOAD TABLESPACE DBXXXXX.TSMYYYY
UNLDDN UNLDDS
FROM TABLE XXXXXXX.YYYY
I want to improve its performance(by reducing both CPU and Clock). Please help me out in this. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
Please help me out in this. |
we cannot do it...
most of the time optimizing elapsed has negative effects on the CPU utilization
( parallelism, buffering, .... ) |
|
Back to top |
|
|
kalaikala
New User
Joined: 21 Jul 2007 Posts: 27 Location: Chennai
|
|
|
|
So the table unload will be better than the tablespace unload. Because its performance is good in CPU and Clock time too.
Am i correct?. |
|
Back to top |
|
|
|