How to find Current open Cursors in Oracle
select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current';
from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9252210/viewspace-682012/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle:open_cursorsOracle
- How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- Oracle檢視已被使用的open_cursors&session_cached_cursorsOracleSession
- 【CURSOR】How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- open_cursors與session_cached_cursorsSession
- zt_oracle cursor_open cursors_session_cached_cursors管理及優化OracleSession優化
- Monitoring Open and Cached Cursors
- Execute to Parse% 及open_cursors,session_cached_cursorsSession
- How to check whether the current database in using Oracle optionsDatabaseOracle
- How to find Master Node in Oracle RAC(zt)ASTOracle
- Monitoring Open and Cached Cursors(zt)
- 引數 session_cached_cursors 與 open_cursors詳解Session
- SESSION_CURSOR_CACHE open_cursorsSession
- Monitoring Open and Cached Cursors(轉載)
- 修改open_cursors和session_cached_cursors的引數值Session
- 【SQLSERVER】How to check current pool sizeSQLServer
- 關於open_cursors和session_cached_cursors的引數值Session
- Unable to Find Sources for Current Linux KernelLinux
- open_cursor session_cached_cursors 優化Session優化
- dbms_session.set_close_cached_open_cursors(true)Session
- How to Find Out How Much Space an Index is UsingIndex
- 正確設定open_cursors和'session_cached_cursors' 可以減少sql解析SessionSQL
- examples for oracle ref cursorsOracle
- 初始化引數OPEN_CURSORS的理解加深
- How to find the UDID for an iPhone/iPod touchiPhone
- How does SAP freelancer find a project that is not tough?Project
- How do you find that an operation mode switch occurred?
- 【DBA 指令碼】查詢current open cursor的指令碼指令碼
- How to Find Sessions Generating Lots of Redo or Archive logsSessionHive
- Leetcode 1365. How Many Numbers Are Smaller Than the Current Number (cpp)LeetCode
- SQL: How to Find Sessions Generating Lots of Redo or Archive logsSQLSessionHive
- How Oracle Works!Oracle
- How to Study OracleOracle
- How to Find which Session is Holding a Particular Library Cache LockSession
- Oracle Find block in ASMOracleBloCASM
- How to enable trace in OracleOracle
- In Oracle,How to use dumpOracle
- An Example of How Oracle WorksOracle