当前位置:网站首页>Ora-600 encountered in Oracle environment [qkacon: fjswrwo]
Ora-600 encountered in Oracle environment [qkacon: fjswrwo]
2022-04-23 13:43:00 【Not dizzy yet】
In the near future , An error is reported in the database environment of a user ORA-00600: internal error code, arguments: [qkacon:FJswrwo], [3]. about ORA-00600 Report errors , stay MOS The last query is related to a BUG The description is more consistent with .ORA-600 [qkacon:FJswrwo] Using CONNECT BY (Doc ID 1070636.1).
The document mentions the way of patching or modifying implicit parameters to deal with ; The business needs to be stopped when patching , Greater impact ;
Tried to modify the implicit parameters , No error will be reported in this case , The application system returns to normal . The relevant information is as follows :
ORA-00600: internal error code, arguments: [qkacon:FJswrwo], [3], [], [], [], [], [], [], [], [], [], []
The partial call stack may contain:
kgeasnmierr qkacon qkaqkn qkadrv qkadrv opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8
CAUSE
Bug 9105678 CONNECT BY QUERY FAILED WITH ORA-600 [QKACON:FJSWRWO]
This occurs when running a query which has a connect-by view and contains() function in the outer query
blocks of the view.
SOLUTION
To implement solution please do the following:
1. Install Patch 9105678 if available for your platform and DB version
2. Use the workaround:
alter session set "_optimizer_connect_by_cost_based" = false;
3. This bug is fixed in 12.1.
版权声明
本文为[Not dizzy yet]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230601579549.html
边栏推荐
- Detailed explanation and usage of with function in SQL
- Riscv MMU overview
- Explanation of input components in Chapter 16
- [Journal Conference Series] IEEE series template download guide
- Test the time required for Oracle library to create an index with 7 million data in a common way
- Oracle and MySQL batch query all table names and table name comments under users
- Part 3: docker installing MySQL container (custom port)
- Handling of high usage of Oracle undo
- ARGB transparency conversion
- Set Jianyun x Feishu Shennuo to help the enterprise operation Department realize office automation
猜你喜欢
QT calling external program
Lpddr4 notes
Plato farm, a top-level metauniverse game, has made frequent positive moves recently
QT调用外部程序
Set Jianyun x Feishu Shennuo to help the enterprise operation Department realize office automation
聯想拯救者Y9000X 2020
SAP ui5 application development tutorial 72 - animation effect setting of SAP ui5 page routing
Stack protector under armcc / GCC
TIA博途中基於高速計數器觸發中斷OB40實現定點加工動作的具體方法示例
[barycentric coordinate interpolation, perspective correction interpolation] principle and usage opinions
随机推荐
Oracle defines self incrementing primary keys through triggers and sequences, and sets a scheduled task to insert a piece of data into the target table every second
Interface idempotency problem
GDB的使用
Oracle lock table query and unlocking method
Super 40W bonus pool waiting for you to fight! The second "Changsha bank Cup" Tencent yunqi innovation competition is hot!
[point cloud series] full revolutionary geometric features
Example of specific method for TIA to trigger interrupt ob40 based on high-speed counter to realize fixed-point machining action
sys. dbms_ scheduler. create_ Job creates scheduled tasks (more powerful and rich functions)
Antd design form verification
Detailed explanation and usage of with function in SQL
聯想拯救者Y9000X 2020
innobackupex增量备份
SAP UI5 应用开发教程之七十二 - SAP UI5 页面路由的动画效果设置试读版
Software test system integration project management engineer full truth simulation question (including answer and analysis)
NPM err code 500 solution
[point cloud series] multi view neural human rendering (NHR)
@Excellent you! CSDN College Club President Recruitment!
The interviewer dug a hole for me: how many concurrent TCP connections can a single server have?
Riscv MMU overview
Logstash数据处理服务的输入插件Input常见类型以及基本使用