ITPub博客

linux monitor tablespace1.create database link先赋予create database link的权限SQL> grant create database link to mon;Grant succeeded.SQL> create database link yangxu connect to system identified by xxxxx_123 using 'yangxu';Database link created.2.create tableSQL> create table mon_t...

rollup(a,b,c)=group by a,b,c + group by a,b + group by a + group by nullrollup(a,b)=group a,b + group by a + group by nullSQL> select * from emp;     EMPNO ENAME                          JOB       &n...

oracle6机器是收集filesystem的机器，访问其他的linux服务器按照monitor cpu&mem的顺序，配置/etc/hosts,创建user,配置ssh1.创建tableTable created.SQL> create table mon_filesystem  2  (hostname varchar2(20),    3   filesystem varchar2(100),  4   allbytes  var...

oracle6机器是收集filesystem的机器，访问其他的linux服务器按照monitor cpu&mem的顺序，配置/etc/hosts,创建user,配置ssh1.创建tableTable created.SQL> create table mon_filesystem  2  (hostname varchar2(20),    3   filesystem varchar2(100),  4   allbytes  var...

oracle6机器是收集cpu&mem的机器，访问其他的linux服务器1.在/etc/hosts添加IP和hostname对应关系[root@oracle6 ~]# more /etc/hosts127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.l...

oracle6机器是收集cpu&mem的机器，访问其他的linux服务器1.在/etc/hosts添加IP和hostname对应关系[root@oracle6 ~]# more /etc/hosts127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.l...

Linux SSH 报Warning "Pseudo-terminal will not be allocated because stdin is not a terminal."SSH已经配置好了MEMTOTAL=`echo "cat /proc/meminfo | grep -i memtotal" | ssh mon@$LINE`执行上面这个命令的时候报如下warning：Pseudo-terminal will not be allocated because stdin is not a terminal.加入参...

Linux SSH配置了免密码登录，登录时还要输入密码[mon@oracle6 ~]$ ll .sshls: cannot access .ssh: No such file or directory[mon@oracle6 ~]$ ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/mon/.ssh/id_rsa): Created directory '/home/mon/.ssh'....

今天在执行如下SQL报了ORA-00979:not a group by expressionSELECT   aaaaa,bbbbb,ccccc,COUNT(*) QTY         FROM         (        select CASE WHEN to_char(a.updatettime,'HH24')>='22' THEN  to_char(a.updatettime +1,'YYYYM...

对linux df 输出内容进行格式化添加/usr/bin/dfb文件[root@oracle6 ~]# more /usr/bin/dfb{if (split($0, f) == 1) {  getline  split($0, rest)  for (i = 1; i

linux df输出有时候会发生换行[root@oracle6 ~]# dfFilesystem           1K-blocks      Used Available Use% Mounted on/dev/mapper/vg_oracle6-lv_root                      51606140  47447392   1537...

BIOS-->Bootloader-->Kernel-->init-->service-->login-->bashpowermt display dev=allHP-UX HA相关命令cmhaltnode XXXXX008    --停止(halt)nodecmrunnode -v XXXXX008  --激活nodecmviewcl      查看cluster状态cmviewcl -v   查看cluster详细状态cmrunpkg -v -n XXXXX0...

记录一下NVL,NVL2,NULLIF,COALESCE,DECADE,CASE 函数的意思：nvl(v1,v2)     if v1 is null then result=v2 else result=v1 endnvl2(v1,v2,v3) if v1 is null then result=v3 else result=v2 endnullif(v1,v2)  if v1=v2 then result=null else result=v1 endcoalesce(v1,v2,.....vn) return the first...

PL/SQL Developer设置时间格式用的PL/SQL Developer 版本是 Version 8.0.3.1510，可能每个版本的不一样在Tools --> perferences --> user interfaces --> nls options 里可以设置date & time的格式.date 有三个选项      --user defined      --windows format    &n...

HP Unix bdf显示不在同一行,一行记录分成两行显示[root->/]# bdfFilesystem          kbytes    used   avail %used Mounted on/dev/vg00/lvol4    35848192 27096088 8683928   76% //dev/vg00/lvol1    1835008  636952 1188752   35% ...

HP Unix server rlogin,remsh之间建立信任关系假设有unix server hosta,hostb1.需要在hosta,hostb两台server上加入对方的hostname & iphosta [/]# more /etc/hosts | grep -i hostb192.168.1.100    hostbhostb [/]# more /etc/hosts | grep -i hosta192.168.1.101    hosta2.在.rhosts文件...

SQL> drop table tt purge;表已删除。SQL> create table tt(id varchar2(20));表已创建。SQL> insert into tt values('1');已创建 1 行。SQL> insert into tt values('40');已创建 1 行。SQL> insert into tt values('5');已创建 1 行。SQL> insert into tt values('9');已创建 1 行。...

SQL> drop table tt purge;表已删除。SQL> create table tt(id varchar2(20));表已创建。SQL> insert into tt values('1');已创建 1 行。SQL> insert into tt values('40');已创建 1 行。SQL> insert into tt values('5');已创建 1 行。SQL> insert into tt values('9');已创建 1 行。...

xxxxxx [/tmp/test]# more roundto#!/bin/bashlet x=$1let y=$2let z=$x/$ylet m=$x%$ylet n=$y/2if [ $m -lt $n ]; then   let re=$zelse   let re=$z+1fiecho $re  xxxxx [/tmp/test]# ./roundto 15 44

如下是Oracle10g Monitor Current SQL Running Script:select vs.LAST_CALL_ET elapsed_time,vs.SID,vs.SERIAL#,vp.SPID,vs.USERNAME,vs.OSUSER,vs.MACHINE,vs.EVENT,vs.PROGRAM,vs.MODULE,vs.SQL_ID,vsql.SQL_TEXT,vsql.SQL_FULLTEXT,vs.SCHEMANAME,vs.STATUS,vsql.EXECUTIONS,(select value from v$sesstat wher...