Does anyone who know the internal of the ofsrm executable how does it communicate with 10g database ?
From the ofsa manual, it seems using Net8. Is that right ? My question is not ask about running ofsrm from client. We execute the ofsrm on the same server as the 10g database located.
Our problem is : The ofsrm execute many insertion statements to the RES_DTL_xxxx table. We found 90% waits of "SQL*Net more data from client". From the trace file, there are less than 5% elsaped time for insertion.