DBA locks

 DBAlocks

select * from DBA_DDL_LOCKS

ALTER SYSTEM KILL SESSION <session_id, <serial_no>;

find out the session_id and serial_no of that

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

ALTER SYSTEM KILL SESSION 'sid,serial#';

SELECT * FROM DBA_DDL_LOCKS

WHERE NAME LIKE 'XXSRI_PO_ACK_IMPORT'

ALTER SYSTEM KILL SESSION (507,)

SELECT * FROM v$session

ALTER SYSTEM KILL SESSION '103,24392' IMMEDIATE 

ALTER SYSTEM KILL SESSION IN(204,80)

SELECT * FROM v$session WHERE SID IN (103)

  

Oracle/PLSQL: Oracle System Tables

 

ALL_SOURCE

 

CREATE TABLE APPS.SriTEST

(

  A  VARCHAR2(2000),

  B  VARCHAR2(2000),

  C  VARCHAR2(2000),

  D  VARCHAR2(2000),

  E  VARCHAR2(2000)

)

 

CREATE TABLE APPS.sritest

( A  VARCHAR2(2000),B  VARCHAR2(2000),C  VARCHAR2(2000),

  D  VARCHAR2(2000),E  VARCHAR2(2000))

 

SELECT * FROM SriTEST

 

INSERT INTO SriTEST(a,b,c) VALUES (l_document_id,l_item_id,l_vendor_id);

COMMIT;

 SELECT

S.USERNAME, S.SID, S.SERIAL#, SQL_TEXT, S.SQL_ID

FROM

V$SESSION S,

V$SQLTEXT_WITH_NEWLINES T

WHERE S.SQL_ID IS NOT NULL

AND S.SQL_ID = T.SQL_ID

AND SID=282

ORDER BY S.SID,T.PIECE;

 Select * from v$sql

where SQL_ID = '15dptjqg3h'