【 使用环境 】测试环境
【 使用版本 】3.2.4 for oracle版本
【问题描述】des_serviceorder表本身有千万条记录，select count(*) from des_serviceorder;报错
obclient [GISTAR]> ANALYZE TABLE des_serviceorder COMPUTE STATISTICS;
ORA-00600: internal error code, arguments: -4012, Timeout
obclient [GISTAR]> SHOW PARAMETERS LIKE ‘ob_trx_timeout’;
Empty set (0.006 sec)
obclient [GISTAR]>
obclient [GISTAR]>
obclient [GISTAR]> select count() from des_serviceorder;
ORA-00600: internal error code, arguments: -4012, Timeout
obclient [GISTAR]> select count() from des_serviceorder where rownum<10;
±---------+
| COUNT(*) |
±---------+
| 9 |
±---------+
1 row in set (0.003 sec)
obclient [GISTAR]> desc des_serviceorder;
±-----------------±-------------±-----±----±--------±------+
| FIELD | TYPE | NULL | KEY | DEFAULT | EXTRA |
±-----------------±-------------±-----±----±--------±------+
| SERVICEORDERID | VARCHAR2(50) | NO | NULL | NULL | NULL |
| SOTYPEID | NUMBER(6) | YES | NULL | NULL | NULL |
| SOTYPENAME | VARCHAR2(32) | YES | NULL | NULL | NULL |
| REQUESTID | VARCHAR2(50) | YES | NULL | NULL | NULL |
| GENERATETIME | DATE | YES | NULL | NULL | NULL |
| STATUS | NUMBER(6) | YES | NULL | NULL | NULL |
| ISEXCEPTION | NUMBER(1) | YES | NULL | 0 | NULL |
| REASSIGNTYPE | NUMBER(6) | YES | NULL | 0 | NULL |
| REGIONID | VARCHAR2(10) | YES | NULL | NULL | NULL |
| COMPLETIONSTATUS | NUMBER(1) | YES | NULL | 0 | NULL |
| ISREASSIGN | NUMBER(1) | YES | NULL | 0 | NULL |
| CHECKORDERID | VARCHAR2(50) | YES | NULL | NULL | NULL |
| ORDERID | VARCHAR2(50) | YES | NULL | NULL | NULL |
| COMPLETETIME | DATE | YES | NULL | NULL | NULL |
| RESOURCETYPE | VARCHAR2(4) | YES | NULL | NULL | NULL |
| SUSPEND_FLAG | NUMBER(6) | YES | NULL | NULL | NULL |
±-----------------±-------------±-----±----±--------±------+
16 rows in set (0.001 sec)
obclient [GISTAR]> SET GLOBAL ob_query_timeout = 1000000000;
Query OK, 0 rows affected (0.001 sec)
obclient [GISTAR]> select count(*) from des_serviceorder;
ORA-00600: internal error code, arguments: -4012, Timeout
obclient [GISTAR]>
请问如何解决？
