维护oracle用到的一些语句

一.   

       select a.EVENT, a.SQL_ID, a.MACHINE, b.SQL_TEXT,  b.SQL_FULLTEXT,b.FIRST_LOAD_TIME,b.LAST_LOAD_TIME,b.LAST_ACTIVE_TIME
        from v$session a, v$sql b
       where a.SQL_ID = b.SQL_ID
          and a.USERNAME is not null
          and a.STATUS = 'ACTIVE'

 

 

二.      select parsing_user_id,executions,sorts,command_type,disk_reads,sql_text
           from v$sqlarea
           order by disk_reads desc

 

三.          

                   select    *   from    V$session     where   username='VACCUSER'

                   select    *    from    v$locked_object