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: Mon Jul 01 10:00:36 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
