Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 614966 Details for
Bug 859131
Performance problem copying/writing file on CIFS using Oracle FILE_UTL procedures.
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
copyfile.sql
ora-copyfile-procedure.txt (text/plain), 2.00 KB, created by
Johan Bergström
on 2012-09-20 15:47:28 UTC
(
hide
)
Description:
copyfile.sql
Filename:
MIME Type:
Creator:
Johan Bergström
Created:
2012-09-20 15:47:28 UTC
Size:
2.00 KB
patch
obsolete
>CREATE OR REPLACE DIRECTORY "RECFILES" AS '/u03/CIFS/OUT/REC'; > >set serveroutput on >DECLARE > v_exists BOOLEAN; > v_length NUMBER; > v_blocksize NUMBER; >BEGIN > UTL_FILE.FCOPY('RECFILES', 'RecFile_local.xml', 'RECFILES', 'RecFile.xml.tst'); > UTL_FILE.FGETATTR('RECFILES', 'RecFile_local.xml', v_exists, v_length, v_blocksize); > IF v_exists THEN > dbms_output.put_line('Source Length is: '||v_length); > dbms_output.put_line('Source Block size is: '||v_blocksize); > ELSE > dbms_output.put_line('File not found.'); > END IF; > UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml.tst', v_exists, v_length, v_blocksize); > IF v_exists THEN > dbms_output.put_line('Copy Length is: '||v_length); > dbms_output.put_line('Copy Block size is: '||v_blocksize); > ELSE > dbms_output.put_line('File not found.'); > END IF; >END; >/ > >killed after 2 hours... > >------------------------------------------------------------------------------------------- > >CREATE OR REPLACE DIRECTORY "RECFILES" AS '/tmp'; > >set serveroutput on >DECLARE > v_exists BOOLEAN; > v_length NUMBER; > v_blocksize NUMBER; >BEGIN > UTL_FILE.FCOPY('RECFILES', 'RecFile.xml', 'RECFILES', 'RecFile.xml.tst'); > UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml', v_exists, v_length, v_blocksize); > IF v_exists THEN > dbms_output.put_line('Source Length is: '||v_length); > dbms_output.put_line('Source Block size is: '||v_blocksize); > ELSE > dbms_output.put_line('File not found.'); > END IF; > UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml.tst', v_exists, v_length, v_blocksize); > IF v_exists THEN > dbms_output.put_line('Copy Length is: '||v_length); > dbms_output.put_line('Copy Block size is: '||v_blocksize); > ELSE > dbms_output.put_line('File not found.'); > END IF; >END; >/ > >Source Length is: 462984557 >Source Block size is: 4096 >Copy Length is: 462984557 >Copy Block size is: 4096 > >PL/SQL procedure successfully completed. > >Elapsed: 00:00:48.36 > >Local filesystem ~ 48 seconds.
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 859131
: 614966