Hi,

I am trying to fetch data through publisher channel from database view
keeping the subscriber channel disable. I checked NetIQ by default
provide the following type of query which ends with Order by clause.

SELECT A.PK_FIELD1, A.FIELD_2,..,A.FIELD_N FROM VIEW_NAME A ORDER BY
A.PK_FIELD1 ASC

But the its take indefinite time to response and getting time out.can we
customized the query any of following format

1. SELECT A.PK_FIELD1, A.FIELD_2,..,A.FIELD_N FROM VIEW_NAME A

2. Executing following query prior to NetIQ default query

ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT='BINARY_CI';


Thanks
Joydeep Mukherjee


--
joydeep9j
------------------------------------------------------------------------
joydeep9j's Profile: https://forums.netiq.com/member.php?userid=4754
View this thread: https://forums.netiq.com/showthread.php?t=56653