Lock Objects
Tables - dba_waiters & dba_blockers
Query -
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;
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:
- Click the Start menu.
- Search for “cmd".
- Right-click on “cmd” and select “Run as Administrator”
- Enter “hdwwiz.exe”
From that point on it's the same approach as under Vista, i.e.:
- In the "Welcome to the Add Hardware Wizard", click Next.
- Select "Install the hardware that I manually select from a list (Advanced)" and click Next.
- Scroll down and select "Network adapters" and click Next.
- 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