1、创建表空间autostrace及用户autostrace。
sqlplus / as sysdba
create tablespace autostrace datafile '/opt/oracle/oradata/iptvgbk/autostrace01.dbf' size 100M autoextend on next 50M;
create user autostrace identified by autostrace default tablespace autostrace;
grant create session,resource to autostrace;
2、创建角色plustrace
SQL> @?/sqlplus/admin/plustrce
3、分配角色plustrace给用户autostrace
SQL> grant plustrace to autostrace;
4、连接用户autostrace
SQL> conn autostrace/autostrace
5、创建表
SQL> @?/rdbms/admin/utlxplan
6、开启auto trace
SQL> set autotrace on