Re: commit point reached

I think it may be the commit every 7 rows that is being perceived as the problem, rather than the messages themselves.

If so, you can increase the interval between commits by using the bindsize parameter. As it says in the manual ' in general you gain large improvements in peformance with each increase in the bind size array size up to 100 rows. The size (in bytes) of 100 rows is typically a good value to use.'

Alternatively you can specify the number of rows by using the options clause in the control file to indicate the number of rows to be loaded per commit.

HTH "TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:5k5dmucg8uj0kn3thl20qbsm576d0n1rgn_at_4ax.com...
>
> If you refuse to read, well..
>
> The command line should include SILENT=(FEEDBACK)
>
> It is in the manual, and if you want to use SqlLoader effectively, read
it...
>
> hmatijaca_at_yahoo.ca (Helena) wrote:
>
> >I know that, what I would like to know is the following
> >"I would like to know what Oracle parameters can be used to suppress
> >it,
> >since it looks as if the loader will be slow because it has to commits
> >every 7 rows (and there are 500K rows being loaded)"
> >
> >"Alan" <alan_remove_this_shein_at_erols.com> wrote in message
news:<ak3ggd$1fhbv2$1_at_ID-114862.news.dfncis.de>...
> >> With even a few seconds of research, you could find the answer
yourself. Why
> >> don't you try typing sqlldr at the command prompt and read the help
screen
> >> for starters... Hint: use a comma between keywords.
> >>
> >> "Helena" <hmatijaca_at_yahoo.ca> wrote in message
> >> news:c5a36d06.0208221150.6f9248fd_at_posting.google.com...
> >> > Hi there
> >> >
> >> > I was using sqldr in oracle 8170 on solaris and the file inserts
> >> > without any trouble but we are getting this messages at the end
> >> > Commit point reached - logical record count 12789
> >> > Commit point reached - logical record count 12796
> >> > Commit point reached - logical record count 12803
> >> > Commit point reached - logical record count 12810
> >> >
> >> > this is the table contents
> >> > ORACLE_HOME=/u01/app/oracle/product/8.1.7
> >> >
> >> > sqlldr userid=perfai/perfai@ DEVDB silent=header direct=no
> >> > errors=1 rows=10000 \
> >> >
> >> control=/products/acctinq/src_unix/loaders/lph_aiq_${table}_ldr.fmt
> >> > \
> >> > data=$PENDING_DIR/aiq.$table.insert \
> >> > log=aiq_$table.ctl.log \
> >> > bad=aiq_$table.ctl.bad
> >> >
> >> > can someone please tell me what to do, I don't want to get those
> >> > messages anymore "commit point reached"
> >> > Thanks
> >> > Helena
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Mon Aug 26 2002 - 08:09:19 CDT