oracle的session（Oracles session）.doc

oracle的session（Oracles session） About Oracle session (2008-05-21 10:23:34) reprint label: oraclesessionnamefromprogramit classification: database technology 1. how do I see the session level wait event? When we adjust the performance of the database, one of the most important reference indicators is the system waiting event. $system_event, v$session_event, v$session_wait of the three view record is the system level and session level wait events, what in the operation of the database to be found by querying the views you can? Is disk I/O, buffer busy, or plug locks, and so on?. By following SQL, you can query what each of your applications is waiting for, thereby adjusting the performance of the database against the information. Select, s.username, s.program, s.status, se.event, se.total_waits, se.total_timeouts, se.time_waited, se.average_wait From, v$session, s, v$session_event, Se Where, s.sid=se.sid, And, se.event, not,SQl*Net%, And, like, s.status, =ACTIVE, And,, s.username, is, not, null 2.oracle queries the locked table and frees session SELECT, A.OWNER, A.OBJECT_NAME, B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, B.ORACLE_USERNAME, B.OS_USER_NAME, B.PROCESS, B.LOCKED_MODE, C.MACHINE, C.PROGRAM, C.STATUS, C.SERVER, C.SID, C.SERIAL#, a. FROM, ALL_OBJECTS, A, V$LOCKED_OBJECT, B, SYS.GV_$SESSION, C WHERE (A.OBJECT_ID = B.OBJECT_ID), AND (B.PROCESS = C.PROCESS), ORDER, BY, 1,2 Release session Sql: Alter, system, kill, session,sid, serial# Alter, system, kill, session,379, 21132 Alter, system, kill, session,374, 6938 3. check occupancy system IO larger session SELECT, se.sid, se.serial#, pr.SPID, se.username, se.status, se.terminal, se.program, se.MODULE, se.sql_address, si.block_changes, st.event, st.p1text, si.physical_reads,... FROM, v$session, Se, v$session_wait, St, v$sess_io, Si, v$process, PR WHERE, st.sid=se.sid, AND, st.sid=si.sid, AND, AND, se.sid6, AND, st.wait_time=0, AND, st.event, NOT, se.PADDR=pr.ADDR, LIKE,%SQL%,, ORDER, BY, DESC, physical_reads 4. f