I have one webservice in which i have done connection with oracle database

now suppose my webservice crashes due to power failure..it had submitted
some transactions say update on database;

now database is intact but my webservice failed..so locks are remaining on the database

now i create a new webservice, for recovering database. i am losing my previous long transaction (still not committed) because of power failure.

when transaction is executing if we do "alter system log switch", checkpoints
are taken..buffers are writted to disk..can these help me when after failure i am starting a new recovery service- My intension is i dont want to submit
whole transaction again...thru checkpoints i want to recovery transactions effect which i had submitted through my webservice(beacuse executing long
transaction from scratch takes too much time)..can checkpoint facility(inbuilt in oracle) help me solve this?

How?


thnx