查看当前(其它)会话的资源使用

最新推荐文章于 2021-04-29 06:38:07 发布

原创最新推荐文章于 2021-04-29 06:38:07 发布 · 400 阅读

0 ·

CC 4.0 BY-SA版权

ORA-Tuning 专栏收录该内容

21 篇文章

订阅专栏

本文深入探讨了SQL查询的高效写法与应用实例，通过具体代码展示了如何利用SQL进行复杂数据检索与分析。

SELECT A.SID,a.STATISTIC#, B.NAME, B.CLASS, A.VALUE
FROM V$SESSTAT A, V$STATNAME B
WHERE A.STATISTIC# = B.STATISTIC#
   AND A.SID = 25
   AND (b.name LIKE '%ga %'
   OR b.NAME LIKE '%direct%');

--===================mystat.sql=======================

set echo off
set verify off
column value new_val V
define S="&1"
set autotrace off
select a.name, b.value from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
/

set echo on

--===================mystat2.sql===================

set echo off
set verify off
select a.name, b.value V, to_char(b.value-&V,'999,999,999,999') diff
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
/

set echo on