- 博客(12)
- 资源 (15)
- 收藏
- 关注
原创 前滚和回滚的区别 .
http://blog.csdn.net/haiross/article/details/17003543http://www.itpub.net/thread-1713569-3-1.html经典论坛
2015-10-31 17:50:13 828
原创 oracle9
查看SQL历史执行信息:SELECT SQL_ST.SQL_ID,PLAN_HASH_VALUE,TO_CHAR(ST.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD HH24:MI:SS') RUN_DATE,ST.SNAP_ID,ST.INSTANCE_NUMBER INS, SX.SQL_TEXT,ROUND(SQL_ST.ELAPSED_TIME_DE
2015-10-26 19:08:12 724
原创 oracle 8
锁定查询系列...----------------------------------------Q: 如何查询哪些进程相互锁定?A: 执行以下SQL语句set pages 800set lines 150column blocking format a30column blocked format a30select 'INST_ID:'||l1.inst_id|
2015-10-20 19:34:39 494
原创 oracle 7
expdp/impdp 杀导出导入后台进程:--查询后台进程:SET lines 200COL owner_name FORMAT a10;COL job_name FORMAT a20COL state FORMAT a11COL operation LIKE stateCOL job_mode LIKE state-- locate Data Pump
2015-10-20 19:34:02 477
原创 oracle 7
查看磁盘空间&磁盘监控脚本select name,usable_file_mb/1024 from v$asm_diskgroup;select 'Diskgroup capacity alert:' alert_reason,i.instance_name,substr(d.name,1,10),d.total_mb,d.free_mb,d.state,d.USABLE_FILE_M
2015-10-20 19:32:34 421
原创 oracle 6
监控事务回滚进度:select n.USED_UBLK*x.VALUE/1024/1024 ,s.* from gv$transaction n, gv$session s, v$parameter x where n.INST_ID = s.INST_ID and n.ADDR = s.TADDR and x.name = 'db_bl
2015-10-20 19:29:26 383
原创 oracle 4
临时表空间使用率:set pages 800set lines 150set feedback off--Total UsedSELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size)/1024/1024 mb_used, D.
2015-10-20 19:28:01 331
原创 oracle 3
查询表空间大小:SELECT A.TABLESPACE_NAME, A.FILENUMBER, ROUND(A.TBSCURRENTSIZEINMB/1024, 2) TOTAL_SIZE_G, ROUND(B.SEGMENTSIZEINMB/1024, 2) USED_SIZE_G, ROUND((A.TBSCURRENTSIZ
2015-10-20 19:27:13 458
原创 oracle 2
停止OS重启时候自动启动CRS(root):crsctl disable crs[root@XXX]# ./crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled.停止CRS(root):/data/oracle/app/11.2.0/grid/bin/crs
2015-10-20 19:25:28 427
原创 oracle 命令1
RMAN恢复进度:set numwidth 30;set pagesize 50000;set lines 200;alter session set nls_date_format = 'DD-MON-RRRR HH24:MI:SS';select status,checkpoint_change#,checkpoint_time, resetlogs_change#, re
2015-10-14 22:15:49 591
原创 删除归档
一、直接使用RMAN删除archivelogRMAN>crosscheck archivelog all;RMAN>delete noprompt archivelog until time 'sysdate-3';删除三天前的归档日志,不经过提示、直接删除。或者RMAN>delete archivelog all completed before 'sysdate-3';
2015-10-13 19:18:16 520
jpct-ae 绘制的桌子(Android 3D)
2012-05-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人