What query can be used to see what FULL TABLE SCANS are taking place in the database? How does Oracle decide whether it should perform a FULL TABLE SCAN vs. using an index that is present on the table.

Thanks.