dependencies for the bulk inserting process

Question

HI All

There are lot of dependencies for the bulk inserting process in oracle like

Tablespace
Redo Log Size
Server size
PCT FREE
PCT USED
Log Switches
Undo Retention
Undo Tablespace Size.

Undo Size = Undo Retention * DB Block Size * Undo Block Per Sec

undo Block Per Sec
SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
      "UNDO_BLOCK_PER_SEC"
  FROM v$undostat;
 

INITIAL 
INITRANS for the table from 1 to 5.
PCTINCREASE - 0
FREELISTS parameter.  You want to have it set to AT LEAST the number of processes that you believe will be CONCURRENTLY inserting into your table.
multiple database writers (db_writers init.ora parameter),
 
PCT_USED is most important if records will ever be deleted from this table.  If you don't plan to allow deletes, then set PCT_USED to a high value (like 80 or 90) but the total of PCT_FREE + PCT_USED must be less than or equal to 100.

Locally Managed / Dictionery Managed.


can any one suggest me for sql server...?

please


Regards
Yogananda

Answer 1

Yogananda,

I'm afraid this is not Service Broker related question.

Thanks,
Pawel

Answer 2

Hi,

It's not the queue for bulk insert topic. But here's the link which shares some information on bulk insert in SQLServer,

http://msdn.microsoft.com/en-us/library/ms188365.aspx

You may go to data access related forums so that you can get better help.

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.