'Oracle' Tag

• dba_objects中object_id/data_object_id

  10月 7, 2009

  具体见下面链接： what is data_object_id? dba_objects中的data_object_id列的含义

  posted in 其他 by | 编辑

• SQL TRACE

  05月 30, 2009

  1、跟踪当前session --alter session set tracefile_identifier='mytrace'; alter session set sql_trace=true; alter session set sql_trace=false; alter session set  events '10046 trace name context  forever,level 12'; alter session set events '10046 trace name context off'; --读取当前session的event级别 set serveroutput on declare   event_level number; begin   for event_number in 10000 .. 10999 loop     sys.dbms_system.read_ev(event_number, event_level);     if (event_level [...]

  posted in Oracle 知识杂记 by | 编辑