Updating oracle views Camchat list
meaning, the slowdown -- well, it is in the client, it is not asking us to do any work.
now, looking at that tkprof -- that "whatever" statement you have the report for runs instantly -- less then 5/1000ths of a second by the wall clock.
I realize that 2 parallel operations can take different amounts of time to finish their tasks and that some waits cannot be avoided (or even considered bad), I just don't know which ones.
I looked in the oracle8 Ref for a list of Oracle Wait Events. Log file parallel write is writing redo records to the redo log files from the log buffer. In this case, it means the database is not the bottleneck, its spent alot of time WAITING for you to tell it to do something.