navicat 同一句 SQL 语句以前执行没问题，现在报 OCI_INVALID_HANDLE
資深大佬 : sandman511 8
一句 sql 执行 50 秒后报错 Error – OCI_INVALID_HANDLE
instantclient 应该是正常的 因为执行其他 sql 语句没问题
这句 sql 以前也执行过 没问题。
select AAA,BBB,CCC from TTT WHERE AAA IN ('X1','X2') AND DDD IN ('Y1','Y2','Y3','Y4') AND ( BBB BETWEEN to_date('2017-05-14 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2017-05-18 00:00:00','yyyy-mm-dd hh24:mi:ss') OR BBB BETWEEN to_date('2018-03-30 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2018-04-01 00:00:00','yyyy-mm-dd hh24:mi:ss') OR BBB BETWEEN to_date('2018-11-24 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2018-11-25 00:00:00','yyyy-mm-dd hh24:mi:ss') ) ORDER BY AAA,BBB 大佬有話說 (5)