-
编辑 删除
使用alter tracing禁用事件
Disabling the other events has to be done with "alter tracing" commands: begin EXECUTE IMMEDIATE 'ALTER TRACING DISABLE "10401"'; EXECUTE IMMEDIATE 'ALTER TRACING DISABLE "10005"'; EXECUTE IMMEDIATE 'ALTER TRACING DISABLE "10425"'; end; /To be sure this disabling stays in effect after instance restart use the following trigger: CREATE OR REPLACE TRIGGER modify_kst_events AFTER STARTUP ON DATABASE begin EXECUTE IMMEDIATE 'ALTER TRACING DISABLE "10401&q
-
编辑 删除
修改trace buffer size
Changing the trace buffer size can only be done in the parameter file: _trace_pool_size=100M[@more@]
-
编辑 删除
删除UNDO表空间和数据文件之后磁盘剩余空间不变
OS: Enterprise Linux Server release 5.2 i686DB: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0症状: 删除UNDO表空间和数据文件之后磁盘剩余空间不变原因: 有oracle进程正在打开这些文件解决办法: 重启数据库,或者干掉相关进程[@more@]具体过程如下:服务器空间告急, 1, 首先检查diagnostic_dest下空间使用状况,经查正常;2, 然后看各个表空间数据文件的分配情况,发现UNDO的数据文件总和已经超过60G了,而实际使用情况也就2G以内, 选择了创建一个新的UNDO 表空间,命名UNDO2,然后将undo_tablespace参数设置为UNDO2;3, 然后删除
-
编辑 删除
V$LOCK vs DBA_DML_LOCK
Get current locks:SQL> select s.username "Session User",l.sid "Lock Session",l.type "Lock Type",DECODE(l.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,'Share', 5, 'S/Row Excl.', 6, 'Exclusive', LTRIM(TO_CHAR(Lmode,'990')))"Lock Mode",DECODE(l.Request, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,'Share', 5, 'S/Row Excl.', 6, 'Exclusive', LTRIM(TO_CHAR(l.Request, '990')))"Request",l.Id1, l.Id2,d.owner||'.'||d.object_
