332 show parameter user_dump_dest; |
332 show parameter user_dump_dest; |
333 |
333 |
334 Sessions and locks |
334 Sessions and locks |
335 ================== |
335 ================== |
336 |
336 |
337 Select locked objects:: |
337 List locked objects:: |
338 |
338 |
339 select * from v$locked_object; |
339 select * from v$locked_object; |
340 |
340 |
341 select * from v$locked_object a, all_objects b |
341 select * from v$locked_object a, all_objects b |
342 where a.object_id = b.object_id; |
342 where a.object_id = b.object_id; |
355 b.osuser, |
355 b.osuser, |
356 b.machine |
356 b.machine |
357 from v$locked_object a, v$session b, dba_objects c |
357 from v$locked_object a, v$session b, dba_objects c |
358 where b.sid = a.session_id and a.object_id = c.object_id; |
358 where b.sid = a.session_id and a.object_id = c.object_id; |
359 |
359 |
|
360 select * from DBA_BLOCKERS; |
|
361 select * from DBA_DDL_LOCKS; |
|
362 select * from DBA_DML_LOCKS; |
|
363 select * from DBA_LOCK_INTERNAL; |
|
364 select * from DBA_LOCKS; |
|
365 select * from DBA_WAITERS; |
|
366 |
360 Kill session:: |
367 Kill session:: |
361 |
368 |
362 alter system kill session 'SID,SERIAL#'; |
369 alter system kill session 'SID,SERIAL#'; |
363 alter system kill session '361,565'; |
370 alter system kill session '361,565'; |
|
371 |
|
372 List session parameters:: |
|
373 |
|
374 select * from v$parameter; |
|
375 select NAME, VALUE from v$parameter; |
|
376 |
|
377 show parameters ddl_lock_timeout; |
|
378 |
|
379 Alter session parameter:: |
|
380 |
|
381 alter session set ddl_lock_timeout = 10; |
364 |
382 |
365 Installing express edition |
383 Installing express edition |
366 ========================== |
384 ========================== |
367 |
385 |
368 Disable APEX port |
386 Disable APEX port |