| Permission issues while using sql trace (merged) [message #416890] |
Wed, 05 August 2009 01:03  |
ashish1986
Messages: 12
Registered: July 2008
|
Junior Member |
|
|
Dear All,
Regards of the Day
I am cureently managing a 10.2.0.4 Oracle DB Server on Linux.
We have a dedicated performance team which does performance testing and enhancement.
For this purpose they need traces quite often.
I don't wish to share either the unix login or the sysdba login with them.
Is there any other way possible in which they can generate sql trace of the applcation.
There are other logins on the unix server as well.
Can those be used.
|
|
|
|
|
|
|
|
| Re: Permission issues while using sql trace [message #416903 is a reply to message #416894] |
Wed, 05 August 2009 01:35  |
ashish1986
Messages: 12
Registered: July 2008
|
Junior Member |
|
|
Dear Michael,
thank you fpr your reply.
I have shared the udump directory and also set theparamter to true.
However when i use some another unix login on the same server
with a db user without dba privileges .
I get the following error:
SQL> exec dbms_system.set_sql_trace_on_session('543','12393',true);
BEGIN dbms_system.set_sql_trace_on_session('543','12393',true); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_ON_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have given
SQL> grant select on v_$session to dbuser;
Grant succeeded.
SQL> grant select on v_$process to dbuser;
Grant succeeded.
SQL> grant select on v_$instance to dbuser;
Grant succeeded.
SQL> grant all on dbms_system to dbuser;
Grant succeeded.
But it still does not work..
Please suggest.
I wpould like to restate :
My objective was to take an sql trace from a DB User without having dba privileges and from a unxi login other than oracle.
Thanks and Regards
Ashish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
