Re: single session I/O bandwidth
From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 13 Mar 2013 18:47:23 +0100
Message-ID: <CAJ2-Qb8tbMVsGbvehZqc2dhqi-vVffRzh-znx4_wGKVro7Cs7g_at_mail.gmail.com>
Hi Tanel
I used count(*) and forced a FTS because otherwse it is the SQLPLUS that is the bottleneck (fetching the rows). Brute force test looking for the maximum bandwidth
Date: Wed, 13 Mar 2013 18:47:23 +0100
Message-ID: <CAJ2-Qb8tbMVsGbvehZqc2dhqi-vVffRzh-znx4_wGKVro7Cs7g_at_mail.gmail.com>
Hi Tanel
I used count(*) and forced a FTS because otherwse it is the SQLPLUS that is the bottleneck (fetching the rows). Brute force test looking for the maximum bandwidth
It is db file scattered read, in all cases is reading from ASM. In P7 however I am not 100% sure if it was direct path read or db file scattered read, I will try again.
Cheers
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 13 2013 - 18:47:23 CET