17:25:44 SQL> connect system/manager 已连接。 17:26:01 SQL> column sql_text format a80 17:26:04 SQL> select sql_text from v$sql where rownum<3;SQL_TEXT -------------------------------------------------------------------------------- select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags from coltype$ wh ere obj#=:1 order by intcol# descinsert into t values(to_date('2003-1-4','yyyy-mm-dd'),'C',67)已用时间: 00: 00: 00.32 17:26:04 SQL>
select module,first_load_time,sql_text from v$sql where MODULE='aspnet_wp.exe' order by first_load_time desc
select sid,username,sql_text from v$session a,v$sqltext_with_newlines b 2 where a.SQL_ADDRESS=b.ADDRESS;
12. 监控当前数据库谁在运行什幺SQL语句 SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece; 同時你可以指定某一個SID
已连接。
17:26:01 SQL> column sql_text format a80
17:26:04 SQL> select sql_text from v$sql where rownum<3;SQL_TEXT
--------------------------------------------------------------------------------
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags from coltype$ wh
ere obj#=:1 order by intcol# descinsert into t values(to_date('2003-1-4','yyyy-mm-dd'),'C',67)已用时间: 00: 00: 00.32
17:26:04 SQL>
2. 用 pl/sql developer 工具 "Tools" -> "Sessions" 可以查看每个session所执行过的语句.
你必须要有对v$session的权限
select module,first_load_time,sql_text from v$sql where MODULE='aspnet_wp.exe' order by first_load_time desc
2 where a.SQL_ADDRESS=b.ADDRESS;
where a.sql_address =b.address order by address, piece;
同時你可以指定某一個SID
已经SQL 的状态. 例如:waiting lock.