Sept 2 ’07

I got following email from ubTools. I had a chance to try itrprof and iStatsPack tools from developed by Danisment Gazi Unal, which are very successful for evaluating the trace files. I also had a chance to take Oracle Performance Tuning Bootcamp course from Mr. Unal.

Dear Members,

ubTools is pleased to announce a new product: ubSQL.

ubSQL is a utiliy which unloads Oracle data to text format; runs DML/DDL statements.

Why ubSQL ?


* C-based utiliy.
* Multi-threaded utility. N threads fetch data; N threads process fetched data; N threads write processed data to disks.
* Uses Oracle Call Interface (OCI), which is the lowest documented layer to access Oracle.
* Uses Operating System Kernel Calls directly in many unload operations without needing a library overhead.
* Multiple sessions can unload different parts of a table at the same time.
* Oracle data can be unloaded to multiple output files.
* Array Fetching is used in unload operations.

Creating SQL*Loader Control File

Creating SQL*Loader control file is possible.

Output File Types

Regular and Named Pipes are supported.

Bypassing Oracle SGA

Reading Oracle data directly from disks without using Oracle SGA is currently under development.

Supported Oracle Versions

Oracle 9i and onwards are supported.




  1. deryaoktay
    November 15, 2007 at 7:00 am

    Do you know about Oracle VM? It is exciting that Oracle see the virtulization trend.

    Oracle 11g took off, now releases on several platforms, AIX, HPUX, Linux, Solaris, Windows 32/64…

  2. pei
    August 21, 2011 at 8:37 am

    hello ,i’m a junior dba ,i hope that i can learn more oracle database knowledge from here..

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!


Welcome to the world of Oracle with me....


News and reviews from the world of gadgets, gear, apps and the web is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: