~笑

摘要： 自http://www.javaeye.com/topic/359502性能监控之监控SQL语句 分析表 analyze table tablename compute statistics for all indexes; analyze table tablename compute statistics for all indexed columns; analyze table tablename compute statistics for table; 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev" 阅读全文

摘要： 自http://www.javaeye.com/topic/82587数据字典dict总是属于Oracle用户sys的。　　1、用户：　　　select username from dba_users;　　改口令　　　alter user spgroup identified by spgtest;　　2、表空间：　　　select * from dba_data_files;　　　select ... 阅读全文