发布时间：2017-12-07 13:48:13
--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.ta.........【阅读全文】
发布时间：2017-12-07 13:48:13
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:----------->";crs_st.........【阅读全文】
发布时间：2017-12-07 13:48:13
主庫：[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 environmentORACLE.........【阅读全文】
发布时间：2017-12-07 13:48:12
consistent mode 是在基于 query mode 下的，oracle有一个一致读的概念也就是说，当查询开始的时候oracle将确立一个时间点，凡是在这个时间点以前提交的数据oracle将能看见，之后提交的数据将不能看见。但查询的时候可能遇上这样的情况，该块中数据已经被修改了，没有提交，或者提交的时间点比查询开始的时间晚.........【阅读全文】
发布时间：2017-12-07 13:48:12
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.........【阅读全文】
