ITPub博客

 --查询表空间使用率select a.tablespace_name,total,free,total-free used from( select tablespace_name,sum(bytes)/1024/1024 total from dba_data_files   group by tablespace_name) a,( select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space   group by tablespace_...

oracle 11.2.0.4安装 vncserveryum whatprovides "*/xhost"xorg-x11-server-utils-7.7-14.el6.x86_64 : X.Org X11 X server utilitiesRepo        : baseMatched from:Filename    : /usr/bin/xhostyum install xorg-x11-server-utils-7.7-14.el6.x86_64 -yyum install xorg-x11-...

Oracle11GU4介质FTP下载地址Oracle11.2.0.4 Linux 64bit FTP下载地址server:ftp://104.236.52.210/p13390677_112040_Linux-x86-64_1of7.zip    ftp://104.236.52.210/p13390677_112040_Linux-x86-64_2of7.zipclient:ftp://104.236.52.210/p13390677_112040_Linux-x86-64_3of7.zip...

查看在sysaux表空间中数据比较大的表：select * from (select segment_name,PARTITION_NAME,segment_type,bytes/1024/1024 from dba_segments where tablespace_name='SYSAUX'  order by 4 desc)  where  rownum<=10;查看要删除的表：select table_name, num_rows from dba_tables where table_name in ...

[oracle@virtdb52 database]$ ./runInstaller Starting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB.   Actual 50216 MB    PassedChecking swap space: must be greater than 150 MB.   Actual 3980 MB    PassedChecking monitor: must be...

创建Latch快照表CREATE TABLE snap_latch asSELECT 0 snap_id, sysdate snap_date, a.* FROM V$LATCH a; ALTER TABLE snap_latch add   (constraint snap_filestat primary key (snap_id, name));定期insert数据INSERT INTO snap_latchSELECT 1, sysdate, a.* FROM V$LATCH a;查询LatchSE...

high undo tablespace and enq: U.S. - ContentionThese days encounter an error, I do not know if it's wrong, because there is no error, but the operating table in a sudden just 2 minutes suddenly reduced, causing the software to restart. To view the alert log there is no error, but in th...

AWR报告：Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait ClassDB CPU 13.8K ...

 Oracle维护索引1.重建索引alter index index_name1 rebuild;2.重建索引并转移到别的表空间alter index index_name1 rebuild tablespace other_tablespace;  --这个表空间要首先创建3.修改索引的一些参数设置alter index index_name rebuild pctfree 30 storage(next 100k);4.自动为索引分...

http://blog.csdn.net/seulk_q/article/details/42612393环境：oracle11g rac 11.2.0.1centos 6.7vmware 10OS配置：关闭selinuxsetenforce 0   vim /etc/selinux/configSELINUX=disabled关闭防火墙service iptables stopchkconfig iptables off网络配置：ifconfig -adb1:生成密钥/...

存储迁移方案：1.在线迁移表数据测试数据expdp webdata/webdata2 directory=DIR_DP dumpfile=spcode.dmp tables=spcodecreate tablespace webdata datafile '+DATADG/shanghai/datafile/webdata.dbf' size 2096m;create user webdata identified by webdata2 default tablespace webdata;grant dba to webdata;c...

索引碎片：由于index_stats只能存储最近一行数据，analyze index后查询index_stats必须在同一session内，否则查询index_stats无记录，我们回到之前碎片很严重的索引ind_obj_id需要重新analyze一下：anlyze index　锁定indexexecute    DBMS_STATS.GATHER_TABLE_STATS('cccc','SELL',CASCADE => TRUE); &n...

How to display values of binds variablesset line 150 pagesize 80col name for a50col value_string for a10select name, position, value_string, to_char(last_captured,'mm/dd/yyyy hh24:mi:ss') from v$sql_bind_capture where sql_id = '4hkxkwjm5964k';

addm报告：@?/rdbms/admin/addmrptawr报告：@?/rdbms/admin/awrrptawr比较报告：@?/rdbms/admin/awrddrpt.sqlash报告：@?/rdbms/admin/ashrptRAC 环境 AWR 信息的对比展现@?/rdbms/admin/spawrrac.sqloracle11g 实时监控v$session   SQL_EXEC_START:SQL执行的开始时间SQL_EXEC_ID：执...

Oracle用户对象权导入到excelset line 1000        set pagesize 0       set feedback off      set heading off       set trimspool on     set trims on         set echo off;　　　　 ...

对于在SQL中有&字符的可以通过解决：set define off;对于在SQL中有'字符的可以通过ACSII来解决：update customer c set c.greet = 'Hope's' where c.greetings is null and exists(select v.id from voucher v where v.id = c.voucherid and v.orderno = '92640036' );解决：update customer c set ...

http://blog.itpub.net/28602568/viewspace-1396081/本文主要分享Oracle DBA 工作中常用的一些sql1、Oracle 查询每天执行慢的SQL2、Oracle 查询锁之间的依赖关系3、Oracle 查找锁之间依赖关系的最源头SID 4、Oracle 查询各个 “表空间/数据文件” 的...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;">&nbsp;<a href="http://blog.itpub.net/22664653/viewspace-691135/" style="text-decoration:none;color:#9C2423;font-...

系统全局查看：15分钟内最重要的等待事件：

--统计会话情况：SELECT 'TOTAL SESSIONS NUM IS: '||COUNT(*) FROM v$sessionUNION ALLSELECT 'ACTIVE SESSIONS NUM IS: '||COUNT(*) FROM v$session WHERE status ='ACTIVE'UNION ALLSELECT 'USER SESSIONS NUM IS : '||COUNT(*) FROM V$SESSION WHERE TYPE='USER'