The amount of time it takes to retrieve data blocks is proportionate to the number of extents in the table. Ideally, a table should have one to three extents. Run this script from sqlplus to get those segments (tables or indexes) that have a surplus of extents. Here

DevX Quick Guide to Data Ingestion
One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such