{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 霸刀☆藐视天下 的问题《How can I monitor SQL activity on Oracle? [closed]》','https://www.manongdao.com/q-325815.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I'd like to find a tool for Oracle that is similar to the SQL Server Profiler, but a cursory search hasn't yielded any good results. I just want to see, in real time, the queries that my application are making against the database.
Any suggestions?
相关问题
- Can I skip certificate verification oracle utl_htt
- how to calculate sum time with data type char in o
- keeping one connection to DB or opening closing pe
- System.Data.OracleClient not working with 64 bit O
- How can I get rid of dynamic SQL
相关文章
- node连接远程oracle报错
- oracle 11g expdp导出作业调用失败，提示丢包。
- 执行一复杂的SQL语句效率高，还是执行多少简单的语句效率高
- Oracle equivalent of PostgreSQL INSERT…RETURNING *
- Difference between FOR UPDATE OF and FOR UPDATE
- Oracle USING clause best practice
- Is there a method in PL/SQL to convert/encode text
- PHP PDO installation on windows (xampp)
AWR (automatic workload repository) is the most obvious answer. There's a description here.
But Oracle Enterprise Manager has better interface. Read about it here. You have to pay extra, but it gives you the interactivity you're looking for.
PL/SQL Developer from Allround Automations is what we use here. More geared towards developers, it does have a session browser which will show locks, SQL statements, etc. Also a nice graphical explain plan window. It's cheaper than TOAD (at last look).
Quest software has some really good tools for Oracle. I think that both Foglight Performance Analysis for Oracle and Spotlight do what you're looking for. Not sure for Spotlight though.
The v$ views in Oracle (which a lot of tools use) offer a wealth of information if you have access to them.
Here's an example on askTom to find the sql the current users are executing.