RE: db file sequential read waits on INSERT into non-indexed partitioned table

From: <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 29 Sep 2011 13:54:42 +0100
Message-Id: <E1R9G8Q-000EH8-1l_at_pr-webmail-2.demon.net>

I should have asked - how many rows do you get per block, and what's the block size (which, in your version, with ASSM) might make a difference to what's going on.

Regards
Jonathan Lewis

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 29 2011 - 07:54:42 CDT

This message: [ Message body ]
Next message: Walker, Jed S: "RE: RACnode communication problem?"
Previous message: jonathan_at_jlcomp.demon.co.uk: "Re: db file sequential read waits on INSERT into non-indexed partitioned table"
Maybe in reply to: Wayne Adams: "db file sequential read waits on INSERT into non-indexed partitioned table"
Next in thread: Wayne Adams: "RE: db file sequential read waits on INSERT into non-indexed partitioned table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message