orcle中能够查询出一条记录的哪个会话或用户写入的吗?最好还能查到是哪个客户端操作的。谢谢。100相送

Question

问题如题目.
2006-10-19

Answer 1

http://community.csdn.net/Expert/topic/5028/5028671.xml?temp=.2130396

Answer 2

--查看命中率低的users_session_SQL
sELECT A.sQL_TEXT,eXECUTIONS,dISK_READS,bUFFER_GETS,hit_radio,READS_PER_RUN,
B.MACHINE,B.USERNAME,B.PROGRAM 
FROM (
select sql_text,executions,disk_reads,buffer_gets,
round((buffer_gets-disk_reads)/buffer_gets,2) hit_radio,
round(disk_reads/Executions,2) Reads_Per_Run,
ADDRESS 
from V$Sqlarea
where Executions >0 and Buffer_Gets>0 and (Buffer_gets-disk_reads)/Buffer_Gets <0.8
order by 5 Desc) a,v$sESSION B 
WHERE A.ADDRESS = DECODE(B.SQL_HASH_VALUE,0,B.PREV_SQL_ADDR,B.SQL_ADDRESS) AND B.TYPE='USER'

Answer 3

使用toad工具的Session Browser功能 。