ITPub博客

Applies to:Oracle Server - Enterprise Edition - Version 8.0.3.0 and laterInformation in this document applies to any platform.GoalOracle Internal Events, both named event (eg: ERRORSTACK) as numeric e...

alter session set timed_statistics=true;--打开timed_statisticsalter session set SQL_TRACE= true;--打开sqltracealter session set events '10046 trace name context forever, level 12';----打开wait...

Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.1.0.7 - Release: 8.1.7 to 11.1Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.1.0.7   [Relea...

 使用imp,impdp 导入数据时统计信息经常统计失败需要重新生成一 生成统计信息的方法如下:1 基于表exec DBMS_STATS.GATHER_TABLE_STATS(ownname => 'GFOLTP',tabname => 'TJFRECORD',GRANULARITY => 'ALL',casca...

Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.1 - Release: 10.2 to 10.2Information in this document applies to any platform.SymptomsAlert log is showing errors:ORA-00600:...

Applies to:Oracle Server - Personal Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3   [Releas...

1 amdu -diskstring '/dev/asm*'  生成 report.txt 可以查看磁盘组和磁盘信息具体信息如下:[grid@node1 ~]$ amdu -diskstring /dev/asm*LRM-00110: syntax error at '/dev/asm-diskb'AMDU-00101: LRM ...

1.alter tablespace tbs read only;2.alter tablespace tbs offline;3.在offline后拷贝一份原文件，并命名为新文件名4.alter tablespace tbs rename datafile 'tbs_file_old.dbf' to 'tbs_file_new.dbf';5.alter tab...

Oracle 目前从 8i 到 11gr2 11.2.0.3 为止的 Patchset 和 PSU的 Patch Number 信息索引:Patchset / PSU   PatchNumber11.2.0.3          &n...

批量生成注释命令:表:select 'comment on table '||a.owner||'.'||a.TABLE_NAME||' is '||''''||a.comments||''''||';' from dba_tab_comments a where a.OWNER='JKDA_ZZNEW';列:select 'comment on column '||a...

---1 设置并行(可选项)SQL> alter session force parallel dml parallel 20; Session alteredSQL> alter session force parallel query parallel 20; Session altered---2 创建中间表(...

需要删除一个asm实例,发现网上有一篇转载过,本人已测试[oracle@ligle-db ~]$ ps -ef | grep asmoracle 4138 1 0 03:45 ? 00:00:00 asm_pmon_+ASMoracle 4140 1 0 03:45 ? 00:00:00 asm_psp0_+ASMoracle 4142 1 ...

1重做大小从几百兆到几G都被认为是合理的确定重做日志的最小限定是保证一次重做日志切换不小于20分钟2如果重做日志没有设置多路复用,不建议设置的过大,因为重做故障将无法重备份中恢复,将丢失较多的数据3&nb...

select /*+ordered use_hash(a,c)*/ 'alter database datafile ''' || a.file_name || ''' resize '  || round(a.filesize - (a.filesize - c.hwmsize - 100) * 0.8) || 'M;', a.filesize,&nbsp...

1 查看当前hugepages配置情况$ grep Huge /proc/meminfoHugePages_Total:       0HugePages_Free:        0HugePages_Rsvd:        0HugePages_Surp:  ...

一root用户vi  /etc/oratab  N  改为Y                     二oracle 用户vi $ORACLE_HOME/bin/dbstart 修改    ORACLE...

步骤Enable /3GBEnable /PAE and USE_INDIRECT_DATA_BUFFERS, set AWE sizeReduce unused SGA memory allocations OR implement A(S)MM (set SGA_TARGET; note that A(S)MM cannot be used with /PAE in place)Shrin...

Troubleshooting StepsThe "WARNING: inbound connection timed out (ORA-3136)" in the alert log indicates that the client was not able to complete  the  authentication process within the period...

Oracle等待事件Data file init write上一篇 / 下一篇  2011-09-23 16:44:31 查看( 37 ) / 评论( 0 ) / 评分( 0 / 0 ) Data file init write等待事件是10gR2后引入的，一般发生在创建或增加表空间的数据文件...

数据文件，日志文件，控制文件都正常方式一 : 本服务器重新安装操作系统   1 在原来的系统盘重新安装操作系统   2  把原来的oracle base目录重新命名 如: ...