Shulou(Shulou.com)06/01 Report--

one。 Error description

SQL > set autotrace on;SP2-0618: session identifier could not be found. Enable check PLUSTRACE role SP2-0611: error enabling STATISTICS reporting

two。 Solution.

2.1 Log in to the sys user, find $ORACLE_HOME/SQLPLUS/ADMIN/plustrce.sql, and execute it

> sqlplus / as sysdba > @ $ORACLE_HOME/SQLPLUS/ADMIN/PLUSTRCE.SQL

2.2 Let's open the plustrce.sql to see what's inside.

-Copyright (c) Oracle Corporation 1995, 2002. All Rights Reserved.---- NAME-- plustrce.sql---- DESCRIPTION-- Creates a role with access to Dynamic Performance Tables-- for the SQL*Plus SET AUTOTRACE... STATISTICS command.-- After this script has been run, each user requiring access to-- the AUTOTRACE feature should be granted the PLUSTRACE role by-- the DBA.---- USAGE-- sqlplus "sys/knl_test7 as sysdba" @ plustrce---- Catalog.sql must have been run before this file is run.-- This file must be run while connected to a DBA schema.set echo ondrop role plustrace;create role plustrace;grant select on v_$sesstat to plustrace;grant select on v_$statname to plustrace;grant select on v_$mystat to plustrace Grant plustrace to dba with admin option;set echo off

The purpose of creating the role of plustrace is clear:

We use SET AUTOTRACE on SQL*PLUS. STATISTICS uses the role of plustrace to obtain dynamic performance table information. When each user requests to use this command, it is automatically granted permission to the plustrace role by the DBA user.

Reference: http://docs.oracle.com/cd/B10500_01/server.920/a96533/autotrac.htm

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.