I have a table containing the following columns:
Id number primary key,
geom SDO_GEOMETRY

Firstly, I create the table and create the spatial index on the geom column.
Secondly, I insert 1 million rows into the table.

When I try to insert rows it performs very bad (around 12 seconds for 10,000 rows). For updates and deletes it performs worse.
This table should be available for users all the time and may be updated frequently.