Oracle Database Discussions

Hi. We have a process extracting data from an Oracle database via JDBC connection. In general, the process takes more than 4 hours to extract 7-8 millions rows of data into a flat file. At the first 2-3 hours, the entire process is totally idle, and total rows were 32k. During that period of time, the temp tablespace is fine; the session is still active, but CPU is idle. Does anyone have any clues the root cause of data extraction is stuck?

Thanks.