Tuesday, March 17, 2009

set role plustrace

Just spent an hour trying to configure autotrace in Oracle 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.

No comments: