redo copy latch的个数都跟cpu_ count有关,大概是这么一个关系:2* cpu_ count,如下是我这里的情况:select latch#,name from v$latch where name like '%redo copy%'select latch#,name,level# from v$latch_children where latch#=186 order by 3select latch#,name from v$latch where name like '%redo al...【阅读全文】
查看用户对应的profileSELECT username,PROFILE FROM dba_users;查看密码超时配置Select * From Dba_Profiles s Where s.Profile = 'DEFAULT' And Resource_Name = 'PASSWORD_LIFE_TIME';修改数据库密码永不超时alter profile default limit password_life_time unlimited;...【阅读全文】
目标库和复制库环境: OS: Linux Red Hat AS 4 DB Version: 11.2.0.4 1.目标库和复制库信息 Rman 中的目标库(target database)指的是被复制的库,复制库(duplicate database)是指复制后生成的新库(生成新的DBID).这里为了测试方便,复制库和目标库的目录结构设置相同. 目标库: ...【阅读全文】
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5784934.htmlOracle视图except SNAP_ID, and INSTANCE_NUMBER等字段dba_hist_active_sess_history视图的详细信息,请见下表列数据类型NULL...【阅读全文】
select name,value from v$sysstat where name like 'parse%';我的方法找出多次沒有綁定變量的sql:select count exe_count,module,SQL_TEXT from (select ROW_NUMBER()over(partition by substr(SQL_TEXT,1,50) order by SQL_TEXT) num,a.* from (select count(*)over(partition by substr(SQL_TEXT,1,50)) count ,SQL_TE...【阅读全文】
场景:查出被锁的对象。select * from dba_ddl_locks where NAME like 'PRO%'针对session id 查出进程id。select spid, osuser, s.program from v$session s,v$process pwhere s.paddr=p.addr and s.sid=154由于常规方法无法删除。所以通过,直...【阅读全文】