Hi:

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:

begin
dbms_jobs.remove(3);
end;
/

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.

Alex