Re: Solaris Direct I/O
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- Date: Tue, 9 Feb 2010 12:09:02 -0600
Thanks Kellyn, Josh and Krishna for all information.
I have though one question why veritas ODM is better the oracle ODM. Is
there any performance impact with that or it's just by default do direct I/O
that's why
On Tue, Feb 9, 2010 at 12:00 PM, Kellyn Pedersen <kjped1313@xxxxxxxxx>wrote:
> If you use RMAN for backups, query the v$backup_async_io view. The data is
> not static if you were to cycle the database, but if you look since your
> last backup and there are rows, you are using async i/o...
>
> Kellyn Pedersen
> Multi-Platform DBA
> I-Behavior Inc.
> http://www.linkedin.com/in/kellynpedersen
> www.dbakevlar.blogspot.com
>
> "Go away before I replace you with a very small and efficient shell
> script..."
>
>
> --- On *Tue, 2/9/10, Josh Collier <Josh.Collier@xxxxxxxxxxxx>* wrote:
>
>
> From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
> Subject: RE: Solaris Direct I/O
> To: "taral.desai@xxxxxxxxx" <taral.desai@xxxxxxxxx>, "
> oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> Date: Tuesday, February 9, 2010, 10:30 AM
>
>
> I can answer 2 of these, at least this is understand:
>
>
>
>
>
> 1. Check the mount options with your sysadmin, they should look like
> this ,mincache=direct,convosync=direct, this will set things up for direct
> i/o.
>
> 2. Use truss, if you see kaio failure followed by several lwp
> processes spawning then you are using async i/o. solaris implements
> kernalized async i/o, so the kaio calls will fail and the OS will respond
> with several LWP serial process to simulate async i/o. with filesystem
> options to SETALL, it should be doing async i/o.
>
>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Taral Desai
> *Sent:* Monday, February 08, 2010 10:45 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Solaris Direct I/O
>
>
>
> Hi All,
>
>
>
> We are using sparc 64bit v 10 with oracle 10.2.0.3. Above that we use SAN
> storage.
>
>
>
> 1. How to find if storage is mounted for direct or async io
>
>
>
> 2. We had set filesystem option to setall. How to verify it's doing direct
> or async. As with truss i see many kaio failure and then it invokes lwp
> process which do i/o in chunks. So, is there a different call for SAN.
>
>
>
> 3 Is there any benefit using veritas ODM over oracle ODM ?
>
>
>
>
>
--
Thanks & Regards,
Taral Desai
Other related posts:
