SP2-0618 on 11.2.0.3.0 - 64bit Production
Hi All,
I have just setup 11gR2 standard edition with latest patch ("Database Patch Set Update : 11.2.0.3.5 (14727310)") applied.
I came across following :
SYSTEM> grant plustrace to scott;
Grant succeeded.
Elapsed: 00:00:00.01
SYSTEM> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
$
$
$ sqlplus scott/tiger
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 24 11:14:16 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> set autot on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL> select * from session_roles;
ROLE
------------------------------
CONNECT
RESOURCE
PLUSTRACE
Execution Plan
----------------------------------------------------------
0