Oracle和MySQL - 博客园

Oracle Supplemental 补全日志介绍

摘要： Oracle补全日志(Supplemental logging)特性因其作用的不同可分为以下几种：最小(Minimal),支持所有字段(all),支持主键(primary key),支持唯一键(unique),支持外键(foreign key)。包括LONG,LOB,LONG RAW及集合等字段类型均无法利用补全日志。最小(Minimal)补全日志开启后可以使得logmnr工具支持链式行，簇表和索... 阅读全文

posted @ 2009-08-09 22:23 Oracle和MySQL 阅读(286) 评论(0) 推荐(0)

Script:Generating CREATE USER DDL Statements

摘要： Title: Generating CREATE USER DDL StatementsAuthor:Ted Martin, a database administrator in Ottawa, Ontario, Canada.These scripts will generate SQL DDL statements related to the creation of user accoun... 阅读全文

posted @ 2009-07-31 16:36 Oracle和MySQL 阅读(231) 评论(0) 推荐(0)

Script:Diagnostic ORA-01000 maximum open cursors exceeded

摘要：以下脚本可以用于诊断ORA-01000打开游标过多错误:set linesize 140 pagesize 1400selectto_char(100 * sess / calls, '999999999990.00') || '%' cursor_cache_hits,to_char(100 * (calls - sess - hard) / calls, '999990.00') || '%'... 阅读全文

posted @ 2009-07-17 18:21 Oracle和MySQL 阅读(328) 评论(0) 推荐(0)

Oracle Event 10357 and 10351

摘要： [oracle@rh2 ~]$ oerr ora 1035710357, 00000, "turn on debug information for direct path"// *Cause:// *Action: turn on debug information for direct pathThe cause of this issue was identified as unpubli... 阅读全文

posted @ 2009-07-09 09:48 Oracle和MySQL 阅读(375) 评论(0) 推荐(0)

Audit Logon above 9i

摘要： 1. Enable audit. Set the parameter toaudit_trail=db (or db,extended)2. Restart the database instance to enable the audit settings.3. Set up audit for session:audit session whenever successful;4. After... 阅读全文

posted @ 2009-07-08 20:47 Oracle和MySQL 阅读(233) 评论(0) 推荐(0)

How to increase System Change Number by manual

摘要： How to jump SCN by manual , this could be a problem:1. We can bump up the SCN by using the procedure from Note: 386830.1Bump the system SCN on the primary database to fix any metadata index corrupti... 阅读全文

posted @ 2009-07-08 00:59 Oracle和MySQL 阅读(669) 评论(0) 推荐(0)

ORA-4030 PGA Usage Diagnostic Script

摘要： REM Locate the top PGA userset lines 75set pages 999set serveroutput onspool topuser.outselect * from gv$version;declare a1 number; a2 number; a3 varchar2(30); a4 var... 阅读全文

posted @ 2009-07-07 23:54 Oracle和MySQL 阅读(283) 评论(0) 推荐(0)

Oracle内部错误ORA-600:[1112]

摘要：以下为ORA-600[1112]内部错误的相关诊断信息:ERROR:ORA-600 [1112] [a] [b] [c] [d] [e]VERSIONS:versions 7.3 to 9.2DESCRIPTION:ORA-600 [1112] is getting raised while trying to add arow cache enqueue to a transaction sta... 阅读全文

posted @ 2009-07-07 07:07 Oracle和MySQL 阅读(267) 评论(0) 推荐(0)

How many LMS processes for Oracle Rac 9i?

摘要： Question:How many LMS processes for Oracle 9i Rac?Can you check if you have increased the CPU in the machine during the upgrade.Also please let me know if you have changed any underscore parameter.Do ... 阅读全文

posted @ 2009-07-06 21:55 Oracle和MySQL 阅读(185) 评论(0) 推荐(0)

Tune Very Large Hash Join

摘要： set timing on;alter session set workarea_size_policy=MANUAL;alter session set workarea_size_policy=MANUAL;alter session set db_file_multiblock_read_count=512;alter session set db_file_multiblock_read_... 阅读全文

posted @ 2009-07-02 06:52 Oracle和MySQL 阅读(296) 评论(0) 推荐(0)

ORACLE数据库服务热线：13764045638 诗檀软件