Kay的博客

Oracle 10046 trace追踪脚本查找当前session的10046跟踪日志1、alter session set tracefile_identifier='kay10046';(可选）2、alter session set events '10046 trace name context forever, level 12';3、执行sql statement4、结束跟...

Oracle SQL性能以及监控脚本一、执行计划预估的执行计划:1、explain plan for获取；SQL> EXPLAIN PLAN FOR SELECT * FROM EMP;SQL> SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));或者：SQL> select...

Oracle snapper ASH监控工具snapper工具是由国外技术人员，将基于Oracle ash技术原理用来监控数据库会话的负载情况,比较适合小范围时间监控，可以生成多个快照，例如1小时内，分别生成4份快照，每份快照15min。snapper脚本下载：链接:https://pan.baidu.com/s/193EM_rRozMBE14XSog9csw 密码:l0misnappe...

成功登录的ip会话create or replace trigger trg_login_on after logon on databasebegin dbms_application_info.set_client_info( sys_context('userenv','ip_address'));end;/查询ip登录成功的会话select username,progra...

以sys用户登录—找出library cache lock对应的sidselect sid,saddr from v$session where event= 'library cache lock';SID SADDR---------- --------16 572ed244—根据saddr查找请求（被阻塞）的会话以及对象select kgllkhdl Handle,kgll...

shell脚本实现logmnr分析#!/bin/bash # Created:2019-05-28# Written by:Kay# Description: analyze archivelog using logmnr fetch sql_redo!# Please make happy in analyze log!#ORACLE_SID=ora11g;START_TIME...

Oracle手动rebalance ASM磁盘组SQL> alter diskgroup data rebalance power 5;—>手动对data磁盘组进行rebalanceSQL> set pagesize 200 linesize 200SQL> col error_code for a10SQL> select * from v$asm_op...

Oracle 10035追踪解析失败的SQLSQL> ALTER SYSTEM SET EVENTS '10035 trace name context forever, level 1';SQL> select * from xxxooo;SQL> ALTER SYSTEM SET EVENTS '10035 trace name context off';告警日...