从Oracle数据库中获取数据

我有一个从oracle同义词读取数据并将其插入sql数据库的应用程序.以前使用的oracle数据库为8g，当前更新为11g.从那天起，我无法通过表格来获取数据.在8g中，我已经获取了将近1,00,000行，但现在我只尝试了20,000行.该应用程序不会引发任何错误，并且在尝试执行查询时也处于空闲状态. />
我的查询非常简单，例如从SynSample中选择*".


在Oracle Sql Developer中，记录正在快速加载.当单独尝试代码时，它会延迟.

谁能帮我取回记录.

I have an application which reads data from oracle synonymn and insert it into sql database. Previously the oracle db used was 8g and currently updated to 11g. From that day i could not table to fetch data.In 8g i have fetched nearly 1,00,000 rows but now iam just trying only 20,000 rows.The application not throwing any error and also being idle once it tries to execute the query.

My query is very simple as like this "Select * from SynSample".


In Oracle Sql Developer,the records are loading fastly. While trying from code alone it gets delayed.

Can anyone help me in fetching the records.