ITPub博客

1. 重要的等待事件1-1. db file scattered read (数据文件离散读取)与全表扫描或快速全索引扫描有关一般是没有创建索引或没有合适的索引归类于 UserI/O 等待1-2. db file sequential read (数据文件顺序读取)与读取索引块或通过索引读取数据块有关归类于 UserI/O 等待1-3. direct path read/write (直接路径读写...

-- 10046 事件说明-- 是对 sql_trace 功能的增强-- level 1 -- 等价于 sql_trace-- level 4 -- 等价于 1 + 绑定值-- level 8 -- 等价于 1 + 等待跟踪-- level 12 -- 等价于 1 + 4 + 8-- 全局设置-- 对所有用户进程和后台进程有效-- 在参数文件中增加event="10046 trace name context forever,level 12"-- 当前...

1. 将 vmstat 输出为 csv 格式$ vmstat 1 | tr -s ' ' ','$ vmstat 1 | sed 's/  */,/g'$ vmstat 1 >> tmp.txt$ cat tmp.txt | sed 's/  */,/g' | sed 's/^,//'2. vmstat 输出时间$ vmstat 1 | awk '{print strftime("%H:%M:%S"), $0}'3. vmstat [间隔]第一行是目前为止的平均值====================...

1. 正常输出$ cat /etc/passwd$ awk '{ print }' /etc/passwd$ awk '{ print $0 }' /etc/passwd2. 输出 /etc/passwd 个空行或 test 行$ awk '{ print "" }' /etc/passwd$ awk '{ print "test" }' /etc/passwd3. 输出格式化$ awk -F ":" '{ print $1 " - " $3 }' /etc/passwd$ awk -F ":" '{printf "%s - %s \n",...

[:upper:] [ A - Z ][:lower:] [ a - z ][:digit:] [ 0 - 9 ][:alnum:] [ 0 - 9 a - z A-Z][:space:] 空格或tab键[:alpha:] [ a - z A - Z ]1. tr 命令1-1. 变换文件名for f in $*do  mv $f `echo $f | tr "[:upper:]" "[:lower:]"`done2. awk 命令2-1. 变换文件名ls | awk '{printf("mv %s %s\n", $0...

================================================================================1. 打印$ echo `date '+%Y-%m-%d %H:%M:%S'`2012-03-21 21:49:472. 赋值给变量VAR=`date '+%Y-%m-%d %H:%M:%S'`================================================================================X. 格式化参数%H - hh24 (00....

1. $RANDOM循环内调用时, 产生相同结果#!/bin/bashfunction random () {    MATRIX="0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz~!@#$%^&*()_+="    LENGTH=$1; LENGTH=${LENGTH:-10} # length, default length is 10    while [ ${n:=1} -le $L...

set verify offselect    a.name,    b.value V,    to_char(b.value-&V,'999,999,999,999') difffrom    v$statname a,    v$mystat bwhere    a.statistic# = b.statistic# and    lower(a.name) l...

set verify offcolumn value new_val Vcolumn value format 999,999,999,999define S="&1"set autotrace offselect    a.name,    b.value valuefrom    v$statname a,    v$mystat b where    a.statistic# = b.statistic#...

-- 专用服务器模式的连接下 -- user_dump_dest-- 共享服务器模式的连接下 -- background_dump_dest-- 9iR1 中 无需实例名-- 可以设置 trace 标识符go@DEMO> alter session set tracefile_identifier = 'Look_For_Me';go@DEMO> select name, value from v$parameter where name = 'tracefile_identifier';NAME &...

-- 执行用户必须具有查看DBA View的相关权限create or replace procedure show_space2( p_segname_1 in varchar2,p_space in varchar2 default 'auto',p_type_1 in varchar2 default 'table' ,p_analyzed in varchar2 default 'n',p_owner_1 in varchar2 default user)asp_segname varchar2(100);p_type varchar2...

column tbs_name format a30select    a.tablespace_name TBS_NAME,    round(b.total/1024/1024) "TOTAL(M)",    round((b.total-a.free)/1024/1024) "USED(M)",    round(a.free/1024/1024) "FREE(M)",    round((b.total-a.free)/b.t...

select    owner,    sum(bytes)/1024/1024 as "SIZE(M)",    sum(blocks) as "TOTAL_BLOCKS",    sum(extents) as "TOTAL_EXTENTS"from    dba_segmentsgroup by ownerhaving owner=upper('&user')/

1 指定表约束查询column owner format a10column table_name format a20column column_name format a20column constraint_name format a20column constraint_type format a20select    a.owner,    a.table_name,    b.column_name,    a.constra...

select    name,    round(space_limit/1024/1024/1024,2) "LIMIT(G)",    round(space_used/1024/1024/1024,2) "USED(G)",    round(space_reclaimable/1024/1024,2) "RECL(M)",    number_of_filesfrom    v$recovery...

column columns format a30 word_wrappedcolumn tablename format a15 word_wrappedcolumn constraint_name format a15 word_wrappedselect    table_name,    constraint_name,    cname1 || nvl2(cname2,',' || cname2,null) ||     &nbs...

1.column name format a30column value format a20column describ format a40select    x.ksppinm name,    y.ksppstvl value,    x.ksppdesc describfrom    sys.x$ksppi x,    sys.x$ksppcv ywhere    x.inst_id...

select    a.value commits,    b.value rollbacks,    to_char(b.value * 100/ (a.value + b.value), '90.99') || '%' rollbacks_ratefrom(    select name, value    from v$sysstat where name = 'user commits') a,( &nbs...

set linesize 200 pagesize 1400;SELECT    r.segment_name,    r.owner,    r.tablespace_name,    r.status,    r.initial_extent/1024 "INITIAL_EXTENT(K)",    r.next_extent/1024 "NEXT_EXTENT(K)",  &...

column file_name format a50select    tablespace_name,    file_id,    file_name,    round(bytes/1024/1024) "SIZE(M)"from    dba_data_filesunion allselect    tablespace_name,    file_id...