Perform multiple insert queries on a single table?

[dbmsuser7]

Is it possible to perform multiple insert queries on a single table?

I need to populate a humongous table, and it would be faster to do it parallelized. The inserts are done as

Code: Select all

INSERT...SELECT

There shouldn't be any "conflicts" because I plan on inserting into separate partitions in parallel.

I just tried it, and it seemed to work (with two queries). I'm wondering about this because there was an entry in the

Code: Select all

LOCKS

table (but not two entries). Furthermore, when I was monitoring resources, the two queries were taking about the same amount of RAM, but for one instead of the query being displayed in the

Code: Select all

v_monitor.transactions.description

field, I saw something like (truncated here):

Code: Select all

SELECT quote_ident(table_schema), quote_ident(table_name), 'system', table_desc....

TIA,

S