- 浏览: 263944 次
- 性别:
- 来自: 北京
最新评论
文章列表
Oralce RAC用到的技术:
1.ASM:Automatical Storage Management==>自动存储管理
2.CRS:Cluster Ready Service===>集群就绪服务
3.Cache Fusion==>缓存熔合
4.RAID==>Redundant Array of Independent Disk==>独立磁盘冗余阵列
5.HSI:===>High Speed Interconnect==>高速互联
6.OUI:Oracle Universal Installer
7.SSH==>RSA或者DSA
8.ASM L ...
数据库表的记录数为:
SQL> select count(*) from table_name t;
COUNT(*)
----------
6873
1、使用count(*)的统计结果:
SQL> alter session set nls_language = "American";
Session altered.
SQL> set timing on;
SQL> set autotrace on;
SQL> select a.document_id,count(*) from table_name a group ...
测试表结构:
SQL> desc can_do;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(9)
NAME VARCHAR2(20)
DEPART ...
1.chmod
2.umask
三位8进制数来表示
chmod和umask的修改的权限位是互补的。
比如:umask 022 对于chmod就是:755
755====>rwxr-xr-x
Similar to the numeric code for the chmod command, the three numbers that are used with umask are as follows.
第一个数字控制用户权限:The first digit controls user permissions
第二个数字控制组权限:The second controls group ...
SQL> explain plan for select a.object_id from docversion a,generic b where a.object_id = b.object_id;
Explained
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
----------------------------------- ...
select length(a.object_id),
a.object_id,
utl_raw.bit_and(a.object_id, '1111'),
utl_raw.length(a.object_id),
utl_raw.cast_to_number(a.object_id),
rawtohex(a.object_id)
from docversion a
where ro ...
Note:2009-1-15
Oracle必须为每对行源执行连接操作,连接的方法包括嵌套循环、排序合并、散列连接、笛卡尔积等。
1.嵌套循环连接的成本计算公式:
cost = access cost of A + (access cost of B * number of rows from A)
2.散列连接的成本计算公式:
cost = (access cost of A * number of hash partitions of B) + access cost of B
3.排序合并连接的成本计算公式:
cost = access cost of A + access cost of ...
Oracle's connection and session and process
1.process:connection断了,process也可以存在
2.session:仅当你connection时,才会保持session.
3.connection:"physical circuit",1个connection对应0个或者1个或者多个session
A connection is a physical circuit between you and the database. A connection might be
one of many types -- ...
1.showrev
查看系统Hostid: 24cc7225
Release: 5.9
Kernel architecture: i86pc
Application architecture: i386
Hardware provider: COMPAQ
Domain: sinomos.com
Kernel version: SunOS 5.9 Generic 112234-10 Nov 2003
showrev -p可以查看系统的安装的补丁
2、vmstat监视cpu
iostat监视磁盘
iostat -E ...
1、logic标签中嵌套java代码,如下:
<logic:equal name="list" property="statusInProcess" value="<%=PropertyFileReaderUtils.getInstance().getProperties(\"STATUS_IN_PROCESS_FOR_ESTIMATED_AND_PASSED\")%>">
评估通过
</logic:equal>
注意:如果用到双引号(英文状态的)“"”,则需要用反斜 ...
1、 问题其实就是你期望的东西和你体验的东西的差别。
2、 对于那些没有幽默感的人,帮助他们解决问题简直就是自寻烦恼。
3、 不要把他们的解决方法误认为是问题的定义。
4、 如果你太轻易地解决了他们的问题,他们永 ...
about div in javascript:
1.visibility:
objDiv.style.visibility="visible";
objDiv.style.visibility="hidden";
2.display:
objDiv.style.display="none";
objDiv.style.display="";
使用display和visibility都可以隐藏指定的区域,区别是,display隐藏后不会留空白,
而visibility则会在页面上留有空白。一般,用display的 ...
解决Struts,formfile下,上传文件时,文件名和表单其他属性项的值乱码的最终解决方案:
第一步:保证你的jsp的内容中的encoding为:<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
第二步:确认你的jsp页面另存为时的格式为"ANSI"
第三步:在你的action中加上
///////////begin///////
request.setCharacterEncoding("utf-8&quo ...
可以通过以下几个方面验证:
(1)、通过查看Apusic启动日志,jgroup的GMS提示信息及配置策略是否正确,如下:
2011-11-30 10:35:53 信息 [com.apusic.org.jgroups.JChannel] JGroups version: 2.6.1
2011-11-30 10:35:58 信息 [con.out]
-------------------------------------------------------
GMS: address is 192.168.36.205:58909
---------------------------- ...
0.=>source location at:\simple_app\java_code_fragment\com\vista
1.=>package com.vista;
2.compile location at:D:\simple_app\java_code_fragment
3.=>javac com/vista/ThreadDemo.java
4.=>java com/vista/ThreadDemo