Please be aware that "lakh" is *NOT* an English word! Yes, people in
India and Pakistan may understand it, but most English speakers in the
rest of the world will not have any idea what this means. (I read a
book by a Pakistani author recently who used this word and explained it,
since the author knew that English speakers outside of India and
Pakistan will not recognize this word.)
Also, your use of the phrase "is having" is unique to India. In most of
the English-speaking world, that expression is used to describe a
temporary condition only, for example: "I am having trouble with
[something]". But, for more permanent conditions or situations, we
simply say: "I have..." or in your case "The table has 780,000 records".
A simple update of a table with less than a million rows should not take
anywhere near 8 hours on a P4 server. But, many things could slow this
down. First, 512MB of RAM is not much for an Oracle server. What size
is the Oracle SGA? (It shouldn't be over 250MB then, but that is quite
small for Oracle.) Second, what kind of disk system does the server
have (IDE, SCSI, SATA, etc)? If multiple disks, are they RAID or not?
If RAID, which RAID level? (RAID5 is terrible for some parts of an
Oracle system.) Third, is the column that is being updated indexed? If
yes, that will make the update slower. Fourth, is the database in
archivelog mode?
-----Original Message-----
From: dgaikwad
[mailto:oracledba-ezmlmshield-x54511279.[Email address protected]
Sent: Sunday, October 07, 2007 11:58 PM
To: LazyDBA Discussion
Subject: Update Takes Lot Of Time
Hi DBAs
Following Update SQL takes more than 8 hours.
Update TABLE1
set Date1=Date2;
Date1 and Date2 are from same table TABLE1 and of DATE type.
Machine Config is P4 with 512 MB RAM no other big Processes are running.
TABLE1 is having 78 lakh records.
can any body tell me alternarte way to do this update.
Thanks & Regards,
Dinesh G.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.
Oracle LazyDBA home page