Path: news.cambrium.nl!textnews.cambrium.nl!feeder5.cambrium.nl!feeder4.cambrium.nl!feed.tweaknews.nl!209.197.12.242.MISMATCH!nx01.iad.newshosting.com!newshosting.com!198.186.194.250.MISMATCH!news-xxxfer.readnews.com!news-out.readnews.com!transit3.readnews.com!postnews.google.com!r10g2000prf.googlegroups.com!not-for-mail From: Steve Howard Newsgroups: comp.databases.oracle.server Subject: Re: rman ? nfs ? slow Date: Thu, 1 Jan 2009 16:31:01 -0800 (PST) Organization: http://groups.google.com Lines: 76 Message-ID: References: NNTP-Posting-Host: 75.118.5.89 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1230856262 3901 127.0.0.1 (2 Jan 2009 00:31:02 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 2 Jan 2009 00:31:02 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: r10g2000prf.googlegroups.com; posting-host=75.118.5.89; posting-account=wtlN5gkAAAAVr064jxzGl8R72LkgvhF6 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20,gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Dec 31 2008, 10:02 pm, "lfree" wrote: > I use rman backup product database on OS windows(2003 R2 standard 64 > edition ) ,I check to find > it is slow (vs Linux rhel 4.3 ). My nfs server use SFU for windows. > > windows: > > =3D> select * from v$version ; > BANNER > ---------------------------------------------------------------- > Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi > PL/SQL Release 10.2.0.4.0 - Production > CORE 10.2.0.4.0 Production > TNS for 64-bit Windows: Version 10.2.0.4.0 - Production > NLSRTL Version 10.2.0.4.0 - Production > > SELECT start_time, end_time, status, input_type, elapsed_seconds, > compression_ratio, TRIM (input_bytes_display) inputb, > TRIM (output_bytes_display) outputb, > TRIM (input_bytes_per_sec_display) input, > TRIM (output_bytes_per_sec_display) output, > TRIM (time_taken_display) TIME > FROM v$rman_backup_job_details > WHERE start_time > TRUNC (SYSDATE) - 1; > > START_TIME END_TIME STATUS INPUT_TYPE > ELAPSED_SECONDS COMPRESSION_RATIO INPUTB OUTPUTB INPUT OUTPUT TIM= E > ------------------- ------------------- ---------------- ---------- -----= --- > ------- ----------------- -------- -------- -------- -------- ---------- > 2008-12-31 20:03:06 2008-12-31 20:19:37 COMPLETED ARCHIVELOG > 991 2.59272 1.02G 402.88M 1.05M 416.29K 00:16:31 > > output_bytes_per_sec_display =3D 416.29K. > > linux : > > BANNER > ---------------------------------------------------------------- > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi > PL/SQL Release 10.2.0.3.0 - Production > CORE 10.2.0.3.0 Production > TNS for Linux: Version 10.2.0.3.0 - Production > NLSRTL Version 10.2.0.3.0 - Production > > START_TIME END_TIME STATUS INPUT_TYPE > ELAPSED_SECONDS COMPRESSION_RATIO INPUTB OUTPUTB INPUT OUTPUT TIM= E > ------------------- ------------------- ---------------- ---------- -----= --- > ------- ----------------- -------- -------- -------- -------- ---------- > 2009-01-01 02:10:17 2009-01-01 02:17:51 COMPLETED ARCHIVELOG > 454 2.72805 2.91G 1.07G 6.56M 2.40M 00:07:34 > 2008-12-31 02:10:17 2008-12-31 02:16:25 COMPLETED ARCHIVELOG > 368 2.59673 2.25G 888.76M 6.27M 2.42M 00:06:08 > > output_bytes_per_sec_display =3D 2.4M > > in windows, I use to copy command , archive filesiez =3D 42M ,it takes on= ly > 2-3s=A1=A3 > copy arch... \\192.168.25.100\backup > > why? > > thank advanced. Hi, I see you are using compression. Are the CPU's saturated on the Microsoft server? Regards, Steve