Oracle Corporation (ORCL) Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Technology Stocks : Oracle Corporation (ORCL)

ORCL 193.76

+0.6%

Jan 6 3:59 PM EST

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Lizzie Tudor who wrote (4733)	12/23/1997 9:11:00 AM
From: Michael Olin	of 19080

Michelle, I don't want to turn this thread into a tech support line but... There are several things to look at with SQL*Loader on the client. If you have already looked at these, just ignore me. If you are using replace (throw out the old data and use what you're loading), truncate the table first. This eliminates tons of rollback segment activity when the old records are deleted. Check the size of the array buffer being used. The default on clients is smaller than the default on servers. Bump up the array size. Also check the commit interval. For the number of records you're loading it needs to be a whole lot more than the default of 64. If you are doing replaces, consider presorting the records and using a direct path load. The first and third suggestions really shouldn't make that much of a difference if you are getting acceptable performance on the server. The array and commit parameters can make a big difference on the client side. There are a whole lot of sites on the web with technical tips, etc. regarding Oracle. We have links to a dozen or so on the New York Oracle Users Group site at nyoug.org -Michael

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next