Monday 21 January 2019

Important Document Lock Objects

Lock Objects
Tables - dba_waiters & dba_blockers
Query -

select   c.owner,  c.object_name,  c.object_type,  b.sid,  b.serial#,
  b.status, b.osuser, b.machine, a.locked_mode
from
  v$locked_object a , v$session b, dba_objects c
where
  b.sid = a.session_id
and a.object_id = c.object_id;

Killing the process

ALTER SYSTEM KILL SESSION 'sid,serial#';





I found the, or a, solution:
The key step I was missing was how to find the Hardware Wizard:
  1. Click the Start menu.
  2. Search for “cmd".
  3. Right-click on “cmd” and select “Run as Administrator”
  4. Enter “hdwwiz.exe”
From that point on it's the same approach as under Vista, i.e.:
  1. In the "Welcome to the Add Hardware Wizard", click Next.
  2. Select "Install the hardware that I manually select from a list (Advanced)" and click Next.
  3. Scroll down and select "Network adapters" and click Next.
  4. Select under Manufacturer "Microsoft" and then under Network Adapter "Microsoft Loopback Adapter" and click Next.
I've tested this and it's working for me (connecting the host to a VPC using the loopback adapter).

No comments:

Post a Comment