运行程序,然后用sys用户查看当前正在运行的sql:
select OSUSER, USERNAME, SQL_TEXT from V$SESSION a, V$SQLTEXT b
where a.SQL_ADDRESS = b.ADDRESS
order by ADDRESS, PIECE;
select OSUSER, USERNAME, SQL_TEXT from V$SESSION a, V$SQLTEXT b
where a.SQL_ADDRESS = b.ADDRESS
order by ADDRESS, PIECE;
解决方案 »
- sql*loader这个工具现在还用不用了?
- oracle高级问题,请教高手
- public void getT_STU_INFO_LIST() throws Exception {
- 访问oracle数据库
- 请高手解释一段代码
- 如何只能让指定的IP地址或计算机名称登录Oracle服务器
- 在PL/SQL中,游标关闭与不关闭有什么区别,对程序的影响怎么样?请高手解答下
- 产品类型查询后得到它下面的所对应产品名称分组有问题
- oracle8的问题
- 请问Oracle 8i中的Oracle Intelligent Agents在何处设定?如何设?
- 请教一个SQL语句
- oracle8i数据库导入的问题?-----怪问题
能看到具体参数的实值?
比如传给ORACLE 参数pName = 'KING' pSex= 'B' pAge =null
Select * From Emp
where (Name =:pName or :pName is null) and (Age =:pAge or :pAge is null) and (Sex =:pSex or :pSex is null)
Additionally, setting the initialization parameter SQL_TRACE = TRUE causes the
SQL trace facility to generate performance statistics for the processing of all SQL
statements for an instance and write them to the USER_DUMP_DEST directory.
Optionally, trace files can be generated for server processes at user request.
Regardless of the current value of the SQL_TRACE initialization parameter, each
session can enable or disable trace logging on behalf of the associated server process
by using the SQL statement ALTER SESSION SET SQL_TRACE. This example
enables the SQL trace facility for a specific session:
ALTER SESSION SET SQL_TRACE TRUE;====================================================
Caution: Because the SQL trace facility for server processes can
cause significant system overhead resulting in severe performance
impact, enable this feature only when collecting statistics.