オラクルのLONG_LOCK

su - oracle
$ sqlplus / as sysdba ------ SYSでログイン

▼セグメントサイズ確認
  ========================================
  spool dba_seg.log
  set lin 600
  set pages 1000
  col name for a10
  col state for a10
  col type for a10   
  --領域の確認。
  select segment_name, sum(bytes) BYTES, tablespace_name, count(*) EXTENTS
  from dba_segments
  group by segment_name, tablespace_name
  order by 2,3,1 desc;

  --セグメント単位ので確認 
  select * from dba_segments order by 1;
  spool off
  ========================================

select BLOCKING_SESSION from v$session where username = 'ARCSDBPA';


select event,seq# from v$session where username = 'ARCSDBPA';


select sql_id from v$session where username = 'ARCSDBPA';

select sql_text from v$sql where sql_id ='fddqym00hh0vc';


select sid,wait_time from v$session where sid=1812;

SQL> select sid,serial# from v$session where sid in (select sid from v$lock where type in ('TM','TX'));


SQL> select sid,program from v$session where username = 'ARCSDBPA';
SID PROGRAM
---------- ------------------------------------------------
1236 ArccCSCS.exe
1248 Furikomi.exe
SQL>

SQL> select sid,serial#,state from v$session where sid=1775;

SQL> select s.sid, p.pid, p.spid from v$session s, v$process p where s.paddr = p.addr and s.sid = 1236;
SID PID SPID
---------- ---------- ------------
1236 94 31458

SQL> select s.sid, p.pid, p.spid from v$session s, v$process p where s.paddr = p.addr and s.sid = 1248;
SID PID SPID
---------- ---------- ------------
1248 29 23382

SQL> oradebug setospid 23382;
SQL> oradebug event 10046 trace name context forever, level 12;
SQL> oradebug event 10046 trace name context off;



SQL> quit

【11g】
/opt/app/oracle/admin/ARCSDBMS/adump　　　　　　　？


【１０ｇ】
/home/oracle/app/oracle/admin/arcsdbms/bdump
/home/oracle/app/oracle/admin/arcsdbms/udump


$ tkprof FILE1 FILE2 explain=USER/PASSWD