This content has been marked as final. Show 4 replies
Is it limited to only this table ?
Could you post table info ?
could be due to huge table size,crosscheck this from user_segments view.
select bytes/1024/1024 "MB" from user_segments where segment_name='X';
also check database alert log for any error.
What are you waiting for ?
select event from v$session where sid = <your_sid_session>
Maybe a huge table
Lot or reasons --
1. Table not analyzed
2. Some other query or job running in the DB consuming lots of resources
3. May be even your network traffic is too high