I have the table and it had 5 columns
CREATE TABLE LIS.LD_EXHIBIT_DESC
AGMT number (10) NOT NULL,
EX VARCHAR2(4000) NOT NULL,
SYSGEN VARCHAR2(1) NULL,
UPDT_DATE DATE NULL,
UP VARCHAR2(12) NULL,
LINE_NO NUMBER(3) NULL
I try to update the column LINE_NO=5 and it takes forever,
the table has about 40K now.
What do I need to to do to speed up this process ???
First if You update a big table you should assign a big rollback segment with a high initial and next extent
Ensure there is proper log switching ...
If checkpoint problem is there your update will take longer(check in the alert log)
If there is a problem add one or two more log membets ...
if possible while doing mass update do that as nightly job