ITPub博客

select dbf.tablespace_name,dbf.file_name, gvf.PHYRDS,  gvf.PHYWRTS, round(gvf.phyrds / (gvf.PHYRDS + gvf.PHYWRTS),4)*100  || ' / '||  (1-round(gvf.phyrds / (gvf.PHYRDS + gvf.PHYWRTS),4))*100 "Phyrd/phywt Ratio"  ,       round((gvf.PHYRDS + gvf.PHYWR...

SELECT u.username,       SUM(DECODE(o.object_type, 'INDEX', 1)) "INDEX",       SUM(DECODE(o.object_type, 'TABLE', 1)) "TABLE",       SUM(DECODE(o.object_type, 'CLUSTER', 1)) "CLUSTER",   &nbs...

Check user's informationselect u.username,u.account_status,u.created,u.expiry_date,u.default_tablespace,u.temporary_tablespace,sum(decode(sid,null,0,1)) "current logon",sum(decode(status,null,0,'INACTIVE',0,1)) "current active",round(sum(sysdate-logon_time)*24*60*60 / sum(decode(sid,null,0,1)),0) ...

select y.name,y.bytes/1024/1024 total_mb,(x.total_blocks*y.block_size)/1024/1024 used_mb,(y.bytes-x.total_blocks*y.block_size)/1024/1024 free_mb,round((x.total_blocks*y.block_size)/y.bytes,4)*100 pctfrom v$sort_segment x,(select b.name,sum(a.bytes) bytes,a.block_size from v$tempfile a,v$tablespac...

set linesize 160col ksppinm format a40col ksppstvl format a30col ksppdesc format a190SELECT ksppinm, ksppstvl, ksppdesc  FROM x$ksppi x, x$ksppcv y WHERE x.indx = y.indx   AND ksppinm like '%&value%';

set pagesize 100set timing onselect * from(select x.tablespace_name,x.contents,x.status,x.extent_management,x.all_bytes/1024/1024 "ALL_SIZE(MB)",y.free_bytes/1024/1024 "FREE_SIZE(MB)",(x.all_bytes-y.free_bytes)/1024/1024 "USED_SIZE(MB)",round((x.all_bytes-y.free_bytes)/x.all_bytes,4)*100 USAGEf...

select count(*) count from v$session where status='ACTIVE';

col spid format a10col inst_id format a7col owner format a15col object_name format a20col machine format a30col program format a20select pr.spid,se.inst_id,se.sid,se.serial#,ob.owner,ob.object_name,se.osuser,se.machine,se.terminal,se.program,gvl1.ctime,(select count(*)-1 from gv$lock  w...

1.直接修改文件[root@rhel7 ~]# ifconfig -aens33: flags=4163  mtu 1500        inet 192.168.32.129  netmask 255.255.255.0  broadcast 192.168.32.255        inet6 fe80::d378:75a6:dfff:...

HP Unix ftp无法登陆，查看/etc/inetd.conf文件.[root@xxxxxx:/xxxxx#] more /etc/inetd.confftp          stream tcp6 nowait root /usr/lbin/ftpd     ftpd -l -alogin        stream tcp6 nowait root /usr/l...

AIX:    1,获得AIX主机连接的光纤设备:        # lsdev -Cc adapter -S a | grep fcs         fcs0     Available 09-08 FC Adapter         fcs1     ...

HP Unix server User登录时执行命令特别慢，使用的shell 是csh和其它user对比后，发现TERM   设置不对。然后再 .login 文件中加入  setenv TERM vt100 后，执行命令正常。

添加了append提示，会对test1表加上6级TM锁，此时该表上的其他DML事物会被全部阻塞sessioin 1:SQL> insert /*+append*/ into test1 select * from test;session 2:SQL> insert /*+append*/ into test1 select * from test;SQL> select inst_id,sid,serial#,machine from gv$session where username='SCOTT';&nbsp...

python installwindows安装下载好了软件后，下一步下一步安装就好了.如下是linux安装.[root@mysql ~]# wget https://www.python.org/ftp/python/3.6.0/Python-3.6.0.tar.xz[root@mysql ~]# tar -xvf Python-3.6.0.tar.xz[root@mysql Python-3.6.0]# ./configure --prefix=/usr/local/python36[root@mysql Python-...

如下是统计oracle11g listener.log中IP的几种方法cat listener.log | awk -F"HOST=" '{print $3}' | awk -F")" '{print $1}' | sort | uniq -c      (89s)cat listener.log | awk -F"HOST=" '{print $3}' | awk -F")" '{a[$1]++}END{for(i in a) printf "%-30s%.f\n",i,a[i]}'   (68...

SQL> create table part_tab1(id int,owner varchar2(30),name varchar2(30),type varchar2(30),created date)  2  partition by range(id)  3  (partition p1 values less than(10000) tablespace users,  4   partition p2 values less than(50000) tablespace users,  5&nb...

1.先安装vsftpd 软件吧,使用yum安装或者把vsftpdru软件复制过来后rpm -i安装[root@mysql ~]# rpm -qa | grep vsftpdvsftpd-2.2.2-12.el6_5.1.i6862.vsftpd.conf配置文件[root@mysql ~]# cd /etc/vsftpd/[root@mysql vsftpd]# lltotal 24-rw-r--r--  1 root root    7 Mar  2 21:15 chroo...

[20120918]理解v$sql的exact_matching_signature与force_matching_signature.txt    理解v$sql的exact_matching_signature与force_matching_signature,对于使用sql profile以及SPM有重要意义,自己对...

Oracle常用脚本记录,方便以后使用:lock:check lock infocol spid format a10col inst_id format a7col owner format a15col object_name format a20col machine format a30col program format a20select pr.spid,se.inst_id,se.sid,se.serial#,ob.owner,ob.object_name,se.osuser,se.machine,se.terminal,se.progr...

SQL> select count(*) from test;  COUNT(*)----------  28835328Elapsed: 00:00:09.48SQL> select count(*) from test1;  COUNT(*)----------  28833280Elapsed: 00:00:09.20SQL> select id from test minus select id from test1;2048 rows selected.Execution Plan-----------...