ITPub博客

2005 年 06 月 01日, 星期三<!-- Oracle backgroud ProcessSystem Monitor Process Name: SMON Max Processes: 1 This process is responsible for instance recovery, if necessary, at instance startup....

Optimizer 的选择 【现在已经不选择了，除非特殊需求10g 以后默认都已经是Cost 】1.2.4 Which Optimizer to Use? If you are currently using the rule-based optimizer, I strongly recommend that you transfer...

Oracle Database Link Problemscle 8 数据链路在程式中不能支持：     ODBC        数据不可提交，无错误，偶尔会有错误。    Microsoft OLE DB&nb...

Oracle Optimizer -RBO (理解Rule-based 优化器)/*理解Rule-based 优化器       RBO 优先使用预定义方法去计算使用的某条路径访问数据库资料.     RDBMS 使用下列条...

oracle ora-00997 problemsOracle8i,9i 中对Long 操作有一个限制.就是:所有的select,Update,lock tables 的所有Long columns 必须在同一个Database中. 而你的SQL,正好选取了两个long columns 分别在两个dat...

Database Triggers and event attributes--Event AttributesWith the introduction of the 20 new database triggers, came the creation of attribute events or variables that are set when a certain database ...

Database Triggers and event attributes--Database System EventsThere are six database system event triggers. The six database system event triggers are outlined below, along with a description and the...

Database Triggers and event attributes--DDL/Client EventsDDL/Client Events There are 14 DDL/client event triggers and these can be created at the database level and will execute for all schemas, or ...

Database Triggers and event attributes--IntroductionIntroduction Creation of Database Triggers A database trigger is created and dropped with the following commands:     CREA...

在Oracle10gR2 之后ASM 文件可以使用FTP来进行访问，但还是要满足两个条件   1：安装XML DB   2：使用DBCA 默认创建数据库 默认情况下FTP 功能是不打开的，你可以使用Oracle 提...

 GPFS is IBM’s high-performance parallel, scalable file system for IBM UNIX clusters capable of supporting multi-terabytes of storage within a single file system. GPFS is a shared-disk file sy...

􀂃 These products are certified for AIX 5.3 and 6.1 on all Power Systems servers supported by those versions of AIX.􀂃 64-bit hardware is required for a 64-bit application such as Orac...

Solaris: #/usr/bin/isainfo –kv 64-bit sparcv9 kernel modulesAIX:-bash-3.2# bootinfo -y64-bash-3.2#RedHat:[root@itc-test9 ~]# getconf LONG_BIT64 HP-Unix$getconf KERNEL_BITS 64...

---直接看例子--drop table partt;CREATE TABLE Partt    (logid                    &nbs...

Oracle 11g 提供HealthCheck 独立的功能，和10g AWR 一样对第三方提供服务的厂商和个人来说是很有帮助，现在还不知道功能如何。支持自动调用和手动执行。不知道有没有我写的HealthCheck 范围有没有11g 的全面...

今天客户配置RMAN 备份发现错误。报RMAN-6186 错误，发现是RMAN 版本之间的错误。解决后顺便将RMAN 多版本的兼容性列表发出来，希望大家有所帮助。Target/AuxiliaryDatabaseRMAN ExecutableCatalog Dat...

看看你维护的数据库是否还在Oracle Support 的范围内：Oracle 9i Release 1 (9.1.0)Status: DesupportedLast patch-set: 9.1.0.4 End of Error Correction Support: 31-Dec-2003End of Extended Assistance Suppor...

全备份和0 级备份的差异： The only difference between a level 0 backup and a full backup isthat a full backup is never included in an incremental strategy. If no level 0 backup exists when you r...

新装个一台Windows2003 Server 要做测试，在EMC 上划了 4 Lun 给这台机器。捣腾了一天发现在Windows 2003 上能看到这个Lun 但不能初始化一个disk.如图： EMC Navisphere 6 上看到状况:  Wind...

在ora9.2.0.1 时我就一直认为UTL_FILE_DIR 这个参数即将离我们远去，但到11g 仍然顽强的活着且在EBS 中有发扬光大的迹象。但我还是认为这个参数的左右已经很弱，修改必须重启DB，对SLA为 7*24 的DB 来说显得不能适用...