I try to query a very big oracle table (~50M records),
When I use sequential access the job works fine , but very slow.
When I try to use parallel access the job just hangs with no explenation.
I tried to add some APT env variables for debug but still I get ho clue for the reason the job does not progress.
The table is indexed and partitioned so the same sql works ok in sqlplus
My SQL is:
Code: Select all
SELECT CUSTOMER_ID, AGREEMENT_ID, CYCLE_MONTH,
to_char(LAST_EVENT_DATE,'YYYYMMDDHH24MISS') LAST_EVENT_DATE,
(ORIG_UPLINK_VOLUME+ORIG_DOWNLINK_VOLUME) VOLUME
FROM #P_OU_OWNER#.OU_PERFORMANCE
WHERE ROLE='RT' AND CYCLE_MONTH in (#P_CYCLE_MONTH#);
Any idea why it does not work or how can I check it ?
Juliya