1 generate e-r diagram from the database。
2 I can choose to view the primary key and foreign key only in the E-R diagram. Hide those less important columns in the diagram.
1 generate e-r diagram from the database。
2 I can choose to view the primary key and foreign key only in the E-R diagram. Hide those less important ...
查询某台机器的正在执行sql语句(去掉最后一行就是查询所有正在执行的sql语句):
select a.sql_text,c.spid,b.program,b.process,b.STATUS,b.MACHINE,b.OSUSER,b.sid
from v$sqlarea a,v$session b,v$process c
where a.address=b.sql_address
and a.hash_value=b.sql_hash_value
and b.paddr=c.ADDR
and b.MACHINE='MACHINE NAME';
查询自数据库启动以来执行的sql可以参考2楼的语句,或者查v$sqlarea