Good evening, I need your help please
Is there any way to fix this Query, whenecer this query it takes too long about 2 hours and fail on error ORA-02399:
Im not a DBA, just i received a work order to run this query, but i would like to dive deeper a liitle bit what is going on with this query:
ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';
Alter session set cursor_sharing = similar;
SET PAGES 0;
SET lines 100;
SET colsep '|' ;
spo rubens_sdp7.lst
select /*+FULL(a) PARALLEL(a,12) */ TO_CHAR(R1_NUMSISDN)R1_NUMSISDN, R1_CDSDP,R1_MAESTADO
from schemay.R1_LOCATION_DATA a
where R1_MAESTADO='10';
spo off;
I appreciate your help in advanced