Sql Loader - 2 rows/block - whats happening

  • From: BN <bnsarma@xxxxxxxxx>
  • To: oracle_L_list <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jun 2007 15:51:30 -0400

Greetings


OS- AIX 5.2.0.0

Oracle:

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE    9.2.0.6.0       Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production


One Partitioned Table, SqlLoader Direct  Load is putting only 2 rows/block,
not sure whats happening?

Tablespace Details, LMTS Unfoirm sized, 100Mb

Name      Type      Extent Man Size_M          Used_M        Used %
LARGEST
--------- --------- ---------- --------------- ------------- -------
----------
WETBS     PERMANENT LOCAL            3,072.000      3072.000  100.00


TABLE_NAME                       NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE
AVG_ROW_LEN NUM_FREELIST_BLOCKS PAR
------------------------------ ---------- ---------- ------------ ----------
----------- ------------------- ---
ST_BDMS_VOL_EXTRACT                775255     384000            0
0         150                   0 YES


select 775255/384000 from dual;

775255/384000
-------------
  2.01889323

3 GB gone for 775, 255 rows,  Dropped and re-created the table with just one
partition and loaded the data,
same issue.

Regards & Thanks
BN

--
Regards & Thanks
BN

Other related posts:

  • » Sql Loader - 2 rows/block - whats happening