ITPub博客

Normal 0 7.8 磅 0 2 1 在oracle上面建立需要同步的表 create user tt identified by tt default tablespace users; SQL> create user tt identified by tt default tablespace users; SQL> grant connect,resource to tt; SQL> grant select any dictionary to tt; SQL> connect tt/tt@orcl1 SQL> create table t1(id number(2) primary key); 1.2 节点一server1 ORCL1 = (DESCRIPTION =

今天早上一上班就有朋友在MSN上说，容灾库无法启动，昨天晚上容灾库和生产库同步后，容灾库打开频繁的出现下列错误ORA-00600: internal error code, arguments: [2662], [2156], [2993124414], [2156], [2997732192], [97803001], [], []ORA-00600: internal error code, arguments: [kclchkblk_4], [2156], [18446744072412316512], [2156], [18446744072407708733], [], [], []查看metalink文档275902.1解释该错误Cause 1) Error, ORA-600[KCLCHKBLK_4], is signaled because the SCN in a tempfile blockis too high. The same reason

Normal 0 7.8 磅 0 2 具体在安装crs过程中可能遇到的问题请详细阅读metalink文档(405820.1),下面描述整个工作步骤。注意在该文档中前缀提示为 Ø #表示为root用户执行该命令 Ø %表示为oracle用户执行该命令 设置权限 该步骤主要是参考metalink文档405820.1,在AIX平台上安装完10.2.0.3 crs bundle#3 patch后,crs无法正常启动，通过设置这些权限可以解决该问题。 #chuser capabilities=CAP_BYP

Normal 0 7.8 磅 0 2 1 测试使用Cache Connect to Oracle 1.1 Setting up TimesTen and Oracle 1.1.1 设置TimesTen的环境变量 [root@server1 ~]# su - tt [tt@server1 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs export TimesTen=/oracle/timesten/T

该章节主要描述timesten在linux平台上的安装 Normal 0 7.8 磅 0 2 1 Timesten Install 1.1 　安装 在linux平台上，Timesten的默认安装目录在/tmp路径下,在安装过程中可以修改环境变量TMPDIR来配置默认安装路径。 在linux平台上使用非root用户安装。 创建timesten组及tt用户 #groupadd -g 1002 timesten #useradd -u 1002 -g 1002 -G timesten -d /home/tt -m tt #mkdir /etc/TimesTen #chmod 775 /etc/TimesTe

http://space.itpub.net/756652/viewspace-544642SQL> variable aa number;SQL> exec :aa:=90;PL/SQL 过程已成功完成。SQL> select * from tt where id=:aa; ID MC ---------- -------------------- 90 1 Execution Plan---------------------------------------------------------- 0 SELEC

禁用10自动统计分析特性： exec DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');exec dbms_stats.gather_table_stats(username,tablename,method_opt => 'FOR ALL COLUMNS SIZE 1',cascade => TRUE,estimate_percent => 25,granularity=>'all',degree => 4,no_invalidate => false);[@more@]

oracle9i生产库上在导出表的统计信息时有部分索引的统计信息导不出来，开始认为是索引的统计列GLOBAL_STAT=NO导致索引统计信息无法导出，在这里做一个演示来说明导致这种问题的原因。 create table T1 (A NUMBER,B NUMBER); declare begin for i in 1..10000 loop insert into T1 (a) values (i); end loop; commi

Subject: Gathering Statistics for the Cost Based Optimizer Doc ID: 114671.1 Type: FAQ Modified Date : 11-JAN-2009 Status: PUBLISHED Checked for relevance June 2007PURPOSE-------Give the available methods for gathering statistics for the Cost Based Optimizer. SCOPE & APPLICATION-------------------Database Administrators and Oracle Support AnalystsGathering Statistics-------------------- The cost-based optimization approach uses these statistics to estimate

10046 EVENT levels: /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-languag

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

ORA-01591错误故障处理 摘要： 在访问某些表的特定行时报ORA-01591错误 select * from BF_INCOME_EXPENSES_T where account_id = 36816153 and user_id = 39964213 and city_code = '185' ORA-01591: 锁定已被有问题的分配事务处理72.0.1608712挂起 SQL> select count(*) from UNITELE.BI_MQSYNC_SOURCE_CONTROL_T1; ORA-01591: 锁定已被有问题的分配事务处理72.0.1608712挂起 由于该表是业务关键表，部分前台业务受到影响。 关键词：ORA-01591 DBA_2PC_PENDING 分布式事务 1.故障分析 首先，

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

在oracle10g数据库上经常看到一些ora_pz进程From Oracle 10g onwards you will find on every node slave processes like pz99. This are the processes that query the gv$ viewsselect * from gv$px_process; INST_ID SERV STATUS PID SPID SID SERIAL#---------- ---- --------- ---------- ------------ ---------- ---------- 2 PZ99 IN USE 35 24994 2562 53336 2 PZ98 AVAILABLE 109 3905 2 PZ97 AVAILABLE 1229 4260

运行oracle自己的工具就可以查询锁的信息You can also use the utllockt.sql script to display lock wait-for in a hierarchy. The script prints the sessions that are waiting for locks and the sessions that are blocking. You must run the catblock.sql script (found in $ORACLE_HOME/rdbms/admin folder) as a sysdba user before using utllockt.sql. The catblock.sql script creates the dba_locksand dba_blockers views along with others that will be used by utllockt.sql[@more@]

10g推出了回滚段自动调整的新特性，但是在实际工作中经常出现回滚表空间100%的情况。建议关闭自动调整功能 Alter system set "_undo_autotune" = false; Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow

/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} From a SQL*Net perspective, the only thing

最近在虚拟机器上安装了下oracle 11g rac，总体安装流程跟oracle 10g rac安装区别不大[@more@]