Im attempting to run some queries on the data dictionary and they should run in about 5 seconds. They are hanging.

So I checked v$lock. DBWR has 12 locks and LGWR has 1 lock. I checked v$locked_object, no objects are locked. No other processes are running.

Where do I go now to investigate this further?

Oracle LazyDBA home page