Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ cursor_sharing induced error ORA-00600     - To install and deploy Apache under the CentOS (Server)

- Thinking in Java study notes - Generics (Programming)

- MongoDB replication instance (Database)

- Zabbix API and PHP configuration (Server)

- ASM Management - How to Rename diskgroup (Database)

- C language print various graphic (Programming)

- Modify MySQL character encoding under Linux (Database)

- SSH security note (Linux)

- TCP network communication Java Programming (Programming)

- To setup Cocos2dx project under Ubuntu (Linux)

- Normal start Lazarus 1.0.8 under Ubuntu (Linux)

- Shell script to crawl through AWR SQL Report Problems (Database)

- Modify Linux terminal prompt path length (Linux)

- Fedora 8 configured Heartbeat (Linux)

- Efficient running Linux virtual machine Six Tips (Linux)

- Redhat 5 prohibit IPv6 (Linux)

- JavaScript original values and complex values (Programming)

- Use Observium to monitor your network and servers (Server)

- Linux environment SSH login password instead of using the RSA Certificate (Linux)

- Using Python multithreaded mistakes summary (Programming)

 
         
  cursor_sharing induced error ORA-00600
     
  Add Date : 2018-11-21      
         
         
         
  Host: IBM S85
Main hardware: 6 CPU + 8GB memory
System: AIX5.2
Patch: ML04
Database: Oracle 9.2.0.4
Middleware: BEA Tuxedo 8.1
The system belongs to a new class oltp financial system, on-line performance before the stress tests show good results in the future on the line really good performance, but the log file every 10 minutes, it reported:
ORA-00600: internal error code, arguments: [736], [7], [0], [128], [128], [], [], []
At this critical juncture encounter bug, nnd on a really bad word.
And the company's customers regard the pressure as flash floods as flooded over, I explained that one side is normal, no fuss, while quickly gather information.

A hotel with a bad telephone line is still very unstable, and no place to vent one's anger.
Find something crazy, and soon I know the problem is because of their smart aleck, it had to raise domestic applications generally do not use bind variables problems caused by adding a parameter:

cursor_sharing = force
I used to use this argument are relatively normal, but thought that the oracle version is relatively high that more at ease, but why is this result can not be estimated to an update / insert statements triggered this bug. nnd

This application really a puzzle to me, trying to help it improve the efficiency point with the help of a given variable, the results do not appreciate to give me a ora600. . . . . .
I quickly put under pressure cursor_sharing = force commented by default cursor_sharing = exact

To solve the problem finally. But can not be reconciled, carefully rolled 9i document recommended cursor_sharing = similar

Haha, which under the best of both worlds, most of sql are used bind variables, ora-600 error is no longer reported.
[@ More @]
     
         
         
         
  More:      
 
- Use XtraBackup to MySQL database online incremental backup and recovery (Database)
- Linux scheduling summary (Linux)
- Oracle GoldenGate Installation and Configuration Tutorial Introduction (Database)
- Advanced Search Oracle study notes (Database)
- Install VLC player on Ubuntu 14.10 (Linux)
- Ubuntu 14.04 Configuring cuda-convnet (Linux)
- Java Graphics2D Paint (Programming)
- Under Ubuntu 15.04 installation JDK8 (Linux)
- Python decorators to learn and practice the actual usage scenarios (Programming)
- Introduction and bash history command to quickly call (Linux)
- Java memory-mapped file MappedByteBuffer (Programming)
- To install MySQL 5.6 binary packages under CentOS 6.4 64bit (Database)
- Realization of Linux operating system illegal IP censorship (Linux)
- Linux System Tutorial: Fix ImportError: No module named wxversion error (Linux)
- C ++, overloading, cover, hide (Programming)
- Ubuntu comes with gedit editor to add Markdown preview widget (Linux)
- MySQL how to export files with the date format (Database)
- Linux system Perl Lite netstat (Linux)
- Cygwin install Python MySQLdb (Linux)
- Linux / Centos anti CC attack script (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.