These sqlplus scripts are for Oracle Database performance optimization & troubleshooting. Most of the scripts should be runnable directly from SQL Developer too.
To get an idea of how I set up my client environment and use some of my main Oracle-related scripts, check out the videos here:
Also you can follow me in Twitter as I'll post any noteworthy updates there: