http://bit.do/dSPa5 Secret sale page at EasyFrom.
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-Oracle-DB-Session-Activity-With-The-Real-Time-Session-Sampler.html The rss.sql tool is included in the OraPub System Monitor (OSM) toolkit (v13j), which can be downloaded http://resources.orapub.com/OSM_OraPub_System_Monitor_p/osm.htm 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!
Niciun comentariu:
Trimiteți un comentariu