案例学习Oracle错误:ORA 00600
原文:ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:
1.timeouts
2.file corruption
3.failed data checks in memory
4.hardware, memory, or I/O errors
5.incorrectly restored files
The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.
Action Report this error to Oracle Customer Support after gathering the following information:
1.events that led up to the error
2.the operations that were attempted that led to the error
3.the conditions of the operating system and databases at the time of the error
4.any unusual circumstances that occurred before receiving the ORA-00600 message
5.contents of any trace files generated by the error
6.the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times.
Be aware of the history of errors that occurred before this internal error.
ORACLE ORA-00600错误的阐述
ORACLE ORA-00600错误不是你的程序错误.是ORACLE内部的错误,一般来说,大部分的ORA-00600错误均是由ORACLE软件的bug所导致,因此对于这样的错误需要及时联系ORACLE技术支持工程师.对于这种类型的ORA-00600错误,一个简单的处理方式就是打补丁,将数据库升级到一个稳定的版本,另外建议屏蔽某些ORACLE特性,诸如MTS(MultiThread Server)。但也有部分错误是由数据库内部的表或索引(包括应用的)结构被损坏所或其他原因所造成。
1:ORA-600[12700]表示执行SQL语句时对应的某些实体(表/索引)损坏;该错误的处理方法为:
修改init$ORACLE_SID.ora文件,增加如下几行:
event = “10210 trace name context forever level 10”
event = “10211 trace name context f
相关文档:
指标名称 指标描述 指标范围 指标单位
1.关于实例效率(Instance Efficiency Percentages)的性能指标
缓冲区未等待率
(Buffer Nowait %) 指在缓冲区中获取Buffer的未等待比率。 该指标的值应接近100%,如果该值较低,则可能要增大buffer cache。 %
Redo缓冲区未等待率
(Redo NoWait %) 指在Redo缓冲区获取Buffer的 ......
先来了解下几个英文的简称,在以后经常会见到。
对象关系数据库管理系统(Object Relational Database Management System,简称ORDBMS)
关系数据库管理系统(Relational Database Management System,简称RDBMS)
数据库管理系统(Database Management System,简称DBMS)
结构化查询语言(Structured Query Langua ......
想在Linux系统把Oralce安装好,确实是个不小的挑战,最起码的,首先要对Linux系统有所了解,不说多的,简单的一些配置文件和常用命令总要知道,要不真不知道如何下手。今天按书本的启示,和网上别人写的文章还有Oralce官方的帮助感觉都对我帮助甚微啊。。。不过感觉最后还是在QQ群和百度的帮助下,当然书本和那些文章都起到 ......
创建表的语法
-创建表格语法:
create table 表名(
字段名1 字段类型(长度) 是否为空,
字段名2 字段类型 是否为空
);
-增加主键
alter table 表名 add constraint 主键名 primary key (字段名1);
-增加外键:
alter table 表名
  ......