- 博客(4)
- 资源 (4)
- 问答 (1)
- 收藏
- 关注
原创 确定表是否存在高水位问题
How to determine the high water mark------------------------------------To view the high water mark of a particular table:: ANALYZE TABLE ESTIMATE/COMPUTE STATISTICS; This will update t
2013-04-27 19:58:47 1330
原创 打补丁报错Opatch error : "Unable to lock Central Inventory
Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]Information in this document applies to any platform.This problem can occur on any UNIX pla
2013-04-27 19:36:36 5018
原创 删除undo表空间报ORA-01548
回归段中活动的事物删除undo表空间报ORA-01548问题解决如下:用expdp导出数据报错:C:\Documents and Settings\TEMP>expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dump SCHEMAS=scottExport: Release 11.2.0.1.0 - Production on 星期一
2013-04-08 21:43:48 5431 1
原创 Ora-27300 OS system dependent operation:fork failed with status: 11 [ID 392006.1]
今天处理一个oracle双机切换的问题的,最后定为出原因如下:操作系统无法分配进程给我oracle,原因就是已经达到用户的最大进程数Applies to: Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterGeneric UNIXGeneric Linux***Checked for relevanc
2013-04-07 21:27:23 3877
服务器内存告警,发现是oracle 归档进程arch 占用超过10G(每个arch进程)
2014-05-01
TA创建的收藏夹 TA关注的收藏夹
TA关注的人