[QUOTE]Originally posted by jmodic
[B]
Originally posted by padma
Extensive use (or abuse) of some dictionary views can have serious impact on the database performance.
That's an overstatement. What do you mean: that nobody should use PATROL, who all the time makes those V$ queries? Come on!

I have tested running long selects with PATROL on and off (which runs quries over the DB). There is no significant difference. And I've done the test against an Oracle Parallel Serevr having hashed locks on SYSTEM! (PATROL having 2 session per instance).