DBA Tools |
|
Writing professional DBA tools and scripts for better DBA life |
|
Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
Performance test of Oracle datapump, exp and SQLULDR2.
I did a performance comparation of Oracle datapump, export and SQLULDR2 on a linux machine, the CPUs' frequency is 3G HZ. When running exp and SQLULDR2, the relative process take almost 100% of one CPU, so for data...
SQLULDR2, how to unload data to screen (STDOUT)?
What's STDOUT, it's the standard output device for a computer, usually it meas the screen. Somebody suggested me to add this feature to ociuldr few months ago, but I did not understand the requirements at that time. Now...
Specify table name for SQLULDR2 (SQL*Unloader) text unloading
SQLULDR2 can run as fast as Oracle exp utility with default command line options. If you increase the buffer to 1 megabyte for exp, it's still 15% faster than SQLULDR2. And may be much faster in direct mode...
sqluldr2 (OCI 8 based) is comming with one megabyte LOB support
One of my friends need to unload CLOB values to flat file, he tried OCI 7 based ociuldr and sqluldr, both failed. For LOB columns, OCI 7 does have some prolems, it reports "ORA-32255" errors when retrieving NULL...
The parfile option of newer text unload utility (sqluldr)
There are lots of command line options for squldr utility, it's not convenient for us to specify lots options value in command line, so I intorduced a new command line option "parfile" to save options value in a...
sqluldr, enterprise edition text unloading utility
Ociuldr is a good utility for text unloading, and many people are running it, to avoid compatibilities. I named the new version of text unloading utility as SQL*UnLoader (sqluldr), new version is 25% faster than the old version....
Text Export and Import Performance Testing
Since ociuldr get 25% speed improve, I want to know the performance difference with oracle export utility. I tested them on my notebook, oracle server and client in the same host, 8 columns (including VARCHAR, NUMBER and DATE...
25%+ performance improve for text unloading with ociuldr
I compared the unload speed of ociuldr and exp utilities, it seemd that ociuldr just has 50% speed compare to exp conventional mehtod, and had no idea of tuning it. After I introduced a buffer layer into it,...
Export data to fixed length text file with ociuldr
Sqlldr is much faster for fixed legnth text file, so someone suggest me to add this feature in ociuldr utiltiy, now it supported. When you use a space char as the field separator, it will generate fixed-length text...
Fast Oracle text unload speed with ociuldr by Alibaba
Free Oracle text unload utility (ociuldr) was used to extract Oracle data from OLTP system and then load them into their OLAP system by alibaba company (Taobao). They get a really fast unload speed these days. 0 rows...
Choosing right separators when unload (export) rows to text file
I am moving some data by ociuldr with the following field and record option. ociuldr ... field=0x07 record=0x06 ... I think it will work well, but actually not, there are rows rejected when loading with sqlldr....
How to pass parameters to your program in Shell script.
I wrote some OCI program and compiled them into 32 bit executable on 64 bit Solaris machine. So I need to set the proper Oracle library path to get it work. I wrote a shell script to set...
The LONG RAW data type support of text unload (export) utility
Now you can use ociuldr to move data with LONG RAW type. Just the same as LONG type, the "long=" option define the maximum length ociuldr will read. You may need to set the proper value of this...
Make some changes to the text unload utility -- ociuldr
I made few changes to this free utility, a new option "mode=" is introduced to change the load mode, there are four different modes in sqlldr. INSERT: Load data into empty table, this is the default mode. APPEND:...
Migrate data from US7ASCII database to UTF8 database
Some old databases are created with US7ASCII character set, when the client NLS_LANG setting was the same with database character set, Oracle will not do any conversion, so the client was able to store Chinese into the database....
The return (exit) code of ociuldr text unload utility
About half years ago, someone told me to add this, because he want to get more control of ociuldr utility in his shell script. I was afraid of change any code at that time, so just left him...
Unload LOBs to OS files or upload OS files to LOBs in Oracle
Oracle CLOB and BLOB data types can be used to store long text or large images, provide better performance compare to the LONG and LONG RAW data types for row accessing. However it's not easy to manipulate them...
Generate SQL Loader control file when unloading with ociuldr
Oracle's SQL Loader (sqlldr) can be used to load rows in text file into database tables. But sqlldr need a control file to specify how to interpret the text file format, including the column (field) separator, the record...
High performance for Oracle text unload or export with ociuldr
ociuldr (Source) is a free utility used to unload Oracle rows to text file, which can be used to prepare data for data warehouse, or do the data migration from Oracle to other databases, or moving data between...
How to unload or export rows as text file, excel CSV file, or excel xls file?
When export oracle data to different database platform, text file is always a good choice and may be the only choice, if they cannot connect directly. And some time I was required to provide some rows in excel...
Personal Information
| Name | Fangxin Lou |
| Job | Oracle DBA |
| Loc | Shanghai China (+08:00) |
| Skype | anysql |
| MSN | anysql©live.com |
| AIM | loufangxin |
| anysql©126.com anysql©yahoo.com |