Desing Suggestion ASAP

[diepa]

Hi to all,
I need some suggestions on the storage parameters for the following 2 tables.
Our application is an OLTP, with 80 users connected at the same time.
Our app. inserts data into 2 tables for 4 hours (400,000 rows for parent table, 1,200,000 for child table), after that, the users start to update several values over both tables for 14 hours for all the rows until all the rows are processed.
During that period, we have to run an export over all the processed rows and then delete the data.
I'm running oracle 8.1.7 over Windows NT.
My init.ora file is like:

db_files = 1024
open_cursors = 600 #previous 300 - 600
max_enabled_roles = 30
db_file_multiblock_read_count = 7
log_buffer = 131072 #previous 65536 - 262144 - 65536
db_block_buffers = 150000 #previous 148176 - 148000 - 166000 - 178815
shared_pool_size = 90112000 #Previous 103246208 - 113246208 - 134217728 - 180572800 - 200572800
large_pool_size = 0 #previous 24971520 - 14971520 - 26507520 - 36507520
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 400
optimizer_index_cost_adj = 30
parallel_min_servers = 2
query_rewrite_enabled = true
job_queue_processes = 5
job_queue_interval = 3600
log_archive_start = TRUE
db_block_size = 8192
compatible = 8.1.7.0.0 #previous value: 8.1.0
sort_area_size = 65536 #previous 65536
sort_area_retained_size = 65536 #previous 65536
db_block_lru_latches = 8
db_block_lru_statistics=FALSE #obsolete parameter
db_writer_processes = 4 #previous value: 1
session_cached_cursors=300
enqueue_resources = 4000
utl_file_dir = f:\FirstData\ExportFiles

And the desc of the tables are:

create table PARENT TABLE
(
DOCUMENTID NUMBER(10, 0) NOT NULL ,
FORMID NUMBER(10, 0) NOT NULL ,
INUSE NUMBER(10, 0) NOT NULL ,
IMAGEFILE VARCHAR2(256) NOT NULL ,
PRIORITY DATE NOT NULL ,
STATE NUMBER(6, 0) NOT NULL ,
SUBSTATE NUMBER(6, 0) ,
SLAVERIFICATION NUMBER(6, 0) ,
KEYINGCENTERID NUMBER(3, 0) ,
PROCESSINGDATE VARCHAR2(10) ,
AMOUNT NUMBER(20, 3) ,
ACCOUNTNUMBER VARCHAR2(16) ,
TRANSACTIONCODE VARCHAR2(16) ,
ABANUMBER VARCHAR2(16) ,
SERIALNUMBER VARCHAR2(16) ,
EXCEPTIONCODE VARCHAR2(2) ,
CYCLECODE NUMBER(4, 0) ,
IMPORTUID NUMBER(10, 0) ,
VERIFIERUID NUMBER(10, 0) DEFAULT NULL,
EXPORTERUID NUMBER(10, 0) ,
ARCHIVERUID NUMBER(10, 0) ,
PURGEDUID NUMBER(10, 0) ,
IMPORTDATE DATE ,
RECOGNIZEDDATE DATE ,
VERIFIEDDATE DATE ,
EXPORTDATE DATE ,
ARCHIVEDATE DATE ,
PURGEDDATE DATE ,
ERRORID NUMBER(10, 0) ,
LASTMODIFIED DATE NOT NULL ,
VIEWPRIORITY DATE ,
ITEMSEQUENCENUMBER VARCHAR2(9) ,
RECOGNITIONUID NUMBER(10, 0) )
pctfree 40
pctused 20
initrans 40
maxtrans 255
tablespace FLOW_DATA
NOLOGGING
storage (
initial 600M
next 60M
pctincrease 0
maxextents 2147483645
freelists 2
)
PARALLEL
/


create table CHILD
(
DOCUMENTID NUMBER(10, 0) NOT NULL ,
FIELDCODE NUMBER(5, 0) NOT NULL ,
FORMID NUMBER(10, 0) NOT NULL ,
VERIFIERUID NUMBER(10, 0) DEFAULT NULL,
PRIORITY DATE NOT NULL ,
STATE NUMBER(6, 0) NOT NULL ,
SUBSTATE NUMBER(6, 0) NOT NULL ,
IMAGEFILE VARCHAR2(256) NOT NULL ,
LEFTX NUMBER(6, 2) ,
UPPERY NUMBER(6, 2) ,
RIGHTX NUMBER(6, 2) ,
LOWERY NUMBER(6, 2) ,
PAGENUMBER NUMBER(3, 0) ,
RECOGNIZEDVALUE VARCHAR2(256) ,
RECOGNIZEDDATE DATE ,
ACTUALVALUE VARCHAR2(256) ,
ACTUALVALUEDATE DATE ,
LASTMODIFIED DATE NOT NULL ,
KEYINGCENTERID NUMBER(3, 0) ,
INUSE NUMBER(10, 0) NOT NULL ,
VIEWPRIORITY DATE ,
EXPORTDATE DATE ,
SLAVERIFICATION NUMBER(6, 0) ,
PROCESSINGDATE VARCHAR2(10) ,
CONFIDENCE NUMBER(4, 0) DEFAULT 0,
CHECKTYPE NUMBER(1, 0) DEFAULT 0,
VOCABCOUNT NUMBER(4, 0) )
pctfree 60
pctused 20
initrans 40
maxtrans 255
tablespace FLOW_DATA
NOLOGGING
storage (
initial 2000M
next 200M
pctincrease 0
maxextents 2147483645
freelists 2
)
PARALLEL
/
These tables have FK, indexes, etc, etc

With all these in mind, Are my parameters ok? Should I modify something?
My big concern is the concurrency of several users to perform updates.

We have seen bad performance when we export this data and the users are still working (we have to do the export during that period).
Any suggestion is really appreciated.
Thanks.