-
编辑 删除
how does to find all events ?
os:linuxdb:10205 1.alter session set events 'immediate trace name events';2.oradebug eventdump <level> sessionprocesssystem
-
编辑 删除
warning:Traceroute response is spanning snapshot intervals.
osw->traceroute traceroute 探测udp使用的port被使用了，会顺序尝试其他端口，导致traceroute执行时间过长
-
编辑 删除
ORA-00600: internal error code, arguments: [12870], [kkdlgon:
1.select dataobj# from obj$ where name='_NEXT_OBJECT' for update; 2. alter table test30 move; 3.create table tets300(id number); alter logORA-00600: internal error code, arg...
-
编辑 删除
parse count(hard) 大于 parse count(total)
Oracle Core Essential Internals for DBAs and Developers上有这样一段话: A few pages back I pointed out in a list of “surprises” that parsing and optimization can occur on anexecute call, this...
-
编辑 删除
模拟dc_sequences上的row cache lock
db：10.2.0.3sqlplus / as sysdbasession 1:create sequence qqq nocache;select * from seq$ where obj#=(select object_id from dba_objects where object_name='QQQ')fro update;session 2:select qqq.nextva...
