Some time ago I wrote about the problems of disabling the automatic workload repository (AWR). In one of the comments, John Boogaard asked the question: “Can you just run script: ?/rdbms/admin/catnoawr.sql instead ?”
I finally upgraded my test machine to 10.2.0.3 – and the answer to this remarkably simple question is yes.
The script calls procedure dbms_swrf_internal.remove_wr_control, which deletes a row relating to your database from the wrm$_wr_control table, and then drops all the AWR tables.
If you change your mind, by the way, there is no equivalent catawr.sql script. There are four different scripts related to building the stuff you need for AWR, but you are probably better off calling catsvrm.sql – which rebuilds all the “manageability” bits of 10g, and deals with the complicated interdependencies between objects and routines used by the various bits of AWR, ASH (active session history) and the rest.