2017年2月13日
awr 收集时间
摘要： windows 收集 awr 报告，一分钟一个。 https://www.realdbamagic.com/manually-generating-awr-report/ One of my customers asked me to check performance on his product 阅读全文
posted @ 2017-02-13 15:27 feiyun8616 阅读(204) 评论(0) 推荐(0)
windows session 管理
摘要： Killing an Oracle process from inside Oracle I had a following situation few days ago – I was running a CREATE TABLE AS SELECT over a heterogenous ser 阅读全文
posted @ 2017-02-13 11:56 feiyun8616 阅读(1026) 评论(0) 推荐(0)
Oracle Database Hang While Loading 3rd party SBT Library And After This Nobody Can Access The Database (windows login 登陆hang )
摘要： select * from v$session where username='SYS' and program='rman.exe' SYS 0 2147483644 INACTIVE DEDICATED 0 SYS a\backupadmin 55292:54940 a\EAISSVR 0 EA 阅读全文
posted @ 2017-02-13 10:27 feiyun8616 阅读(213) 评论(0) 推荐(0)