Manish, I'm sorry, is not possible for me to test in RAC environement.
I thinck is possible to connect one log4jbackgroud thread by node. I thnick is possible to log en alert or trace file to. If you log in table you will create some performance problem. In every case is necessary to test... Regards Guillaume Moulard -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : mardi 5 octobre 2004 19:35 À : [EMAIL PROTECTED] Objet : [log4plsql] Using Log4plsql with Oracle 9i/10g RAC Is it possible to use log4plsql utility in a Real Application Cluster (RAC) environment? We would like to send log messages to a file using log4jbackgroud process. We have a 3 node configuration and Oracle can run the job on any node based on the load. Your documentation says that log4jbackgroundprocess will open one thread per logsource. If the pl/sql job and log4jbackgroundprocess happen to connect to different instace, they will not be able to talk to each other. Oracle metalink note says that DBMS_PIPE is not cluster aware. Any comments. I guess we can always store the messages in the table (even in RAC) but would like to avoid this because of overhead. Rgds, manish _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
