Different small PL/SQL helper scripts for Oracle databases.
Shows the current locked tables with some additional informations like: user, host, sid, lock type, ...
sqlplus system/xxxx@//127.0.0.1:1521/xe @show_table_locks.sql
It generates an output file named show_table_locks.lst in the same directory.
Shows current open sessions. Additional it show the cureent executed SQL.
sqlplus system/xxxx@//127.0.0.1:1521/xe @open_sessions.sql
Shows all table spaces, data files and their current usage.
sqlplus system/xxxx@//127.0.0.1:1521/xe @open_sessions.sql