Need help with Discrete Transactions

From: Robert Tanski <rtanski_at_penses.sw.stratus.com>
Date: 14 Apr 1994 19:44:32 GMT
Message-ID: <2ok6f2$22m_at_transfer.stratus.com>


Does anyone out there have any experience with discrete transactions? If so I have a couple of questions for you.

When you execute a discrete transaction does Oracle perform a recursive call for each sql statement contained within the discrete transaction?

I took an SQL_TRACE/tkprof of our application running and I was a little surprized by what I saw in the output for the discrete transaction. Basically the trace file gives me stats for the discrete transaction which is what I expected. However it also gives me stats for each sql statement contained in the discrete transaction. However when I sum up, say the CPU usage for each sql statement, I get no where near the total that is shown for the discrete transaction as a whole. I guess what I'm looking for is for some insight on how to interpret this information. And should I be getting seperate stats for each sql statement in the discrete transaction?

thanks in advance

bob tanski Received on Thu Apr 14 1994 - 21:44:32 CEST

Original text of this message