For anyone that may be interested, turing off tracing for your
heterogeneous service SIGNIFICANTLY improves performance. To do this
open the init<your_hs_name>.ora file in C:\oracle\ora92\hs and make
sure HS_FDS_TRACE_LEVEL = OFF. We had HS_FDS_TRACE_LEVEL = 4 in Oracle
8.1 and it didn't cause any problems. But when we upgraded to Oracle
9.2 we saw a staggering loss of performance with herterogeneous
services. Switching HS_FDS_TRACE_LEVEL from 4 to OFF reduced response
time by an order of magnitude.
Received on Wed Aug 23 2006 - 13:10:38 CDT
