oracle常用维护SQL

　　1.----查某session当前正在执行的sql　　SQL>select s.sid,sql_text from v$session s,v$sql q　　where s.SQL_ADDRESS=q.address and s.sql_hash_value=q.hash_value　　and s.sid in (45,48,107)  and s.serial# in (53098,54004,44803);　　2.--查事