In this page I publish scripts I wrote and use. I think you might find them useful so feel free to use them. If you have any comment, found a bug, or anything else, please let me know.
List all the initialization parameters in your database (including hidden) – post script
Compare all parameters between patches/versions – post script
Tablespace free space – post script script for temp
Map the content of a tablespace – script
Reducing a tablespace size – post file_high_watermark file_hwm_segment
Find a segment by file# and block_id – script
ASM disk information – post list_asm list_disks