Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AutoTrace in TOAD

437601Sep 25 2006 — edited Sep 26 2006
Hi,
I know it's an Oracle Forum and not a TOAD one but the company firewall won't let me at the TOAD forums so apologies first off.

I have to "set role plustrace" before "set autotrace on" in one of our schemas. This works fine in SQLPLUS and also when I run a query as a script in TOAD. But when I try and use the data grid and set autotrace on it tells me I don't have access to v$session.
In another schema where I don't have to set the role it works fine.
I'm using the Oracle plan table and not the TOAD one.

If anyone had any ideas that would be great.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2006
Added on Sep 25 2006
3 comments
1,330 views