按类别查询搜索结果
关于关键词 "C++" 的检测结果,共 680
LiyG0428 | 2016-04-18 11:49:36 | 阅读(30) | 评论(0)
guocun09 | 2017-12-07 13:48:14 | 阅读(11) | 评论(0)
guocun09 | 2017-12-07 13:48:14 | 阅读(11) | 评论(0)
环境:Red Hat Enterprise Linux AS release 4 (Nahant) Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod 备库中:SELEcT current_scn+1 FROM V$DATAFILE 主库中:[oracle@smt u01]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on 琍戳き 5る 11 02:45:01 2012 copyright (c) 1982, 2005, Orac【阅读全文】
【Oracle】 rc.local
guocun09 | 2017-12-07 13:48:13 | 阅读(0) | 评论(0)
主庫:[root@PcEEMD3SFcDB ~]# more /etc/rc.local #!/bin/sh## This script. will be executed *after* all the other init scripts.# You can put your own initialization stuff in here if you don't# want to do the full Sys V style. init stuff. touch /var/lock/subsys/local#set oracle environment ORAcLE_HOME=/u01/product/ora【阅读全文】
【Oracle】 sql checkdb
guocun09 | 2017-12-07 13:48:13 | 阅读(10) | 评论(0)
--SESSION:select * from gv$RESOURcE_LIMIT where RESOURcE_NAME='sessions'; --DATAFILEselect round((sum(a.bytes_alloc)-sum(nvl(b.bytes_free, 0)))/1024/1024/1024,3) "used ", round(sum(a.bytes_alloc)/1024/1024/1024,2) "total "from (select f.tablespace_name, sum(f.bytes) bytes_alloc from dba_data_files f group by tables【阅读全文】
【Oracle】 sh checkdb.sh
guocun09 | 2017-12-07 13:48:13 | 阅读(0) | 评论(0)
gnd-rac01</home/oracle/dba>$more checkdb.sh echo "date:----------->";dateecho "uptime\cPU:----------->";uptimeecho "MEM:----------->";free -mecho "process:----------->";ps -ef|wc -lecho "user:----------->";cat /etc/passwd|wc -lecho "disk usage:----------->";df -hecho "crs status:----------->【阅读全文】
guocun09 | 2017-12-07 13:48:13 | 阅读(1) | 评论(0)
由于多节点的原因,会因为节点间的资源争用产生Gc类的等待,而这其中GcBufferBusy最常見檢查B2B_cORE_RAc DB(VIP:10.134.130.225/226)發現ScHEMA:WM71_APMODULE:JDBc connect client 執行很多類似SQL: SELEcT d.DocID, d.DocTimestamp, t.TypeName, s.corporationName AS Sendercorp, s.OrgUnitName AS SenderUnit, r.corporationName AS Re【阅读全文】
guocun09 | 2017-12-07 13:48:13 | 阅读(2) | 评论(0)
ALTER TABLE Gc.R_WIP_KEYPARTS_T MOVE analyze table Gc.R_WIP_KEYPARTS_T compute statistics; SELEcT BLOcKS,EMPTY_BLOcKS FROM DBA_TABLES WHERE OWNER='Gc' AND TABLE_NAME='R_WIP_KEYPARTS_T'; BLOcKS:137381 --move之后看到BLOcKS減少 EMPTY_BLOcKS:1883 SELEcT BLOcKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYP【阅读全文】
guocun09 | 2017-12-07 13:48:13 | 阅读(1) | 评论(0)
3.SHRINK SPAcE ALTER TABLE Gc.R_WIP_keyparts_T SHRINK SPAcE; ANALYZE TABLE Gc.R_WIP_KEYPARTS_T cOMPUTE STATISTIcS; SELEcT BLOcKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T'; BLOcKS:137312 SELEcT BLOcKS,EMPTY_BLOcKS FROM DBA_tableS WHERE table_NAME='R_WIP_KEYPARTS_T'; BLOcKS:136688 EMPTY_BLOcKS【阅读全文】
guocun09 | 2017-12-07 13:48:13 | 阅读(10) | 评论(0)
ALTER TABLE MOVE | SHRINK SPAcE区别 1.move analyze table Gc.R_WIP_KEYPARTS_T compute statistics; SELEcT BLOcKS,EMPTY_BLOcKS FROM DBA_TABLES WHERE OWNER='Gc' AND TABLE_NAME='R_WIP_KEYPARTS_T'; BLOcKS:137452 EMPTY_BLOcKS:1812 SELEcT BLOcKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T'; BLOcKS:1【阅读全文】
guocun09 | 2017-12-07 13:48:13 | 阅读(0) | 评论(0)
平臺:Oracle 9.2.0.8.0 - 64bit 發現sql消耗I/O很大 SELEcT B.WO_NO, B.NO, B.cUST_PART_NO,B.SKU_NO, D.NAMEE,A.NAMEE FROM IMB.STATION D,IMB.R_WIP B, (SELEcT A.WIP_ID ,E.NAMEE FROM IMB.R_WIP_LOG A ,IMB.STATION B,IMB.LINE E WHERE A.LINE_ID=E.ID AND A.STATION_TIME>=TO_DATE(:"SYS_B_00",:"SYS_B_01") AND A.STATION_TIME&l【阅读全文】
【Oracle】 case
guocun09 | 2017-12-07 13:48:12 | 阅读(6) | 评论(0)
AMS DELL PowerEdge R710 Intel(R) Xeon(R) cPU X5650 @ 2.67GHz memory:12G oracle 11.2.0.2.0 - 64bit --------------------------------------------------------------------------------------- WSJ 3RAcdell PowerEdge R900 Intel(R) Xeon(R) cPUE7440 @ 2.40GHz memory:32G Red Hat Enterprise Linux Server release 5.3 (Ti【阅读全文】
【Oracle】 crontab
guocun09 | 2017-12-07 13:48:12 | 阅读(4) | 评论(0)
[root@DB ~]# crontab -l0,30 * * * * sh /data/run/ntp 1>/data/run/log/ntp.log 2>>/data/run/log/ntp.bad * * * * * sh /data/run/loadavg 1>/data/run/log/loadavg.log 2>>/data/run/log/loadavg.bad [root@DB ~]# more /data/run/loadavg# record cpu avg loading .date >>/data/run/loadavg.txtcat /proc/loa【阅读全文】
【Oracle】 latch free等待
guocun09 | 2017-12-07 13:48:12 | 阅读(4) | 评论(0)
案例:2011/10/26 Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production+Red Hat Enterprise Linux AS release 4 (Nahant Update 5) 產線反映掃描緩慢: top:發現負載達到10,cpu :60%(us) 查看v$session_wait很多latch free等待 可以看下這個:select sid,event,p1 as file_id, p2 as "block_id/latch", p3 as blocks,l.na【阅读全文】
【Oracle】 open cursor數
guocun09 | 2017-12-07 13:48:12 | 阅读(0) | 评论(0)
SELEcT a.inst_id, a.sid, a.USERNAME, a.ScHEMANAME, a.OSUSER, a.machine, a.TERMINAL, a.LOGON_TIME, a.PROGRAM, a.STATUS, b.name, b.used FROM gv$session a, (SELEcT n.inst_id, sid, n.name, s.VALUE used FROM gv$statname n, gv$sesstat s WHERE n.name IN ('opened cursors current', 'session cursor cache count') AND s.statisti【阅读全文】
【Oracle】 11G+ASM RAc关机
guocun09 | 2017-12-07 13:48:12 | 阅读(13) | 评论(0)
wsjrac01<*+ASM1*/home/grid>$suPassword: wsjrac01<*+ASM1*/home/grid>$iduid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel),105(pkcs11)wsjrac01<*+ASM1*/home/grid>$crscrsctl crs_register crs_stat.bincrsctl.bin crs_register.bin crs_stopcrsd crs_relocate crs_stop.bincr【阅读全文】
guocun09 | 2017-12-07 13:48:12 | 阅读(4) | 评论(0)
checkpoint(检查点)产生发生后会做什么? 此时会触发DBWR进程把cKP之前Dirty data从data buffer写入disk,写完后cKPT进程更新control file,data file头部记录checkpoint信息,这才完成了一次checkpoint。 Log File Switch-日志文件切换时出现 日志切换时,LGWR需要关闭当前日志组,切换并打开下一组,在这个过程中所有的DML操作都处于停顿【阅读全文】
guocun09 | 2017-12-07 13:48:12 | 阅读(72) | 评论(0)
guocun09 | 2017-12-07 13:48:12 | 阅读(44) | 评论(0)
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 10 15:09:11 2011copyright (c) 1982, 2007, Oracle. All Rights Reserved. connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testi【阅读全文】