Re: Performance issue while loading large amount of data

From: Noons <nsouto_at_optusnet.com.au.nospam>
Date: 11 Jan 2003 10:10:57 GMT
Message-ID: <Xns9300D5391A93Dmineminemine@210.49.20.254>

"EP" <ep_at_plusnet.pl> wrote in news:avopck$e4h$1_at_news.tpi.pl and I quote:

> I am supposed to load large amount of data from SQL scripts and I have been
> wondering what is the best option:
> -frequent commits and no rollback segments growth
> -one commit and large rollback segments
> What do you suggest ?

In-between.

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Sat Jan 11 2003 - 04:10:57 CST

This message: [ Message body ]
Next message: David Sharples: "Re: Locally Managed Tablespaces ... again!!!"
Previous message: Noons: "Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data Warehouse & OLAP application"
In reply to: EP: "Performance issue while loading large amount of data"
Next in thread: Wanderley: "Re: Performance issue while loading large amount of data"
Reply: Wanderley: "Re: Performance issue while loading large amount of data"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US