V $ session table is more commonly used in the table Description ^ _ ^ 1. SID, Serial # With SID we can query various statistics related to this session, process information .a. SELECT * FROM V $ sessstat where sid = : SID; Query users related statistics. Select A.SID, A.Statistic #, B.Name, A.ValueFrom V $ SESSTAT A, V $ statname bwhere a.statistic # = B.Statistic # and A. SID =: sID; b. Query users related IO statistics Select * from v $ sess_io where sid =: sID; c. Query users want to be open, the cursor variables are being opened .Select * from V $ open_cursor where sid = : SID; d. Query the current wait for users. To see why the current statement is so slow / waiting for what resources .Select * from v $ session_wait where sid =: sid; e. Query users waiting for each time Information about the event. To understand the bottleneck encountered by this session ^ _ ^ Select * from V $ session_event where sid =: sID; f. Also, when we want Kill, you can pass SID, serial # Handling .alter system kill session ': SID,: SERAIL #'; 2. Paddr. Field, process addr, through this field we can view information about the current process, system process ID, operating system user information, etc. SSELECT A. PID, A.SPID, B.Name, B.Description, a.latchwait, a.latchspin, a.pga_used_mem, a.pga_alloc_mem, a.pga_freeable_mem, a.pga_max_memfrom v $ process A, V $ bgProcess bwhere a.addr = B.Paddr =: paddr =: paddr3. Command field indicates the type of statement that is currently executing. Please refer to Reference.4. Taddr The address of the current transaction, you can view the current session through this field SSION is executing transaction information, using a returning segment information, etc. 5. Lockwait field, you can check out the relevant information of the lock currently waiting to be launched .Select * from v $ lockwhere (id1, id2) = (SELECT ID1, ID2 from V $ lock where kaddr = '57c68c48') 6 . (sql_address, sql_hash_value) (prev_sql_addr, prev_hash_value) according to both sets of fields, we can check the details of the current session .select sql statement being executed * from v $ sqltext where address =: sql_address and hash_value =: sql_hash_value; 7 .Row_wait_put #, row_wait_file #, row_wait_row # can query the information currently being locked by these fields. ^ _ ^ A. First get the lock information Select * from dba_objects where object_id =: row_wait_obj #;
