| Naming user trace files [message #328843] |
Mon, 23 June 2008 01:09  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Hi,
I want to create trace files for every user that logs into the database in which the user name will be reflected so that I can find it easily. I want to accomplish this by using logon system trigger for every login.
tracefile_identifier parameter could help me but I am not sure how
I thought of creating a trigger
CREATE OR REPLACE TRIGGER logintrig
AFTER LOGON ON DATABASE..
use the user_name (USER) and run EXECUTE IMMEDIATE 'alter session set tracefile_identifier =||'''||user_name||''' but don't think this will help
Any way to do this?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
