rman ? nfs ? slow
Date: Thu, 1 Jan 2009 11:02:58 +0800
Message-ID: <gjhbpc$i7v$1@news.cn99.com>
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:
=> 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 TIME
------------------- ------------------- ---------------- ---------- -------- ------- ----------------- -------- -------- -------- -------- ---------- 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 = 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 TIME
------------------- ------------------- ---------------- ---------- -------- ------- ----------------- -------- -------- -------- -------- ---------- 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 = 2.4M
in windows, I use to copy command , archive filesiez = 42M ,it takes only
2-3sĄŁ
copy arch... \\192.168.25.100\backup
why?
thank advanced. Received on Wed Dec 31 2008 - 21:02:58 CST