-
编辑 删除
Oracle常用性能监控语句
1、监控等待事件select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*)from v$session_wait group by event order by 4;Lock wait occur when a session attempts to acquire a lock that is already held by another session. A session will be blocked until the ...
-
编辑 删除
3
提取DBLINK.txt获取数据库源代码.txtacl权限.txtOracle connect resource权限.txt替代wmsys.txt批量创建表脚本.sqlundo（回滚段）多大合适.txt分析表和索引.txtDBA查找sid、sql，运行次数.txt诊断数据库性能.txt发送邮件权限.txt低效率识别.txt ...
-
编辑 删除
bangding
bd2.txtbd1.txt删除job.txtdbms查看执行计划.txt数据字典.sql查看临时表和用户是否重建表.txt查看回滚段.sql闪回.doc字符串切割成行.txt自增分区.txt解决pin锁.txt查看数据库是否有回滚事务.txt物化视图问题.txt并行执行DML.txt增加表空间.txtparallel.txt批量编译包.txt查看运行sql的执行计划.txt修改大表字段方法.txt权限...
-
编辑 删除
a
替代wmsys.txt分析表和索引.txt低效率识别.txt字符串切割成行.txt查询分区表select * from tab_a partition(tab_a_b);truncate分区表 alter table tab_a truncate partition tab_a_b;
-
编辑 删除
sid
DBA查找sid、sql，运行次数.txtdbms查看执行计划.txtlog err的用法.txt查看当前用户运行的sql.txtparallel.txt
-
编辑 删除
阻止并发--锁
my_package_并发.txt
