遠離塵世の方舟

查看oracle锁及解决办法

摘要： SQL> select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1, v$session t2 where t1.session_id=t2.sid order by t2.logon_time;USERNA... 阅读全文

posted @ 2015-03-26 17:44 遠離塵世の方舟阅读(144) 评论(0) 推荐(0)

Hadoop书籍下载链接

摘要： Hadoop书籍推荐1：Hadoop实战(结合经典案例全面讲解hadoop整个技术体系)http://www.db2china.net/club/thread-25148-1-1.html2：Hadoop权威指南(英文原版+中文版)http://www.db2china.net/club/threa... 阅读全文

posted @ 2015-03-25 14:18 遠離塵世の方舟阅读(276) 评论(0) 推荐(0)

Invalid file permission Please regenerate them with cacaoadm create-keys --force

摘要： 1、服务器重启之后，启动cacao报错，提示无效的文件权限。[root@ldapserver bin]# ./cacaoadm startInvalid file permission: [/home/ldap/dsee6/cacao_2/etc/opt/sun/cacao/instances/de... 阅读全文

posted @ 2015-03-25 02:56 遠離塵世の方舟阅读(464) 评论(0) 推荐(0)

主流数据库书籍电子版下载汇总（转载）

摘要： Oracle《Oracle优化日记》http://www.db2china.net/club/thread-41651-1-1.html《Oracle性能优化求生指南》http://www.db2china.net/club/thread-40845-1-1.html《Oracle 10g宝典(第2... 阅读全文

posted @ 2015-03-24 13:49 遠離塵世の方舟阅读(861) 评论(0) 推荐(0)

自动工作负载库（Automatic Workload Repository，AWR）

摘要：自动工作负载库（Automatic Workload Repository，AWR）AWR的由来： 10g之前的oracle:用户的连接将产生会话，当前会话记录保存在v$session中；处于等待状态的会话会被复制一份放在v$session_wait中。当该连接断开后，其原来的连接信息在v$sess... 阅读全文

posted @ 2015-03-24 11:55 遠離塵世の方舟阅读(525) 评论(0) 推荐(0)

virtual private catalog

摘要： The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recoverycatalog.... 阅读全文

posted @ 2015-03-23 22:48 遠離塵世の方舟阅读(589) 评论(0) 推荐(0)

About Health Monitor Checks

摘要： About Health Monitor ChecksHealth Monitor checks (also known as checkers, health checks, or checks) examine various layers and components of the datab... 阅读全文

posted @ 2015-03-23 10:30 遠離塵世の方舟阅读(290) 评论(0) 推荐(0)

修改ORACLE-NLS_DATE_FORMAT时间格式的四种方式

摘要：修改ORACLE-NLS_DATE_FORMAT时间格式的四种方式改变ORACLE -NLS_DATE_FORMAT中时间显示格式的显示有以下方式：1.可以在用户环境变量中指定（LINUX)。在用户的.bash_profile中增加两句：export NLS_LANG=AMERICAN ---要注意... 阅读全文

posted @ 2015-03-21 17:57 遠離塵世の方舟阅读(2063) 评论(0) 推荐(0)

About Quick Packaging and Custom Packaging

摘要： About Quick Packaging and Custom PackagingThe Enterprise Manager Support Workbench provides two methods for creating and uploading an incident package... 阅读全文

posted @ 2015-03-20 14:55 遠離塵世の方舟阅读(203) 评论(0) 推荐(0)

Fault Diagnosability Infrastructure Overview

摘要： Fault Diagnosability Infrastructure OverviewThe fault diagnosability infrastructure aids in preventing, detecting, diagnosing, and resolving problems.... 阅读全文

posted @ 2015-03-20 14:46 遠離塵世の方舟阅读(252) 评论(0) 推荐(0)