Sql Loader - 2 rows/block - whats happening

From: BN <bnsarma_at_gmail.com>
Date: Tue, 26 Jun 2007 15:51:30 -0400
Message-ID: <61292a9d0706261251k3551b43bl73330bea46b75d51@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 26 2007 - 14:51:30 CDT