I want the script which can get blocking & locking information from AWR & ASH hist vies and give me the details about session involved and Plus if possible we can provide some suggestions like e.g. Non- index foreign key, application module or dead lock etc....