View previous topic :: View next topic
|
Author |
Message |
sandeepbadal
New User
Joined: 22 Feb 2005 Posts: 1
|
|
|
|
Hi,
I am having a table that consists of LOB columns. These consists of huge data.
While performing the QUIESCE and reorg of this tablespace it takes huge amount of time.
Is there a way we can fine tune the performance of this QUIESCE utility. The parameters used are as below
Code: |
REORG TABLESPACE LIST XYZ
UNLOAD CONTINUE
SORTDEVT SYSDA
SORTKEYS
SORTDATA
LOG NO
UNLDDN S0001
WORKDDN SYSUT001
STATISTICS TABLE(ALL) SAMPLE 10 INDEX(ALL)
SHRLEVEL CHANGE
DEADLINE NONE
LONGLOG TERM
DELAY 300
MAXRO 1200
MAPPINGTABLE PDB201.TDBSY019 |
Code'd |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Working with Huge Data often requires Huge Amounts of time. . .
Why is there a need to re-organizate a table that would/should be fairly static? |
|
Back to top |
|
|
|