Monday, March 21, 2022

Find Session Id Running Specific Query

 SET LINES 300

SET PAGES 999

COL SID FOR 99999

COL SER# FOR 9999999

COL OS_ID FOR A5

COL STATUS FOR A8

COL SQL_FULLTEXT FOR A60

SELECT

   SES.SID,

   SES.SERIAL# SER#,

   SES.PROCESS OS_ID,

   SES.STATUS,

   SQL.SQL_FULLTEXT

FROM 

   V$SESSION SES,

   V$SQL SQL,

   V$PROCESS PRC

WHERE

   SES.SQL_ID=SQL.SQL_ID AND

   SES.SQL_HASH_VALUE=SQL.HASH_VALUE AND 

   SES.PADDR=PRC.ADDR AND

   UPPER(SQL.SQL_FULLTEXT) LIKE UPPER('%CREATE%TABLE%');

No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...