Re: Count commits

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 3 Dec 2005 14:32:45 +0100
Message-ID: <43919e7d$0$29514$626a14ce@news.free.fr>

"Ralf Moosandl" <ralf.moosandl_at_t-online.de> a écrit dans le message de news: dmrs4u$qha$01$1_at_news.t-online.com...
| Dear all,
| whats the best practice to count the number of commits
| -done to an instance
| -done to a table
| thanks in advance.
|
|

v$sesstat and v$sysstat gives you number of commits per session and for the whole instance. There is nothing like "commit done to a table" but you have statistics on changes per object in v$segment_statistics.

Regards
Michel Cadot Received on Sat Dec 03 2005 - 07:32:45 CST