KeithAnother option, you could try is use tanel's snapper.sql script (tanelpoder.com) and Look at difference in statistics. That should give more clue as to what that process is doing.. More concrete method is to trace logical I/O, but that tend to generate huge amount of trace data to look through. Daniel Fink presented some stuff about this. See http://optimaldba.com/
Cheers Riyaj The Pythian Group blog: http://orainternals.wordpress.com
Cary Millsap wrote:I agree with what Riyaj has said. It helps sometimes to realize that "waits" just means essentially "OS calls."I'd expect your process is indeed doing a lot of buffer processing, using data that's already in your database buffer cache. You can confirm or refute this hypothesis quickly with a couple of snaps of v$sess_io.Cary Millsap http://method-r.com http://carymillsap.blogspot.com
-- //www.freelists.org/webpage/oracle-l