Home » RDBMS Server » Server Utilities » hanging system
hanging system [message #73811] |
Fri, 16 July 2004 22:30 |
mb
Messages: 51 Registered: March 2001
|
Member |
|
|
hi,
when users hang in a big system (more than 300 users) in running a part of an application how can we find the problem ,how can we find what we must do and from where we must begin.
we use this sql and we find what users hang :
------------------------------------------
select SUBSTR (to_char (logon_time, 'mm-dd,HH24:MI:ss'), 1, 15) date_time,
substr(object_name,1,20) table_name,
substr(oracle_username,1,15) User_Name,
substr(session_id||','|| serial#,1,10)ser , decode(locked_mode,2,'Row Share',3,'Row Exclusive',4,'Share',5,'Share Row Exclusive',6,'Exclusive','?') Lock_Mode,
SUBSTR (Decode (command, 3, 'SELECT',
2, 'INSERT',
15, 'ALTER TABLE',
1, 'CREATE TABLE',
44, 'COMMIT',
6, 'UPDATE',
7, 'DELETE',
8, 'DROP', 76,'DROPSNAPSH',
command), 1, 9
) command
from
v$session s,
all_objects o,
sys.v_$Locked_Object l
where
l.object_id=o.object_id and session_id=sid
order by
object_name,locked_mode
--------------------------
but how can we find more detail about the problem and find what exact sql statement or .... cause problem.
|
|
|
Goto Forum:
Current Time: Tue Aug 27 09:22:42 CDT 2024
|