 | | | disk read and processes | disk read and processes 2006-09-21 - By Ronny Egner
Back
Hi list,
i am struggling with i/o benchmarking and have a few questions:
Our central NAS system has performance issues with
nfs on solaris. When writing/reading over a gbit-link we see
"only" 35 mb/s within a single thread. When adding a second
thread (or process) the throughput increases - up to 80 mb/s with 4
threads (or processes).
However when writing data to disk with lets say 4 dbw processes
we can max out the 80 mb/s. But how does reading from disk relates
to that ? Lets say we do a full table scan in a single session and
therefore have to read the whole table - does oracle use more than
one process (or thread) to do that (remember my problem: one session
or thread can only read 35 mb/s at maximum speed) ?
--
Mit freundlichen Gr??en
Ronny Egner
Diplom-Ingenieur (BA)
SIV.AG
Konrad-Zuse-Stra?e 1
18184 Roggentin
Telefon: +49 (0)3 81 / 25 24 422
Telefax: +49 (0)3 81 / 25 24 399
mailto:ronny.egner@(protected)
http://www.siv.de
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. The views expressed in this
e-mail are those of the individual author and not necessarily
those of SIV.AG.
This footnote also confirms that this email message has
been swept by serval anti-virus tools for the presence
of computer viruses.
**********************************************************************
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
|