Locks in Oracle

SELECT c.owner,
       c.object_name,
       c.object_type,
       b.sid,
       b.serial#,
       b.status,
       b.osuser,
       b.machine
  FROM v$locked_object a, v$session b, dba_objects c
 WHERE     b.sid = a.session_id
       AND a.object_id = c.object_id
       AND b.sid IN (SELECT l.session_id
                       FROM dba_lock_internal l
                      WHERE UPPER (l.lock_id1) LIKE '%ILP_REPORTS_PKG%');

SELECT c.owner,
       c.object_name,
       c.object_type,
       b.sid,
       b.serial#,
       b.status,
       b.osuser,
       b.machine
  FROM v$locked_object a, v$session b, dba_objects c
 WHERE b.sid = a.session_id AND a.object_id = c.object_id;

ALTER SYSTEM KILL SESSION 'sid,serial#';

SELECT    'ALTER SYSTEM KILL SESSION '''
       || SID
       || ','
       || SERIAL#
       || ',@1'
       || ''';'
  FROM gv$session
 WHERE status = 'ACTIVE' AND username = 'APEX_PUBLIC_USER';


SELECT * FROM v$access WHERE object IN ('P_ILAPERF_INT_SPLIT','P_ILAPERF_EXT_SPLIT')

select sid, event from v$session_wait where sid in (98,100);

/* Formatted on 6/20/2017 12:01:04 PM (QP5 v5.256.13226.35510) */
SELECT s.sid,
       l.lock_type,
       l.mode_held,
       l.mode_requested,
       l.lock_id1,
          'alter system kill session '''
       || s.sid
       || ','
       || s.serial#
       || ''' immediate;'
          kill_sid
  FROM dba_lock_internal l, v$session s
 WHERE     s.sid = l.session_id
       AND UPPER (l.lock_id1) LIKE '%ILA_PERFORMANCE_PKG%' --   AND l.lock_type = 'Body Definition Lock'

Adding double quote delimiters into csv file

1. open cmd and execute powershell.exe
2. run below command
import-csv D:\Test.csv | export-csv D:\Test_new.csv -NoTypeInformation -Encoding UTF8

Example:

D:\Test.csv

id,name,location

1,raj,Anantapur

2,siva,Hyderabad

3,venki,Bangalore

D:\Test_new.csv

"id","name","location"

"1","raj","Anantapur"

"2","siva","Hyderabad"

"3","venki","Bangalore"

View details of .p12 certificate on windows machine

C:\Users\rajam>certutil -dump D:\Oracle_2019\Certview\Certificates\wsctt_042020\wsctt-wsvcoraclectt.p12

Enter PFX password:

================ Certificate 0 ================

================ Begin Nesting Level 1 ================

Element 0:

Serial Number: 123456789999999

Issuer: CN=Pearson VUE Root Certificate Authority

 NotBefore: 7/28/2012 2:29 AM

 NotAfter: 7/28/2032 2:29 AM

Subject: CN= abc Root Certificate Authority

CA Version: V0.0

Signature matches Public Key

Root Certificate: Subject matches Issuer

Cert Hash(sha1): 123456789999999

----------------  End Nesting Level 1  ----------------

No key provider information

Cannot find the certificate and private key for decryption.



================ Certificate 1 ================

================ Begin Nesting Level 1 ================

Element 1:

Serial Number: 123456789999999

Issuer: CN= abc Root Certificate Authority

 NotBefore: 8/30/2012 1:26 AM

 NotAfter: 8/30/2022 1:36 AM

Subject: CN= abc CTT Certificate Authority, DC=abc, DC=com

CA Version: V0.0

Certificate Template Name (Certificate Type): SubCA

Non-root Certificate

Template: SubCA

Cert Hash(sha1): 123456789999999

----------------  End Nesting Level 1  ----------------

No key provider information

Cannot find the certificate and private key for decryption.



================ Certificate 2 ================

================ Begin Nesting Level 1 ================

Element 2:

Serial Number: 123456789999999

Issuer: CN= abc CTT Certificate Authority, DC=abc, DC=com

 NotBefore: 4/25/2020 1:16 AM

 NotAfter: 4/25/2021 1:16 AM

Subject: E=pvats@.com, CN=wsctt-wsvcoraclectt, OU=abc, O=NCS , L=Bloomington, S=Minnesota, C=US

Non-root Certificate

Cert Hash(sha1): 123456789999999       

----------------  End Nesting Level 1  ----------------

  Provider = Microsoft Enhanced Cryptographic Provider v1.0

Encryption test passed

CertUtil: -dump command completed successfully.