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 spring3mvc学习笔记 阅读(185) 评论(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 e 阅读全文

posted @ 2012-01-30 21:41 spring3mvc学习笔记 阅读(232) 评论(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 spring3mvc学习笔记 阅读(196) 评论(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 spring3mvc学习笔记 阅读(176) 评论(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 spring3mvc学习笔记 阅读(377) 评论(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 spring3mvc学习笔记 阅读(186) 评论(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 spring3mvc学习笔记 阅读(192) 评论(0) 推荐(0)

导航