set role plustrace

Just spent an hour trying to configure autotrace in Oracle 10.2.0.3.0. It turns out that in addition to granting plustrace role to a user and creating a PLAN table, you also need to enable the plustrace role in the user's session using "SET ROLE PLUSTRACE;"

Read comments at the bottom of Tom Kyte's autotrace topic.