Re: QS for oracle DBA working on SAP R3 system

Thanks you all for those good suggestions!

Christine

In article <mKUV2.1900$Ed5.59_at_news-reader.bt.net>,   "Kevin A Lewis" <KevinALewis_at_Hotmail.com> wrote:
> I agree with John. The only exceptions I would make are for Besoke Tables
> built by yourselves. You could get into all kinds of problem bypassing the
> supported SAP Batch Input.
>
> There are however a few SAP-R3 options you could explore. Try search the SAP
> documentation under Batch Input or Data Load. I can;t remember the
> references offhand but there are about 3 basic options available.
>
> The other thing you could do at the Oracle level is tune for large data
> loads. (spread the IO, ensure the SGA and PGAs are performing well. At the
> SAP level you could check the number of processes available for update and
> concurrency of this operation.
>
> Regards
>
> --
> Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <Kevin.Lewis_at_BOCMPAULS.co.uk>
>
> The views expressed herein by the author of this document
> are not necessarily those of BOCM PAULS Ltd.
> John Higgins <JH33378_at_deere.com> wrote in message
> news:3727BFBD.8DF00EF4_at_deere.com...
> > Of course you can.
> >
> > However !!!
> >
> > SQL*Loader does none of the checking that is built into the ABAP
> transactions.
> > And, since SAP puts all of its integrity checking into the ABAP programs
> (no
> > RDBMS foreign keys), you might load "orphans". Not to mention SAP's pool
> and
> > cluster tables (no, these are NOT Oracle clusters). You (nor me) would
> know how
> > to build the control statement to get SQL*Loader to work on these.
> >
> > In other words, I would not do it.
> >
> > By the way, the redo logs probably need to be increased to 200MB
> >
> > christinezhao_at_hotmail.com wrote:
> >
> > > Hi All,
> > >
> > > We are loading huge data to our oracle database with SAP R3 on top of
> it. We
> > > are using ABAP programming to load those data. it creates 20 M redo log
> very
> > > 3- 5 mins. We are running brbackup to clean it to tape. I am just
> wondering
> > > can I use SQL*loader direct path to load data to SAP database? Can I do
> > > anything in oracle side to speed up loading and also being accepted by
> SAP?
> > >
> > > Thanks a lot!
> > > --
> > > Christine Zhao
> > >
> > > -----------== Posted via Deja News, The Discussion Network ==----------
> > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
>

--
Christine Zhao

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 07:58:28 CDT