当前位置:网站首页>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
边栏推荐
- Utilisation de GDB
- Search ideas and cases of large amount of Oracle redo log
- Oracle modify default temporary tablespace
- PG library checks the name
- Django::Did you install mysqlclient?
- Using open to open a file in JNI returns a - 1 problem
- [multi screen interaction] realize dual multi screen display II: startactivity mode
- PG SQL intercepts the string to the specified character position
- Oracle lock table query and unlocking method
- Apache seatunnel 2.1.0 deployment and stepping on the pit
猜你喜欢
SAP ui5 application development tutorial 72 - trial version of animation effect setting of SAP ui5 page routing
Ding ~ your scholarship has arrived! C certified enterprise scholarship list released
QT调用外部程序
浅谈js正则之test方法bug篇
UEFI learning 01-arm aarch64 compilation, armplatformpripeicore (SEC)
[point cloud series] full revolutionary geometric features
Dolphin scheduler source package Src tar. GZ decompression problem
为什么从事云原生开发需要学习容器技术
【视频】线性回归中的贝叶斯推断与R语言预测工人工资数据|数据分享
Usereducer basic usage
随机推荐
[machine learning] Note 4. KNN + cross validation
交叉碳市场和 Web3 以实现再生变革
kettle庖丁解牛第16篇之输入组件周边讲解
[point cloud series] learning representations and generative models for 3D point clouds
Dolphin scheduler integrates Flink task pit records
At the same time, the problems of height collapse and outer margin overlap are solved
[point cloud series] neural opportunity point cloud (NOPC)
[Video] Bayesian inference in linear regression and R language prediction of workers' wage data | data sharing
SAP UI5 应用开发教程之七十二 - SAP UI5 页面路由的动画效果设置
联想拯救者Y9000X 2020
ARGB transparency conversion
Processbuilder tool class
Detailed explanation of Oracle tablespace table partition and query method of Oracle table partition
Dolphin scheduler source package Src tar. GZ decompression problem
[point cloud series] so net: self organizing network for point cloud analysis
爱可可AI前沿推介 (4.23)
Core concepts of microservice architecture
Longitude and latitude position of provincial capitals in China
Double pointer instrument panel reading (I)
Dolphin scheduler configuring dataX pit records