We are running into something strange. We have queries on the data
dictionary hanging, while other queries appear to run correctly. We are in
Oracle 10gR2 on AIX. It appears that Patrol is doing something that manages
to hang itself and any other query or update on the data dictionary, such as
statspack snapshots and statistics jobs. We end up having to kill patrol
and the other jobs to get things working again. Has anyone else seen this
or have an idea what is going on?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 18 2007 - 10:46:10 CST
