How to find which sid is doing full table scan

Many times the performance of the database will be slow.We need to first find out  if any big table full table scan is going on. Lets first check out what is Full table scan and then We will see the query to find full table scans in oracle What is Full table Scan Full table […]