SQL> SET AUTOTRACE TRACEONLY SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report SQL>He told me that PLUSTRACE role is already enabled. Any help is greatly appreciated.
After logging in, issue the query
select * from session_roles;to make sure that the role is, in fact, enabled.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.