Home » RDBMS Server » Performance Tuning » Sql Tuning Advisor - Privileges (sqltrpt.sql) (Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit)
Sql Tuning Advisor - Privileges (sqltrpt.sql) [message #609917] Thu, 13 March 2014 22:35 Go to next message
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
Member
Hi,

Database - Oracle 11.2.0.3 Enterprise Edition
Server - Linux x86 64-bit

When I execute Sql Tuning Advisor(STA) - "ORACLE_HOME/rdbms/admin/sqltrpt.sql", it works fine for SELECT scripts,
but when execute STA for INSERT / UPDATE scripts it gives one of following error -

ORA-01031: insufficient privileges

ORA-00904: : invalid identifier

--I have verified that I have SELECT privileges on all tables of another schema, also I have following privileges:

ADVISOR,ADMINISTER SQL MANAGEMENT OBJECT,ADMINISTER SQL TUNING SET,
CREATE SESSION,GLOBAL QUERY REWRITE,ADMINISTER ANY SQL TUNING SET,CREATE ROLE.

Could you please help me which privileges are still missing?

Thanks in advance.
Re: Sql Tuning Advisor - Privileges (sqltrpt.sql) [message #609918 is a reply to message #609917] Thu, 13 March 2014 22:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Could you please help me which privileges are still missing?

GRANT INSERT, UPDATE on all tables of another schema,

[Updated on: Thu, 13 March 2014 22:42]

Report message to a moderator

Re: Sql Tuning Advisor - Privileges (sqltrpt.sql) [message #609919 is a reply to message #609918] Thu, 13 March 2014 22:49 Go to previous message
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
Member
Many Thanks for quick reply.

But one query, to execute STA on script (for another schema) my userid also required Insert / Update privileges on another schema tables(Objects) ?

Please correct me, Thanks in advance.
Previous Topic: Incorrect cardinalty estimate when using a local non-prefixed unique index
Next Topic: What is the most expensive dml transaction, insert, update, delete?
Goto Forum:
  


Current Time: Thu Dec 02 16:45:00 CST 2021