嘻哈小王

摘要： declare seq_name varchar2(100); l_currval number; --序列的当前值 cursor seq_cur is select ur.sequence_name from user_sequences ur; --将当前数据库所有序列的名称存放到游标中 beg 阅读全文

摘要： 1)查询最慢的sql select * from ( select parsing_user_id,executions,sorts command_type,disk_reads,sql_text from v$sqlarea order by disk_reads desc )where row 阅读全文

摘要： select * from (select s.SQL_TEXT, s.EXECUTIONS "执行次数", s.PARSING_USER_ID "用户名", rank() over(order by EXECUTIONS desc) EXEC_RANK from v$sql s left join 阅读全文

摘要： select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.EXECUTIONS "执行次数", round(sa.ELAPSED_TIME / 1000000, 2) "总执行时间", round(sa.ELAPSED_TIME / 1000000 阅读全文

摘要： select sql_text from v$sql where disk_reads > 1000 or (executions > 0 and buffer_gets / executions > 30000); 阅读全文

摘要： select * from dba_dependencies where referenced_name='被引用的对象名' 阅读全文

摘要： 添加maven依赖 <!--连接ftp使用--> <dependency> <groupId>commons-net</groupId> <artifactId>commons-net</artifactId> <version>3.3</version> </dependency> <!--打印日 阅读全文