oracle核心技术学习记录

select t2.pid from v$bgprocess t1,v$process t2 where t1.name='LGWR' and t2.addr=t1.paddr;
select * from x$ksmfsv where ksmfsnam like 'kcbn%';--找出SGA中的变量名
select * from x$kcrfstrand;---私有redo区，处理“前滚”改变向量
select * from x$ktifp;---处理undo改变向量
select * from v$transaction;
select ktiffcat,ktiffflc from x$ktiff;
select * from v$sysstat;
---事物ID的获取方式
select xidusn,xidslot,xidsqn from v$transaction;
select trunc(id1/65536) usn,mod(id1,65536) slot,id2 wrap,lmode from v$lock where type='TX';
---无需转储块就可以看到事物表信息
select indx,
       ktuxesta,
       ktuxecfl,
       ktuxesqn   wrap#,
       ktuxescnw  scnw,
       ktuxescnb  scnb,
       ktuxerdbf  dba_file,
       ktuxerdbb  dba_block,
       ktuxesiz   nub
    from x$ktuxe
      where  ktuxeusn=9
         and ktuxeslt<=5;

 

---oradebug用法

select t2.pid from v$bgprocess bgp,v$process t2 where t1.name='LGWR' and t2.addr=t1.paddr;


oradebug setorapid 6
oradebug suspend
oradebug resume
oradebug setmypid
oradebug tracefile_name
alter session set tracefile_identifier= xxx;
oradebug tracefile_name


oradebug setmypid
oradebug dumpvar sga kcbnhb