Watch Oracle DB Session Activity With My Real-Time Session Sampler
Watch Oracle DB Session Activity With My Real-Time Session Sampler
For details about this tool, I created a special posting in my blog, A Wider View. Have a look! http://blog.orapub.com/20140811/Watch...
The rss.sql tool is included in the OraPub System Monitor (OSM) toolkit (v13j), which can be downloaded http://resources.orapub.com/OSM_OraPu...
Watching session activity is a great way to diagnose and learn about Oracle Database tuning. There are many approaches to this. I wanted something simple, useful and modifiable. I wanted no Oracle licensing issues. And, I wanted something I could give away. The result is what I call the Oracle Real-Time Session Sampler (OSM: rss.sql).
The tool is simple to use. Based on a number of filtering command line inputs, it repeatedly samples active Oracle sessions and writes the output to a file in /tmp. You can do a "tail -f" on the file to watch session activity in real time!