A collection of scripts I have found useful. Please let me know if you like ’em.
Show Sessions at the SQL Prompt
Which database are you connected to, and what are your session details?
What resources did my query use?
Only command-line SQL access, but you want to see a SQL trace analysed?
An Oracle collection 