The database is oracle 12c. The table contains 1 million rows.
I am running two sets of queries. The first one -
select * from table_name select * from table_name where rownum <=10
select * from table_name fetch first 10 rows only
The first set does not run and is stuck for a long time while the second set runs just fine. I am not sure how to debug it.
I am sure a normal select does not fetch the whole table at the same time or does it? And when you cancel the query it takes a lot of time too (which I think is kind of okay).
There must be some setup issues but can’t figure that out. I need some help here. Thanks
EDIT: I had to flush Redis and then only things started working. I believe the long-running queries are getting stuck and then subsequent queries are sufferingl