Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are there general guidelines one can use to improve the gateway performance?

April 26, 2017Gateway guidelines PERFORMANCE

0

10 Posted

Are there general guidelines one can use to improve the gateway performance?

1 Answer

0

Posted

The Gateways are not tunable. To troubleshoot gateway performance issues, turn on gateway tracing (HS_FDS_TRACE_LEVEL= debug). Observe the trace file for things like: the entire SQL statement in question is being sent across to the non-Oracle system or the entire table is being fetched Application users can then re-write their SQL such that most of the processing is done at non-Oracle systems and only the relevant data is fetched across the network. Post processing at Oracle is probably the most common cause of performance degradation.