OraFAQ Forum: Server Utilities » Naming user trace files

Home » RDBMS Server » Server Utilities » Naming user trace files (10.2.0.1.0, WIN XP)

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

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?

Report message to a moderator

Re: Naming user trace files [message #328856 is a reply to message #328843]

Mon, 23 June 2008 01:55

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

use the user_name (USER) and run EXECUTE IMMEDIATE 'alter session set tracefile_identifier =||'''||user_name||''' but don't think this will help

Why? Did you try it? (After fixing the syntax errors)

Regards
Michel

Report message to a moderator

Re: Naming user trace files [message #328867 is a reply to message #328856]

Mon, 23 June 2008 02:59

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Yes..it did work

I thought the trigger would execute in the DBA schema (who owns it) but I was wrong the trigger runs on every schema individually.

Thanks

Report message to a moderator

Previous Topic:	how to store a data in client a few time and send a data to the server
Next Topic:	Field concatenation during load using SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 14:36:06 CDT 2024