Question Regarding Sqlldr Parameter For Pin_rel (Doc ID 760763.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 19-Jan-2012***
***Checked for relevance on 01-Jul-2013***


Goal

Look at the below example of a rel.pinlog and notice that that it takes 1 minute to load one file (200K records).  Does this mean PIN_REL locks the tables for 1 minute? There are about 2-3 million records every day being loaded by REL.

Debug 12/25/08 7:19:05:0080 PM ( 1230200345080 ) T:Sqlldr Thread 1 REL RELSqlLoaderThread 1:Server02:UnknownProgramName:0:Sqlldr Thread 1:0:1230200345:0
sqlldr direct=true streamsize=5000000 readsize=10000000 userid=pin13/pin13@pindb
data=/share/cdr01/BK/blk/pre_spt_GCDR_20081225191636.out.bc.event_t.blk
bad=/share/cdr01/BK/blk/pre_spt_GCDR_20081225191636.out.bc.event_t.blk.bad
discard=/share/cdr01/BK/blk/pre_spt_GCDR_20081225191636.out.bc.event_t.blk.discard
log=/share/cdr01/BK/blk/pre_spt_GCDR_20081225191636.out.bc.event_t.blk.log
control=/share/cdr01/BK/blk/pre_spt_GCDR_20081225191636.out.bc.event_t.ctl
Debug 12/25/08 7:19:05:0081 PM ( 1230200345081 ) T:Sqlldr Thread 1 REL RELSqlLoaderThread 1:Server02:UnknownProgramName:0:Sqlldr Thread 1:0:1230200345:0
Starting the database load utility for thread Sqlldr Thread 1...
----
Debug 12/25/08 7:20:19:0228 PM ( 1230200419228 ) T:Sqlldr Thread 1 REL RELSqlLoaderThread 1:Server02:UnknownProgramName:0:Sqlldr Thread 1:0:1230200345:0
The database load utility for thread Sqlldr Thread 1 completed with return code: 0

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms