OraFAQ Forum: Performance Tuning » Sql Tuning Advisor

Home » RDBMS Server » Performance Tuning » Sql Tuning Advisor - Privileges (sqltrpt.sql) (Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Tuning Advisor - Privileges (sqltrpt.sql) [message #609917]

Thu, 13 March 2014 22:35

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.

Report message to a moderator

Re: Sql Tuning Advisor - Privileges (sqltrpt.sql) [message #609918 is a reply to message #609917]

Thu, 13 March 2014 22:41

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

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 06:50:47 CST 2024