P4 with 512 MB is not a system I would recommend to anybody, but it
can not explain 8h. I'm more concerned about constraints, indexes,
triggers etc.
Non oracle activities on system should also be studied. Maybe disk has
some HW problems.

I have to disagree with Mark. I agree with "lakh", but if Mark know what
it means, he should share his knowledge with us, not leaving us with in
doubts.

I have to strongly disagree with "is having". I think everybody understand
the point, this is not some literature contest forum, and most of us are
speaking
english as a foreign language. I think we should concentrate on oracle stuff
not on linguistic perfection (until it is understandable).

Regards KAzi

Geerlings Mark wrote:
> 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.
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>



Oracle LazyDBA home page