0古云0

1.查询存在死锁 select s.username,s.sid,s.serial#,s.logon_time--,s.* from v$locked_object l,v$session s whe

select s.username,s.sid,s.serial#,s.logon_time--,s.* from v$locked_object l,v$session s where l.sess

select * from user_source where type='PROCEDURE' and text like '%ycCeShi%';

select * from user_source where type='PROCEDURE' and text like '%ycCeShi%';

select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.EXECUTIONS "执行次数", round(sa.ELAPSED_TIME / 10

select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.EXECUTIONS "执行次数", round(sa.ELAPSED_TIME / 10

一、通过scn恢复删除且已提交的数据 1、获得当前数据库的scn号 select current_scn from v$database; (切换到sys用户或system用户查询) 查询到的scn号

一、通过scn恢复删除且已提交的数据 1、获得当前数据库的scn号 select current_scn from v$database; (切换到sys用户或system用户查询) 查询到的scn号

查询慢sql语句 select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.EXECUTIONS "执行次数", round(sa.ELAPSED_