Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ cursor_sharing induced error ORA-00600     - php security study (Linux)

- JavaScript function part (Programming)

- How to compile and install wxWidgets in Ubuntu / Debian / Linux Mint (Linux)

- SSH keys using login and password to log prohibited practice (Linux)

- Copy files between two Linux hosts (Linux)

- Linux disk virtualization (Linux)

- Oracle multi-table query optimization (Database)

- JBPM6 Tutorial - Fast Fun JBPM table (Linux)

- PHP loop reference caused strange problems (Programming)

- C data types is how it is supported by most computer systems (Programming)

- Install Oracle database error process of [INS-35172] (Database)

- Distributed transaction management Spring declarative transactions (Programming)

- pdf.js Tutorial (Linux)

- Linux Getting Started tutorial: build your own Vim (Linux)

- How to use the ftp tool to transfer files between Windows and Linux (Linux)

- C # using the HttpClient Note: Preheat the long connection (Programming)

- Ubuntu Gnome and Fedora 22 Gnome desktop, extended to achieve global menu (Linux)

- Install GAMIT / GLOBK 10.50 software under Ubuntu 14.04 (Linux)

- Math objects easily overlooked but very convenient method --JavaScript (Programming)

- Will Laravel become the most successful PHP framework? (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:      
 
- Disable unnecessary services under Linux (Linux)
- Using the Linux folder wc statistics number of lines of code for all files (including subdirectories) (Linux)
- Samhain: Powerful intrusion detection system under Linux (Linux)
- Findbugs installation documentation (Linux)
- OpenGL ES 3.0 vertex buffer (Programming)
- CentOS install SVN server configuration and automatically synchronized to the Web directory (Server)
- Linux server operating system security configuration (Linux)
- CentOS 6.4 OpenNebula installation (Linux)
- Linux Getting Started tutorial: XWindow what (Linux)
- Linux Command - ps: a snapshot of the current process (Linux)
- Android custom title bar (Programming)
- Linux how to prohibit the use of Ping command (Linux)
- Preliminary understanding of SELinux security management (Linux)
- Installation JDK 1.8 under CentOS7 (Linux)
- RPM package creation Getting Started (Linux)
- Ganglia Python plug-in the process of writing notes (Linux)
- Understand ASP.NET 5 running the command: DNVM, DNX, and DNU (Server)
- The Objects in JavaScript (Programming)
- Cacti installation deployment under CentOS 6.6 (Server)
- Linux, how to filter, split, and merge pcap file (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.