Re: Impact on Enabling API/SQL Logs in Production environment

[Vaibhav Singhal]

** Hi Sathish,   I faced a similer kind of issue, and we enabled API Logs, yeah it'll impact the performance....but it depends on the structure of your system.   We used to do these kinda stuff on weekends/non working hours....and used to script server to manage the load. It took around a month in tracking down the issue, and a patch was released by BMC for the same.     Regards, Vaibhav   From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Sathish Kumar P [p.sathishku...@gmail.com] Sent: Tuesday, December 21, 2010 10:44 AM To: arslist@ARSLIST.ORG Subject: Impact on Enabling API/SQL Logs in Production environment ** Hi All,   We are currently in ARS 7.1 with ITSM 7.03 with Oracle10g in Solaris10 Operating system.   We had seen in the recent past whenever a server crash happens due to unknown reasons, BMC support request for the API and SQL Logs to diagnoize, which we have not enabled in our Production environment.   I had raised BMC issue on the same,but got different response each time, where  they say it will impact the performance and it will NOT impact the performance, so need your help very much..   My thought was if I can get confirmation that enabling API/SQL logs will not cause any performance impact, i will enable the API and SQL Logs and have a monitoring script which backups up the API and SQL Logs for every 1 hour so that my application file system space is not getting fulled.   I hope some of you would have come across this situation, and it would be of great help if you can share your view.   Regards Sathish _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ::DISCLAIMER:: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ----------------------------------------------------------------------------------------------------------------------- _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_