Here’s an odd little observation that came out of the UKOUG conference last week:
If you’re running 10g, and don’t have the relevant performance pack and diagnostic licences there are various views you are not allowed to query, packages you are not allowed to run, and reports you are not allowed to read.
To support the performance diagnostics, though, your database is probably churning away constantly dumping all sorts of useful data into the memory structures and tables that you are not allowed to access.
But that’s no longer a problem – it looks as if you can disable the AWR collection very easily in 10.2 with the following procedure call:
execute dbms_workload_repository.modify_snapshot_settings(interval => 0)
There’s just one problem with this – you can’t run this package unless you’re licensed to run the AWR. So if you want to disable the AWR, it looks like you have to pay to run it first.