Kbase P123862: How to enable the ORACLE trace for a specific user
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/05/2007 |
|
Status: Unverified
GOAL:
How to enable the ORACLE trace for a specific user
GOAL:
How to check which queries the ORACLE database receives from the DataServer client
FACT(s) (Environment):
Oracle
FIX:
In order to enable the ORACLE tracing for a specific user, a LOGON trigger can be created.
- Connect to the ORACLE database from SQL*Plus
- Type the following query:
create or replace trigger mytrigger after logon on database
begin
if user = '<Your user>' THEN
execute immediate 'alter session set sql_trace=true';
end if;
end;
Note:
Replace <your user> by the Oracle user specified when connecting from Progress/OpenEdge.
- Commit the transaction
commit;
Caution: The user needs to have the ALTER SESSION privilege.