![]() ![]() ||rpad('LIOs/Row : '||round(sqa.buffer_gets/decode(sqa.rows_processed,0,1,sqa.rows_processed),2),40) ||rpad('Buffer Gets : '||sqa.buffer_gets,40) ||rpad('Rows Proc : '||sqa.rows_processed,40) ||rpad('Executions : '||sqa.executions,40) ||rpad('OS Client PID: '||ses.process,40) Select ses.sid, ses.serial#, 10 rec_num, 1 line_num, how to get the sql text from sid in oracle set verify off pages 50000 linesize 80 heading off feedback off To_char(s.logon_time,'DD-MON-YY HH24:MI:SS') Logon_Time, Prompt "Enter the Oracle Session ID (SID) user in question" Query to get session details in oracle col sid format 9999 how to check the number of connections in oracle.how to check inactive sessions in oracle.how to find sql query using sql_id in oracle.How to check whether stats are current for the objects involved in SQL query.Query to show the Bind Variable for a Given SQLID.To Find Historical Plans from the AWR Using SQLID.Query to find what sid is doing a full table scan.Query to check all the stats for the session.Query to check CPU consumption of the session.How to check the sql query history of the session.To find out the wait events for this session.Query to find the wait history for the particular SID.how to get the sql text from sid in oracle.
0 Comments
Leave a Reply. |