Navigation
 
ubSQL

  • ubSQL is a utiliy which unloads Oracle data to text format; runs DML/DDL statements.
ubTools Suite 3.2.0 is available



February 11, 2008
ubTools Suite 3.2.0 is available. New features:

  • itrprof SQL Analyzer 6.2.4:

    • Overall Response Time Distribution section renamed to
      Top Statements Ordered by Response Time.
    • Top Statements Ordered by Service Time section added.
    • Top Statements Ordered by Wait Time section added.
    • Top Statements Ordered by Logical IO section added.
Why ubSQL

Fast


  • 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.