v$sql、v$sqlarea中都只存放用户最后执行的一条sql语句吗?sql语句历史记录在哪里呢?
seai 2010-01-28 11:39:49 过程如下:
# sqlplu / as sysdba
SQL> select userenv('sid') from dual;
131
SQL> select 1 from dual;
SQL> select 2 from dual;
SQL> select sid,username,sql_address from v$session c,v$sqlarea s
2 where c.sql_address = s.address(+) and sid = 131
3 ;
只查到一条记录!