|
-
Slow UPDATEs
Hi everyone,
Generally when i do an insert into a table it happens fast say for 2 lakh record it takes three mins. Whereas when i do an update it takes more than 30 minutes . the PCTFREE is 20 and the PCTUSED is 80 for that table and partitioned.
Can anyone suggest me what could be the reason for that?
Thanks in advance
Shyla
Shyla
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|