用户登陆即抓取trace文件 CREATE OR REPLACE TRIGGER tr_login_record AFTER logon ON DATABASE DECLARE miUserSid NUMBER; miSerial number; BEGIN SELECT sid INTO miUserSid FROM sys.v_$mystat WHERE rownum

测试环境:Oracle 9.2.0.8 for Windows-64BIT 1. 创建测试表空间 SQL> CREATE TABLESPACE test DATAFILE 2 ‘Y:\TEST01.DBF’ SIZE 10M AUTOEXTEND OFF 3 LOGGING 4 ONLINE 5 PERMANENT 6 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M […]

分析高CPU消耗的脚本 set lines 1000 set feedback off set trims on col username for a12 col en_name for a16 col cn_name for a8 col sid format 9999 col PLAN_OWNER_OBJ_COST_CARD_BYTE for a72 drop table tmp_mon_cp […]

切换到手机版