Re: Performance

<fitzjarrell_at_cox.net> kirjoitti
viestissä:1158356771.008997.40400_at_i3g2000cwc.googlegroups.com...

Jack wrote:
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> kirjoitti
> viestissä:141mg2p51bbgmgfj64suahs3ic67n06i6m_at_4ax.com...
> > On Fri, 15 Sep 2006 19:19:34 GMT, "Jack" <Jack_at_none.com> wrote:
> >
> >>The point is how to fix it?
> >>Or just say that network is busy, server old/slow and db version old.
> >>But software is ok, because it is fast in old desktop pc ;)
> >
> >
> > Likely no asynchronous I/O on Solaris (if using standard ufs) and
> > asynchronous I/O on Windows by default.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> I considered that also.
> There is disk_asynch_io parameter true and RAID-10 and also believe
> that solaris is new enough to handle it.
> But how to know it sure?
>
> Jack

POST the release/patch level of Solaris you're using. Or check www.sun.com.

David Fitzjarrell

Hi!

If I remember correct it is Sun SPARC Solaris 2.8 It cannot handle dynamic SGA (not in use).

But somehow I doubt memory, direct I/O or something like that. Is there some patches for that kind of issues. Or some kernel parameter.

That i/o feels a bit sticky, maybe it is Solaris problem? Hopefully there is some manageable fix, i do not have contact with SA. And these kind of things cannot be done without hard evidence.

Jack Received on Fri Sep 15 2006 - 17:47:10 CDT