sql didn't finish running, sth went wrong

[cyg3003]

hi all ,

I really need your help. I connect to oracle db with input tool which contains a string of sql:

when select count(*) from table A, the result is : 48067.

when select * from table A, the input tool is always 0% and won't stop.

i executed the sql in db, it works but the rows of result was 6878, count result was 6878.

does anyone have any idea what's wrong with the db? 

[cyg3003]

for input tool in alteryx, 

when select * from table A where rownum <= 10, the input tool will run properly and give the result.