<<I did a simple routine to trap in a TXT log file all the active transactions. I realized that I need to be SYSDBA in order to run a query against MON$TRANSACTIONS. So, every time a user enters or exits from the applitaction I save a log of all the transactions. I found that I had some read/write transactions running for 2 hours. And that is a HUGE time I think! >>
Not really, 2 weeks or 2 months would be a huge time. > I read somewhere that the "read only" transactions are absolutelly harmless > to the GC and sweeping. Is that so? Read only transactions only physically have an impact on the TIP/Header page(s), however a long running read only transaction will have the same effect as a long running read write transaction in that it will block GC and sweeps until it commits. Paul
