随笔分类 -  Oracle 基础知识

摘要：一.安装 unixODBCUnixODBC官网：http://www.unixodbc.org/这里使用YUM安装，不多说：Linux 使用光盘搭建 本地 YUM 服务器http://blog.csdn.net/tianlesoftware/article/details/7302358[root@rac1 mnt]#yum installunixODBC[root@rac1 mnt]#yum installunixODBC-devel确认unixODBC的安装，使用isql命令，其是unixODBC自带的命令。可以使用这个命令验证unixODBC的配置。[root@rac1 /]# isql 阅读全文

摘要：一./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 ... 阅读全文

摘要：关于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 阅读全文

摘要：一.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 阅读全文

摘要：官网的链接：http://docs.oracle.com/cd/E11882_01/server.112/e16638/instance_tune.htm#PFGRF13015一.Instance Recovery Instance andcrash recovery are the automatic application of redo log records to Oracle datablocks after a crash or system failure. During normal operation, if an instanceis shut down cleanly ( 阅读全文

摘要：一.官网说明Using Oracle Managed Fileshttp://docs.oracle.com/cd/E11882_01/server.112/e25494/omf.htm#ADMIN0031.1 What Are Oracle Managed Files?官网链接：http://docs.oracle.com/cd/E11882_01/server.112/e25494/omf001.htm#i1006122 UsingOracle Managed Files simplifies the administration of anOracle Database. Oracle 阅读全文

摘要：官网链接如下：http://docs.oracle.com/cd/E11882_01/install.112/e24321/appendix_ofa.htm#i633068一.Overview of the Optimal Flexible Architecture Standard The Optimal Flexible Architecture standard helps you to organize database software andconfigure databases to allow multiple databases, of different versions, 阅读全文

摘要：一.默认表空间说明 在oracle9i中，如果未用 DEFAULT TABLESPACE 子句创建的所有用户将以SYSTEM表空间作为它们的默认表空间。同时也不能为数据库指定一个默认的表空间。 在Oracle 10g中定义了数据库级别的默认表空间USERS，在创建用户时没有定义默认表空间，就会把数据库级别的默认表空间当作自己的默认表空间。在10g以前，是把系统表空间（SYSTEMS）当作默认表空间。这样很不合理。 可以使用如下命令查看默认表空间：/* Formatted on 2011/12/19 15:57:48(QP5 v5.185.11230.41888) */ SELECT PROPE 阅读全文

摘要：一.官网说明MOS 上的一篇文章： Setting Listener Passwords With an Oracle10g or Newer Listener [ID 260986.1]这里面提到如下内容： In Oracle 10gand newer versions of the listener, the listener is secure out of the box.There should be no need to set a listener password to prohibit privilegedLSNRCTL commands from being execute 阅读全文

摘要：之前整理的相关链接：Oracle 监听(Listener) 中services 说明http://blog.csdn.net/tianlesoftware/article/details/6617827Oracle Listener 动态注册 与 静态注册http://blog.csdn.net/tianlesoftware/article/details/5543166OracleDedicated server 和Shared server（专用模式 和 共享模式) 说明http://blog.csdn.net/tianlesoftware/article/details/5695784官 阅读全文

摘要：一.客户端使用expdp/impdp说明有关Oracle expdp/impdp 命令之前也整理了一些文档，链接如下：exp/imp 与 expdp/impdp 对比 及使用中的一些优化事项http://blog.csdn.net/tianlesoftware/article/details/6093973Oracle 10g Data Pump Expdp/Impdp 详解http://blog.csdn.net/tianlesoftware/article/details/4674224Oracle expdp/impdp 使用示例http://blog.csdn.net/tianleso 阅读全文