One other thing: we are running with a block size of 32K.
Nick Shanny
(Brother of above person)
On Apr 22, 2004, at 7:30 PM, Sean Shanny wrote:
I should have included this as well:
show all;
name |setting
+
add_missing
Tom,
I understand the problem and your solution makes sense although I am
still puzzled by the machine under-utilization. If you run the original
query and monitor the IO/CPU usage you find that it is minimal.
here is the output from iostat 1 for a brief portion of the query. I am
very curi
