Topic: Performance & Tuning >> autotrace error
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| anjali |
Posted: Jan 20, 2004 05:05:57 AM |
Total Post: 2
Joined: Jan, 2003
|
I am working on oracle 9i release 2.
I am logged in as sys user with sysdba privilege
I have run utlxplan.sql & plustrace.sql to get plan_table &
plustrace role. Then i set autotrace on
Gave a sql statement, saw its execution plan.
Then i set autotrace off.
Now when i try creating a table or doing shutdown it gives
an error message insufficient privileges.
when the view session_privs is checked in that session the number of privileges has decreased.
If now again we set autotrace on we get back the privileges
& are able to do create table or anyother work.
WHAT is the reason.
please help
thanks
|
|
|
 Puneet |
| Posted: Jan 20, 2004 08:15:47 AM |  |
|
Total Post: 73
Joined: Mar, 2002
|
Here are the steps to turn on the autotrace.
1. Create plustrace role by running $ORACLE_HOME/sqlplus/admin/plustrce.sql as 'sys as sysdba'.
Looks like you already did that.
2. Grant plustrace to the user where you want to turn on the autotrace.
For example.
Grant plustrace to scott;
Now connect as scott and turn on the autotrace.
Hope it helps.
Regards,
Puneet
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
