ygdmario-CSDN博客

原创 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

原创 ue-不加载之前打开的文件

烦人的玩意！

2013-01-24 14:51:15 4021 1

翻译 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

gordon的专栏