No question at this time
DBA Top 10
1 M. Cadot 6700
2 B. Vroman 3900
3 A. Kavsek 2700
4 J. PĂ©ran 1700
5 T. Boles 600
5 D. Johnson 600
7 T. P 500
8 P. Wisse 400
9 S. Spb 300
10 V. Gupta 200
10 M. Jain 200
10 K. Pingeli 200
10 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48649
Total active users1380
Act. users last 24h1
Act. users last hour1
Registered user hits last week81
Registered user hits last month279
Go up

time taking to move LOB column
Next thread: ORDS configuration problem
Prev thread: rollback taking long time oracle

Message Score Author Date
Hi , I am defragmenting a Table containing LOB ...... saumya das Sep 07, 2021, 20:32

Follow up by mail Click here


Subject: time taking to move LOB column
Author: saumya das, India
Date: Sep 07, 2021, 20:32, 90 days ago
Os info: AIX 7
Oracle info: oracle 12c RAC
Message: Hi ,

I am defragmenting a Table containing LOB column ,
i am moving the LOB column , but its taking long time to complete , to make it faster i used the below command before moving LOB.

alter session force parallel ddl parallel 5;

Now the time has improved , But still not fitting the expectation . Is there any way to further improve the process. Any suggestion will be much helpful.

Thanks
Saumya
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here