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

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

摘要：以下脚本可以用于诊断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') || '%'... 阅读全文

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

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

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

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

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

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

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