Hi,
I am using oracle 9.2 with windows2000 server.
When I commit a transaction, it takes a long time even for a single
record. Selects are very fast.
This is what I get from the waitstats

SQL> select class, count, time
2 from v$waitstat
3 where count > 0
4 order by class
5 /

CLASS COUNT TIME
------------------ ---------- ----------
data block 4 0
segment header 1 0

What are the init paramters that I can check or any v$ tables to
pinpoint the problem.
Thanks,
Mark