From:http://blog.sina.com.cn/s/blog_6619c0420101bia8.htmlLinux下自动启动多个oracle实例—环境:1>linux:linux4.5-32-bit-x86-setup2> oracleracleDatabase10gRelease 2(10.2.0.1.0) EnterpriseStandard Edition for Linux x86--------------------------------------------------------—操作详...【阅读全文】
问题create table abc(A int,B int) Select A,count(B) as total from ABC group by ASelect A,count(B) as total1 from ABC where B > 30 group by ASelect A,count(B) as totlal2 from ABC where B > 20 group by A如何合并这三个查询?得到一个查询结果:A,total,total1,total2解决方案:Select A,count(B) ...【阅读全文】
全局事务 有开始 无commit 这时停服务,但数据库层面还有有对象锁定。 select addr,sid,username,s.status,process,s.LAST_CALL_ET,s.program,START_DATE from v$transaction t,v$session s where t.ses_addr=s.saddr order by LAST_CALL_ET; 查询无事务。 但下面锁定对...【阅读全文】