Create a script that can be run via cron to periodically gather info about user counts. This can be useful for helping diagnose connection pools that are not releasing their connections.

Set the following variables according to your environment:

Note: The Backslash contained in the v$session reference is so the $ character is escaped properly. If you repurpose this script keep in mind any $ symbols in the text passed to SQLPLUS from the shell script must be escaped in the manner.



OraPad is an Oracle utility program I am writing as a Tuning Scratchpad. I need a place to coordinate my activities when I am in the thick of a tuning issue. Right now it seems like I am using multiple tools and I would like a central place to organize my tuning information and thoughts. Bonus if we are able to wrap some functionality to cut out extra tools required to do the tuning investigation.

SftpDrive - map drives to your windows workstation via SSH...

Just heard about this software today from a satisfied user. SftpDrive is a software package for Windows that allows you to map a SSH server as a Windows network drive. This enables you to use a Windows PC for development but to modify files directly on a Linux/Unix server.

It costs to register the software but they have a 6 week free trial. Considering the amount of time I could save during development I think I will be adding this tool to my dev workstation: https://www.eldos.com/sftp-net-drive/

-- Dave

Subscribe to utilities