Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: filesystemio_options option on solaris 9 sparc 64-bit (Oracle 10g)

Re: filesystemio_options option on solaris 9 sparc 64-bit (Oracle 10g)

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Thu, 18 Oct 2007 00:09:22 +0530
Message-ID: <75aa80160710171139j3fcd223cw320ccbbf9b19c4b5@mail.gmail.com>


Hi John,

Thanks for your help. In my environment filesystemio_options is set to SETALL Still it is not using directIO as per your test. My server is sparc Solaris 9, 64 bit with Oracle 10.2.0.3.

Can you please help me in troubleshooting the same. Am I missing anything?

Regards,

Deepak

On 10/17/07, John Hallas <john.hallas_at_bjss.co.uk> wrote:
>
> I used this only last week found at
> http://orafaq.com/usenet/comp.databases.oracle.server/2007/07/12/0854.raw
>
>
>
> [ first flush the buffer cache ]
>
> sys_at_BIA.WORLD> alter system flush buffer_cache;
>
>
>
> System altered.
>
>
>
> [ Then issue (as user oracle) ]
>
> oracle_at_ironman:~$ truss -f -t open,ioctl -u ':directio' sqlplus user/
>
> pass
>
>
>
> ... (lots of output here)
>
>
>
> [ Then type ]
>
> create table a as select * from big_table;
>
>
>
>
>
>
>
> You will see that for every data file opened, directio is explicitly
>
> turned off:
>
>
>
> 24399: open("/u04/oradata/BIA/APM_DATA13.dbf", O_RDWR|O_DSYNC) = 11
>
> 24399: -> libc:directio(0x10f, 0x0, 0x1, 0x0)
>
> 24399: ioctl(271, 0x2000664C, 0x00000000) = 0
>
>
>
>
>
> The 3rd parameter to the ioctl() call is 0 for directio_off, and 1 for
>
> directio_on.
>
>
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *DBA Deepak
> *Sent:* 17 October 2007 11:21
> *To:* oracle-l
> *Subject:* filesystemio_options option on solaris 9 sparc 64-bit (Oracle
> 10g)
>
>
>
> Hi Experts,
>
>
>
> Have enabled directIO on Solaris 9 (Oracle 10g) by setting the parameter
>
> filesystemio_options=setall
>
>
>
> Is there any way that I can verify whether Oracle is using directIO or
> not?
>
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>
> ------------------------------
>
> BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW.
> Registered in England with company number 2777575.
> http://www.bjss.co.uk
>
>

-- 
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 17 2007 - 13:39:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US