Xref: alice comp.databases.oracle.server:48257 comp.databases.oracle.tools:24351
From: "david solan" <david_solan@msc.ie>
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server
Subject: Effects of a rollaback - nubie question
Lines: 19
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Managed Solutions Corporation, Dublin, Ireland www.msc.ie
Message-ID: <925900914.572479@oasis010.msc.ie>
Cache-Post-Path: oasis010.msc.ie!unknown@opc163.msc.ie
X-Cache: nntpcache 2.3.2 (see http://www.nntpcache.org/)
Date: Wed, 5 May 1999 11:39:25 +0100
X-Complaints-To: news@indigo.ie
X-Trace: news.indigo.ie 925900757 194.125.128.202 (Wed, 05 May 1999 11:39:17 BST)
NNTP-Posting-Date: Wed, 05 May 1999 11:39:17 BST
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.tli.de!newscore.gigabell.net!newscore.ipf.de!news.datacomm.ch!newsfeed-zh.ip-plus.net!news.ip-plus.net!News.Amsterdam.UnisourceCS!newspeer.te.net!news.indigo.ie!not-for-mail

Hi there

I pretty new to Oracle etc. so please bear with me.

My application is using connections to Oracle via dbtools.h++ and the logic
of the program sometimes issues unnecessary rollbacks. There is never
anything outstanding on the transaction when the unnecessary rollback is
issued so I am trying to figure out what happens within Oracle and how big
is the performance hit on the db. I am unsure what way the db is setup with
regards to rollback segments.

Any information or pointers would be greatly appreciated.

thanks in advance,
Dave

p.s. replies by email would be appreciated.