摘要:
一.说明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 阅读全文
摘要:
一./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 阅读全文
摘要:
官网的链接说明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 阅读全文
摘要:
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 ... 阅读全文
摘要:
一.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 阅读全文
摘要:
关于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 阅读全文
摘要:
在一套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 阅读全文
摘要:
一.Alerts 和 Metrics说明官方链接:Monitoring and Tuning the Databasehttp://docs.oracle.com/cd/E11882_01/server.112/e10897/montune.htm#CACCIHAB Alerts help you monitor your database. Most alerts notify youof when particularmetric thresholds are exceeded.For each alert, you can set critical and warning thresho 阅读全文
摘要:
官网的链接:Overview of PL/SQLhttp://docs.oracle.com/cd/E11882_01/appdev.112/e25519/overview.htmServer-Side Programming: PL/SQL and Javahttp://docs.oracle.com/cd/E11882_01/server.112/e25789/srvrside.htm一.PL/SQL 定义 PL/SQL is theOracle Database procedural extension to SQL. PL/SQL is integrated with thedatab 阅读全文
摘要:
在之前的Blog里提到了VBox 的4中网络类型:NATBridged AdapterInternalHost-onlyAdapter具体参考:Oracle Virtual Box 安装使用 说明http://blog.csdn.net/tianlesoftware/article/details/6826389 今天升级了一个VBox 到4.1.8,在这个版本中对网络这块有加强,增加了UDP的支持,升级之后看了下Vbox,多了一种Generic Driver,因为之前没有留意是否有这种模式,所以这里也不能确定GenericDriver 是新版本里才有的。 不过查看了参考文档,确实有了增加的内 阅读全文