-
编辑 删除
CleanUp Temporary Segments Occupying Permanent Tablespace
By Saurabh Sood, July 3, 2009 12:42 pm There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up.These temporary segments in p...
-
编辑 删除
physic data guard 的原理 笔记
物理data guard原理的理解这里只谈物理data guard的原理*******************************************************************************一般来说，我们在谈到data guard的时候，都会用很简单的语言来描述整个...
-
编辑 删除
V$session, v$process, v$sql 之间的对应关系
v$session ses, v$process pro, v$sql sql where ses.paddr = pro.addr and ses.SQL_HASH_VALUE = sql.HASH_VALUE and ses.SQL_ADDRESS = sql.address and ses.sql...
-
编辑 删除
oracle nologging 和批量insert
当前session产生的redoSQL> create or replace view redo_size2 as3 select value4 from v$mystat, v$statname5 where v$mystat.statistic# = v$statname.statistic#6 and v$statname.name = 'redo size';&nb...
-
编辑 删除
ORA-14402: updating partition key column would cause a partition change
oracle@ebs ~]$ oerr ora 1440214402, 00000, "updating partition key column would cause a partition change"// *Cause: An UPDATE statement attempted to change the value of a partition //  ...
-
编辑 删除
当index数据文件被损坏，数据库恢复办法
1. 先把问题datafile offline drop, then open databasestartup mount;alter database datafile '/data/boss/indx01.dbf' offline drop;SQL> alter database open;2.通过 dba_data_files 确定数据库问题表空间SQL...
-
编辑 删除
object所在的datafile offline后， status 仍然是usable
SQL> select index_name, partition_name, status from dba_ind_partitions 2 where index_name = 'IDX_ACCOUNTUNLOCKEX_ORDERID';INDEX_NAME ...
-
编辑 删除
ORA-06553: PLS-801: internal error [56319]
背景：migrating a 32 bit database to a 64 bit database Both databases are 10g 数据库迁移完成后,执行以下语句遇到了error 56319 SQL> alter index i...
-
编辑 删除
重建索引ora-08106错误
使用alter index xxxx rebuild online 命令重新建立了索引，遇到这个错误ora-08106 can not create journal table SCOTT.SYS_JOURNAL_30447解决方法，RENMAE这个SYS_JOURNAL_30447表重新执行创建语句就成功了。疑问...
