My sqlplus session hangs when I try to use this sql statement:
select * from dba_jobs_running;
However, it was not the first time it happened. In fact the first time it hanged occurred just a few minutes before that statement was ran. I was trying to remove a job:
When I pressed enter after the forward slash, my session hanged and I could not do anything. I know I misspelled "dbms_job" and unwillingly added an "s" at the end. I had to Ctrl Alt Del out of it and restart a new session.
Ever since that moment, I have been unable to perform the query above or do anything relating to dbms_job package. I am now stuck.
Does anyone have any idea how I can resolve this issue?? Your help is greatly appreciated and I thank you in advance.