by looking at the number of buffers scanned, redo log space requests and the
lru scans. According to what I have read there was a possibility that my
DBW0 was not performing very well. It was just a shot in the dark to try
and squeeze some performance out of the db.
Kev
-----Original Message-----
Sent: Monday, June 04, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L
Kevin,
I apologize for asking but this is for the benefit of others possibly. But
how did you determine that your instance may require an additional DBWR
process. What led you to think that you had an bottleneck with only one
process?
Thanks,
Ethan
-----Original Message-----
Sent: Monday, June 04, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I added db writer processes last week to try and improve performance
of one
of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle
actually started the additional db writer processes? I added
db_writer_processes to the init file, the instance started so I am assuming
that the db writer processes are working. But we all know what happens when
we assume something. Any ideas would be appreciated.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
----------------------------------------------------------------------------
--
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law. If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy. Thank you.
============================================================================
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
