Is usage of indexes related to performance of commit command?

Hi,

due to a missing index, select and delete commands on a table were really slow, which is understandable. This behavior was fixed by creating an appropriate index.
Whenever the index did not exist the execution of commit or rollback commands were very slow after approx. 10000 rows were inserted into and deleted from this table.
After creation of the index commit and rollback performed in regular time.

How are these two facts related to each other? How can I tune the data base to insure in general a fast commit and rollback?
Is it possible to trace the execution of the commit/rollback command?

The Oracle version is 8.1.7 on Windows 2000.

Thanks,

Ludwig Received on Wed Jul 21 2004 - 19:45:20 CDT