System running slow

Hi Guys

I am running following scripts when users complains system slow. Usually I found more transaction there running from a developer.

I just want to know how to explain locked_mode in v$locked_object view. Usually in my case is 3. I looked oracle Reference but it did' mention what is meaning. Anybody has any idea.

I also want to know what other dba usually do when somebody complained about SLOW .

Mitchell

attached sql

• lockd.sql set pages 1000 set lines 132 select substr(do.owner, 1, 10) "Owner", substr(do.object_name, 1, 25) "Object ", lo.locked_mode, substr(lo.oracle_username, 1, 10) "Username", lpad(rtrim(substr(lo.os_user_name, 1, 8),' '),8,' ') "OS User", lo.session_id, vs.serial#, ' ' " ", lo.process, substr(to_char(vs.logon_time,'DD-MON-YY HH24:MI:SS'),1,20) "Logon Time" from dba_objects do, v$locked_object lo, v$session vs where do.object_id = lo.object_id and lo.session_id = vs.sid