A couple of things


Is it one big transaction or is it a part of couple of transactions. ?
If you break of one transaction it will be rolled back the previous ones
will be uncommited.


A commit only's flushes the contens of the redo log buffer to the redo log
files, it writes nothing to the datafiles. This is also done by Oracle
itself if for example de de redo log buffer are 1/3 full etc.

You, can force a checkpoint just to be sure, it will write the contens of
the buffercache to the datafiles.
I would do this before breaking of the session. A bit risky though what part
is in the datafiles and what part is not.

Hope theis helps


Regards

Lars Jans

-----Original Message-----
From: mimime
[mailto:oracledba-ezmlmshield-x91329580.[Email address protected]
Sent: zaterdag 31 mei 2008 5:43
To: LazyDBA Discussion
Subject: How to force commit a SQL statement run by other user?


Dear Guru,

I am new in this field. Please forgave me asking such a basic question:

One user had a script running for days and generated millions rows (not
committed yet). I need to stop his process now in order to do maintainence
work over the weekend. I want to force commit his data so he will not lost
any thing. How should I do it?

The oracle manual mentioned "DBA_2PC_PENDING", but di not give example.
Please help. Many thanks.





---------------------------------------------------------------------
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