Re: Isolation levels in Informix vs Oracle

DA Morgan said: > Dave Griffen wrote: > >> One of >> the things I use it for is to check the progress of batch jobs. If I >> know a >> program is going to insert 100,000 rows into a table, I can use dirty >> read >> to see how many rows it has inserted so far and can give a good estimate >> of >> when it will finish. If you are only allowed to see committed data, you >> wouldn't have that monitoring option. > > In Oracle one would use the DBMS_APPLICATION_INFO built-in package as it > not only tells you what percentage of a batch is done it uses the > transaction rate to an estimate of the completion time. The information > is available via OEM and by querying v$session_longops. And that knows what my application is still going to do as well? Oracle *has* come along in the last few years... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list