随笔分类 - 工作日志
记录每天遇到的问题和解决方法
摘要:select dbms_lob.substr(a.SQL_FULLTEXT) from v$sql a where sql_id ='fdsfd'
阅读全文
摘要:比如SQL_ID为g97cnrayku9xw,SQL>select address from v$sql where sql_id='g97cnrayku9xw';ADDRESS----------------000000077BE8EE68SQL>select username,osuser,machine,program from v$session where prev_sql_addr='000000077BE8EE68';或者SQL>select username,osuser,machine,program from v$sessi
阅读全文
摘要:ora-600 4194 错误一般是由于undo表空间损坏导致部分事务无法回滚,因而导致数据库无法启动或启动后又被PMON中止。解决此问题关键是确定损坏的回滚段,一般报警日志中会记录损坏的回滚段,见红色字体。如果数据库能够侥幸打开,我们也可以在打开的瞬间执行一个脚本来确定回滚段。1、报警日志、重点关注红色字体Mem# 0: /data/oradata/rcms/redo02.logBlock recovery completed at rba 11.69.16, scn 13.1485530024Thu Mar 25 17:36:07 2010Errors in file /u01/app/o
阅读全文
摘要:chfs -a size=100G /orabak
阅读全文
摘要:select * from dba_indexes where table_name ='T_USER_ROOT';select * from dba_indexes where index_name ='INDX_T_USER_ROOT$SSOID'
阅读全文