parallel option

[anagarur]

Hi!

We are doing a lot of inserts (heavy duty) into a table in oracle 8i. This is a stored procedure. The data is being sent (ie., the values for the columns) from a front-end Visual C++ program. We are trying to increase the performance. We are averaging about 65 records/sec insertion rate and would like to take it up as much as we can.

The table is partitioned - has 828 partitions. Tried doing direct insertion into a partition itself (by building the isnert statement dynamically) but its still slow.
Any ideas...What is the syntax for doing an insert to take advantage of the parallel server option.

insert into table emp parallel..... ???

Can anyone please help.

Thanks,
Aruna

[bkanti]

Try the hint /*+ APPEND */ in the insert statement.