Re: [log4plsql] Enhancement suggestion: log the SID

[log4plsql g. m. l. <log...@li...>]

Hi Mark,

Only SID will not help in case of connection pooling with Java application
servers. We need a mechanism to

1) Log a unique identificaiton per jdbc call. This can be a random number
generated / Starting timestamp in Log4PLSQL context for that call.
2) Currently I am loggin following into TLOG.LTEXTE but it is still not
helpful as the same identifier is repeated in case the same connection is
reused by application server.

I am using userenv('sessionid')||' : '||pLTEXTE

We use the same technique in Java logging to create a unique identifier per
server call. I am planning to add that identified in session and add that to
log messages instead of SID.

Please comment if such a feature will be useful for anyone else using this
project.

Regards
Nitin


log4plsql-all-info mailing list wrote:
> 
> When looking through my TLOG file, messages logged from many different
> sessions are interleaved. It would be useful to be able to filter a view
> by the SID from which the messages were generated. I feel that this
> would best be handled by adding a new column to the TLOG table and
> enhancing the code to automatically populate this column when inserting
> a row.
> 
>  
> 
> ______________________________________________________
> 
> Mark Freeman | Data Architect | Click4Care, Inc.
> 
> 50 South Liberty Street | Suite 200 | Powell, OH 43065
> 
> Email: mfr...@cl... <http://www.click4care.com> 
> 
>  
> 
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> ahead of the curve. Join us from November 9&#45;12, 2009. Register
> now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Log4plsql-all-info mailing list
> Log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
> log4plsq : http://log4plsql.sourceforge.net
> 
> 

-- 
View this message in context: http://www.nabble.com/Enhancement-suggestion%3A-log-the-SID-tp25695283p25722070.html
Sent from the log4plsql-all-info mailing list archive at Nabble.com.