2011年11月_jxzkin

翻译 Oracle DB Server内存划分参考

PGA_AGGREGATE_TARGET=Physical Memory*20% SGA_MAX_SIZE+PGA_AGGREGATE_TARGET= Physical Memory*80%

2011-11-30 11:34:48 548

翻译 X$KVIT

X$KVIT [K]ernel Layer Performance Layer [V] [I]nformation tables [T]ransitory Instance parameters select kvittag,kvitval,kvitdsc from x$kvit;

2011-11-29 13:22:17 9301

原创 trace events command

control file trace: alter session set events 'immediate trace name CONTROLF level10' /

2011-11-28 16:16:02 510

原创 Use profile to limit session's idle time

1 => 创建对应Profile: CREATE PROFILE KIN LIMIT IDLE_TIME 1; 2=> 查看Profile相关的信息: SELECT * FROM dba_profiles WHERE PROFILE = 'KIN'; 　 SELECT username, PROFILE FROM dba_users; 3 => 赋予U

2011-11-28 11:57:47 663

原创 Get SCN

SELECT DBMS_FLASHBACK.get_system_change_number FROM DUAL UNION SELECT checkpoint_change# FROM v$database UNION SELECT MAX (ktuxescnw * POWER (2, 32) + ktuxescnb) FROM x$ktuxe;--[K]er

2011-11-28 10:16:46 451

转载 ORA-18008

SOLUTION: ALTER TRIGGER MDSYS.sdo_st_syn_create DISABLE; CREATE USER outln IDENTIFIED BY outln DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE temp PROFILE DEFAULT ACCOUNT UNLOCK; GRANT RESOURCE

2011-11-25 14:49:12 558

转载 IIS Monitor Script

程序代码如下: {3a2a4e84-4c21-4981-ae10-3fda0d9b0f83} 0 5 IIS: WWW Server {06b94d9a-b15e-456e-a4ef-37c984a2cb4b} 0 5 IIS: Active Server Pages (ASP) {dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0 5 Universal L

2011-11-25 14:23:26 751

原创 MSSQLSERVER CAN NOT START AFTER ENABLE & DIABLE VIA

Resolution: 1. stop sql server 2. open "SQL Server Surface Area Configuration" and disable remote connection 3. start sql server 4. stop sql server 5. open "SQL Server Surface Area Configura

2011-11-24 08:15:39 566

原创 Oracle automatic stat job

select * from dba_scheduler_jobs; enable & diable this function: exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB'); exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB'); alter system set "_o

2011-11-16 10:47:57 646

原创 HP Wrranty Query

http://h20565.www2.hp.com/portal/site/hpsc/public/wc/home/

2011-11-15 15:53:55 514

SMP：是Symmetric Multi Processing的简称，意为对称多处理系统，内有许多紧耦合多处理器，这种系统的最大特点就是共享所有资源。另外与之相对立的标准是MPP (Massively Parallel Processing)，意为大规模并行处理系统，这样的系统是由许多松耦合处理单元组成的，要注意的是这里指的是处理单元而不是处理器。每个单元内的CPU都有自己私有的资源，如总线、内存

2011-11-14 09:44:40 590

原创 eygle's sqlplus script for generating the xls and html

set linesize 200 set term off verify off feedback off pagesize 999 set markup html on entmap ON spool on preformat off spool tables.xls @get_tables.sql spool off exit

2011-11-11 13:05:29 458

原创 logical standby database can not create database link

alter session disable guard; create database link; alter session enable guard;

2011-11-11 11:42:08 558

原创 linux can not umount 'device is busy'

fuser -m file or directory fuser -mvki file or directory.

2011-11-08 10:09:55 2613

KIN ORACLE