I don't see this feature in Oracle or Gray' book so I would
like to know what do you think about ability to have more than
1 log to let different transactions write to different logs,
in parallel. All log records from particular transaction will
go in one log file (one fsync on commit). Transactions will
choose log file to use in circle order. Each log record will have
unique id shared among all logs to order things.
By placing logs on different disk one could significantly
increase performance.
Comments?
Vadim