your custom needs based on your system and
> application demands. When you over-simplify something,
> you lose the flexibility. The art factor here (which
> requires some planning) is in achieving a balance
> between simplicity, flexibility, performance,
> manageability and availability.
&
for other information (like subscribing).
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
INET: [EMAIL PR
async IOWhat is the slave process? Which io has to
complete? Which write has to complete?
Thanks.
Regards,
Hans de Git
_
Hotmail en Messenger on the move
http://www.msn.nl/communicatie/smsdiensten/hotmailsmsv2/
--
Please see t
t raised my aio maxreqs to 16384.
> Would it be beneficial to increase _db_writer_max_writes?
>
> HTH,
> Hans de Git
>
> _
> MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
>
> --
> Please s
Hi All,
The current value for my AIX 4.3.3 / 8.1.7.4 instance parameter
_db_writer_max_writes is 4096. I've just raised my aio maxreqs to 16384.
Would it be beneficial to increase _db_writer_max_writes?
HTH,
Hans de Git
idea to let the OS handle the striping?
Regards,
Hans de Git
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
INET: [EMAI
l fashion i.e. spindle B will not start writing block 2 before
> spindle A has completed writing block 1.
>
> Is this still true for a Symmetrix with 5568 firmware?
> Perhaps it's a better idea to let the OS handle the striping?
>
> Regards,
> Hans de Git
>
> ___
a Symmetrix with 5568 firmware?
Perhaps it's a better idea to let the OS handle the striping?
Regards,
Hans de Git
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-
egarding double buffering etc. Are there any alternatives, other than
moving to raw volumes?
HTH,
Hans
_
MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
of the database files using the o_cio flag? Or should
one mount the jfs2 filesystem using the -o cio option?
Looking forward to your reactions.
Regards,
Hans de Git
_
Chatten met je online vrienden via MSN Messenger. http://m
;t used". Just like you said,
is's all hash joins. It's a production system; I can only peek via the
perfstat schema, but I know the application and instance well enough.
Case closed, as far as I'm concerned.
Thank you all for the input.
Regards,
Hans de Git
Reply-To: [EMAIL
> db file parallel write 1,8933,115
> > 4.32
> >
> > You'll notice that 'direct path write' is the most expensive one in
the
> > list. I cannot find enough info on the net about this wait event,
> therefore
>
er this wait event? In what way is this event
> different from "db file parallel write"?
> I mostly read comments that suggest lots of sorting and parallallel
queries.
>
> However, most sorts are done in memory and degree = 0 for all tables.
>
> Any suggestions are very we
memory and degree = 0 for all tables.
Any suggestions are very welcome.
Thanks,
Hans de Git
_
MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Aut
e auditing mechanisms in Oracle:
- build a system trigger which recognises logon and logoff.
I assume that'll work just fine. However, I'm not sure how to charge
our customer for aborted sessions.
Any suggestions are very welcom
15 matches
Mail list logo
