-
编辑 删除
如何追踪产生大量REDO的来源
SQL: How to Find Sessions Generating Lots of Redo or Archive logs (文档 ID 167492.1) ***Checked for relevance on 13-Oct-2015***goal: How to find sessions generating lots of redofact: Oracle Server - Enterprise Edition 8fact: Oracle Server - Enterprise Edition 9fact: Oracle Server - Enterpr...
-
编辑 删除
Oracle查看每小时日志切换量脚本
---- Show the Number of Redo Log Switches Per Hour-- SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300 SELECT to_char(first_time, 'yyyy - mm - dd') aday, to_char(first_time, 'hh24') hour, ...
-
编辑 删除
Oracle 内存使用建议性能视图
下面三个查询结果均可查询出随着内存参数设置的变化性能的变化情况，对oracle数据库内存的设置有一定的建议和指导作用。select t.SGA_SIZE,t.ESTD_DB_TIME_FACTOR from v$sga_target_advice t order by sga_sizeSELECT pga_target_for_estimate / 1024 / 1024 "PGA(MB)",pga_target_factor,estd_pga_cache_hit_percent...
-
编辑 删除
压力测试工具
Apache JMeter<br /><br />loadrunner
-
编辑 删除
Clean WRH$_ACTIVE_SESSION_HISTORY in SYSAUX
<div class="post-header"></div>Tablespace SYSAUX grows quickly. Run Oracle script awrinfo.sql to find what is using the space. One section of the report shows that ACTIVE_SESSION_HISTORY is the biggest consumer.<pre>SQL> @$ORACLE_HOME/rdbms/admin/awrinfo.sqlCOMPONENT MB SEGMENT_NAME ...
-
编辑 删除
记录一次监控表空间使用率增长快原因
最近发现生产环境主要表空间增长过快，每天几个G，想查看一下原因。查看快照信息：select * from DBA_HIST_SNAPSHOT order by 1 desc根据快照信息，查看历史端使用情况：create table t1 as select * from DBA_HIST_SEG_STAT where snap_id=426create table t2 as select ...
-
编辑 删除
UNIX和linux系统性能监控工具oswatcher
可以在一台机器上运行oswatcher。把运行的结果拷贝到有vnc的机器上进行分析。java -jar oswbba.jar -i /mnt/hgfs/database/oswbb/archive
