-
编辑 删除
self lock on library cache pin
SQL> select * from v$version;BANNER----------------------------------------------------------------------------------------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4...
-
编辑 删除
handle parse fail
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS ...
-
编辑 删除
Bug 4991675
隐含参数_trace_kqlidp可以定位procedure,function等对象的失效原因, 在11.2.04上需要先patch 4991675[oracle@node1 4991675]$ opatch lsinvOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. All rights reserved.Oracle Home : /oracle/app/o...
-
编辑 删除
max row number of rowid
在extended ROWID里, 最后两个字节(16bit)表示row number, 从这个角度来说最大的row number是65535, 但是实际上最大的row number是32767,这可以从两个角度理解:1.最大的block size 是32k, 所以最大的row number不可能超过327672.用dbms_rowid.rowid_create(..., row_number=>32768)生成的rowid是无效的SQL> selec...
-
编辑 删除
From 11G listener log is opened on every write
1.10.2.0.5total 0lrwx------ 1 oracle oinstall 64 Dec 3 18:04 9 -> socket:[19702]lrwx------ 1 oracle oinstall 64 Dec 3 18:04 8 -> socket:[19701]l-wx------ 1 oracle oinstall 64 Dec 3 18:04 7 -> pipe:[19698]lr-x------ 1 oracle oinstall 64 Dec 3 18:04 6 -> /opt/ora10g/produc...
-
编辑 删除
adaptive log file sync
看看polling方式下系统调用情况SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ...
-
编辑 删除
event 10261 and pga
event 10261 可以作为临时处理ora-4030错误的一个手段[oracle@node1 bdump]$ oerr ora 1026110261, 00000, "Limit the size of the PGA heap"// *Cause: the limit is one kilobyte times the level of the event. If the// pga grows bigger than this signal...
-
编辑 删除
trigger on clob
SCOTT @ db1 >select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2.0.5.0 - ProductionCORE 10.2.0.5.0 ProductionTNS for Linux: V...
-
编辑 删除
case语句中比较null
case语句有两种:Simple CASE和Searched CASESearched CASE可以用来比较nullSQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 -...
-
编辑 删除
11g里创建手工sample schemas
如果建数据时没有选择建sample schemas，可以用以下步骤手工创建:SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionC...
