摘要:
自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 ... 阅读全文