01 2012 档案

Oracle SQL Access Advisor 说明
摘要：一.说明1.1 相关内容在如下官方文档中提到了一些优化工具的说明：Monitoring and Tuning the Databasehttp://docs.oracle.com/cd/E11882_01/server.112/e10897/montune.htmUsing Advisors to Optimize DatabasePerformance Oracle Databaseincludes a set ofadvisorsto help you manage and tune your database.This section contains background inform 阅读全文
posted @ 2012-01-31 22:08 davedba 阅读(164) 评论(0) 推荐(0) 编辑
Oracle SQL Access Advisor 说明
摘要：一.说明1.1 相关内容在如下官方文档中提到了一些优化工具的说明：Monitoring and Tuning the Databasehttp://docs.oracle.com/cd/E11882_01/server.112/e10897/montune.htmUsing Advisors to Optimize DatabasePerformance Oracle Databaseincludes a set ofadvisorsto help you manage and tune your database.This section contains background inform 阅读全文
posted @ 2012-01-31 22:08 davedba 阅读(328) 评论(0) 推荐(0) 编辑
Linux 下Oracle 开机自启动 与 oratab， dbstart 脚本 说明
摘要：一./etc/oratab说明直接使用cat 查看这个文件：gg1:/home/oracle> cat /etc/oratab# # This file is used by ORACLEutilities. It is created by root.sh# and updated by the Database ConfigurationAssistant when creating# a database. # A colon, ':', is used as the fieldterminator. A new line terminates# the entry 阅读全文
posted @ 2012-01-30 21:41 davedba 阅读(294) 评论(0) 推荐(0) 编辑
Linux 下Oracle 开机自启动 与 oratab， dbstart 脚本 说明
摘要：一./etc/oratab说明直接使用cat 查看这个文件：gg1:/home/oracle> cat /etc/oratab# # This file is used by ORACLEutilities. It is created by root.sh# and updated by the Database ConfigurationAssistant when creating# a database. # A colon, ':', is used as the fieldterminator. A new line terminates# the entry 阅读全文
posted @ 2012-01-30 21:41 davedba 阅读(263) 评论(0) 推荐(0) 编辑
Oracle Resource Manager 概述
摘要：官网的链接说明About Oracle Database Resource Managerhttp://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm001.htm#i1007556一.Solutions Does the Resource ManagerProvide for Workload Management?When databaseresource allocation decisions are left to the operating system, you mayencounter the following prob 阅读全文
posted @ 2012-01-23 13:08 davedba 阅读(293) 评论(0) 推荐(0) 编辑
Oracle Resource Manager 概述
摘要：官网的链接说明About Oracle Database Resource Managerhttp://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm001.htm#i1007556一.Solutions Does the Resource ManagerProvide for Workload Management?When databaseresource allocation decisions are left to the operating system, you mayencounter the following prob 阅读全文
posted @ 2012-01-23 13:08 davedba 阅读(174) 评论(0) 推荐(0) 编辑
Oracle TIMED_STATISTICS 参数 说明
摘要：MOS上有关TIMED_STATISTICS参数说明： Init.ora Parameter "TIMED_STATISTICS" Reference Note [ID 30824.1] Health CheckAlert: Consider setting TIMED_STATISTICS and STATISTICS_LEVEL to recommendedlevels [ID 957433.1] Version Parameter Type Modifiable 11.1.0.7 timed_statistics BOOLEAN ALTER SESSION ... 阅读全文
posted @ 2012-01-11 16:24 davedba 阅读(294) 评论(0) 推荐(0) 编辑
Oracle TIMED_STATISTICS 参数 说明
摘要：MOS上有关TIMED_STATISTICS参数说明： Init.ora Parameter "TIMED_STATISTICS" Reference Note [ID 30824.1] Health CheckAlert: Consider setting TIMED_STATISTICS and STATISTICS_LEVEL to recommendedlevels [ID 957433.1] Version Parameter Type Modifiable 11.1.0.7 timed_statistics BOOLEAN ALTER SESSION ... 阅读全文
posted @ 2012-01-11 16:24 davedba 阅读(132) 评论(0) 推荐(0) 编辑
Oracle Resumable Space Allocation 特性 说明
摘要：一.Resumable Space Allocation 说明 从9i开始，Oracle提供了一种避免因为space Error而导致事务异常的操作: resumable spaceallocation. 在Oracle 10g的OCP 考试中有考resumable session 的这个知识点。官网对Resumable的解释： Advantage is forDBAs who are running yearly reports and do not know how much extra disk spaceis required for TEMP, UNDO or DATA tables 阅读全文
posted @ 2012-01-10 22:47 davedba 阅读(167) 评论(0) 推荐(0) 编辑
Oracle Resumable Space Allocation 特性 说明
摘要：一.Resumable Space Allocation 说明 从9i开始，Oracle提供了一种避免因为space Error而导致事务异常的操作: resumable spaceallocation. 在Oracle 10g的OCP 考试中有考resumable session 的这个知识点。官网对Resumable的解释： Advantage is forDBAs who are running yearly reports and do not know how much extra disk spaceis required for TEMP, UNDO or DATA tables 阅读全文
posted @ 2012-01-10 22:47 davedba 阅读(266) 评论(0) 推荐(0) 编辑
Oracle Expdp/Impdp 进行数据迁移的 几点注意事项
摘要：关于Expdp/Impdp 命令的具体使用，在之前的blog里有说明，参考：Oracle expdp/impdp 使用示例http://blog.csdn.net/tianlesoftware/article/details/6260138exp/imp 与 expdp/impdp 对比 及使用中的一些优化事项http://blog.csdn.net/tianlesoftware/article/details/6093973Oracle 客户端 使用expdp/impdp 示例 说明http://blog.csdn.net/tianlesoftware/article/details/707 阅读全文
posted @ 2012-01-10 20:02 davedba 阅读(219) 评论(0) 推荐(0) 编辑
Oracle Expdp/Impdp 进行数据迁移的 几点注意事项
摘要：关于Expdp/Impdp 命令的具体使用，在之前的blog里有说明，参考：Oracle expdp/impdp 使用示例http://blog.csdn.net/tianlesoftware/article/details/6260138exp/imp 与 expdp/impdp 对比 及使用中的一些优化事项http://blog.csdn.net/tianlesoftware/article/details/6093973Oracle 客户端 使用expdp/impdp 示例 说明http://blog.csdn.net/tianlesoftware/article/details/707 阅读全文
posted @ 2012-01-10 20:02 davedba 阅读(168) 评论(0) 推荐(0) 编辑
Oracle dbca Exception in thread “main” 解决方法
摘要：在一套DB服务器上运行DBCA 命令，报错：[oracle@game_db ~]$ dbcaException in thread "main" [oracle@game_db ~]$ [oracle@game_db ~]$ exportDISPLAY=1921.68.3.189:0.0[oracle@game_db ~]$ dbcaException in thread "main" 几年都没有遇到这种问题了，起初以为是DISPLAY变量的问题，设置以后也不行，查看了一个DBCA的log 日志：[oracle@game_db scripts]$ cd 阅读全文
posted @ 2012-01-04 13:54 davedba 阅读(170) 评论(0) 推荐(0) 编辑
Oracle dbca Exception in thread “main” 解决方法
摘要：在一套DB服务器上运行DBCA 命令，报错：[oracle@game_db ~]$ dbcaException in thread "main" [oracle@game_db ~]$ [oracle@game_db ~]$ exportDISPLAY=1921.68.3.189:0.0[oracle@game_db ~]$ dbcaException in thread "main" 几年都没有遇到这种问题了，起初以为是DISPLAY变量的问题，设置以后也不行，查看了一个DBCA的log 日志：[oracle@game_db scripts]$ cd 阅读全文
posted @ 2012-01-04 13:54 davedba 阅读(126) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示