- 博客(13)
- 收藏
- 关注
原创 linux lock_sga
ora10 soft memlock 20000000ora10 hard memlock 20000000"/etc/security/limits.conf" 60L, 2079C written[root@redhat249 ~]# [root@redhat249 ~]# [root@redhat249 ~]# [root@redhat24
2014-04-23 15:08:14 500
转载 asm1
Is it recommended that we put the OCR/Voting Disks in Oracle ASM and, if so, is it preferable to create a separate disk group for them?With Oracle Grid Infrastructure 11g Release 2, it is recommende
2014-02-19 16:50:02 718
原创 windows 查看hba卡信息
服务器是dl380的机器 上面有2个hba卡,确定型号。1 下载fcinfo工具 http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17530 我的机器上已经有了 在c:\windows\syswow64\fcinfo.exe 执行结果为:There are 2 adapters
2013-09-22 15:45:49 9276
原创 oracle-时区
select dbtimezone from dual;select sessiontimezone from dual;alter database set time_zone='+10:00';
2013-03-13 10:40:45 456
翻译 11g-新特性-动态视图-v$sql_hint
从11.1 增加了新的动态视图 v$sql_hint;/* Name Null? Type ------------------------- -------- ------------ NAME VARCHAR2(64) SQL_FEATURE
2012-08-06 12:10:06 2240
转载 DDL With the WAIT Option (DDL_LOCK_TIMEOUT) in Oracle Database 11g Release 1
http://www.oracle-base.com/articles/11g/ddl-lock-timeout-11gr1.phpDDL With the WAIT Option (DDL_LOCK_TIMEOUT) in Oracle Database 11g Release 1DDL commands require exclusive locks on internal str
2012-07-23 18:00:06 408
转载 job failures =16后 job 会broken
Broken Jobs and the Job Queue [ID 103349.1] 修改时间 11-JUL-2012 类型 PROBLEM 状态 PUBLISHED ***Checked for relevance on 11-Jul-2012***NOTE:=====The discussed function
2012-07-18 14:47:20 1772
原创 32位2008 ora-12518 监听无法分发。
ORA-12518 / TNS-12518 Troubleshooting [ID 556428.1] 修改时间 30-MAR-2012 类型 PROBLEM 状态 MODERATED In this Document Symptoms Changes Cause Solution Referen
2012-07-17 12:09:37 714
原创 perfmon 的counter 含义描述
logical disk CounterDescriptionLogicalDisk\% Free SpaceReports the percentage of unallocated disk space to the total usable space on the logical volume. When calculat
2012-07-12 10:30:59 641
转载 转载微软的technet -Evaluating Memory and Cache Usage
http://technet.microsoft.com/library/Cc938590This topic has not yet been rated- Rate this topicUse the Performance console and other Microsoft® Windows® 2000 tools to assess available
2012-07-12 10:23:05 472
转载 Information On Installed Database Components and Schemas [ID 472937.1]
Information On Installed Database Components and Schemas [ID 472937.1]
2012-06-26 15:55:38 427
原创 Bug 10636231- High version count for INSERT .. RETURNING statements with reason INST_DRTLD_MISMATCH
数据库版本:11.2.0.2.0操作系统版本:windows 2008r2 64位问题表现:cpu利用率高。问题分析: 有6个进程活动其中5个在等待 latch :row cache objects 和1个library cache mutex 等待。 查询v$latchholder 没有查处holder,做systemstate dump
2012-06-26 15:07:46 897
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人