Varun; I think I have mailed you this before, to log the sql queries within RT you need to add the following line to you RT_SiteConfig.pm file # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be # the level that you wish SQL statements to be logged at. Set($StatementLog,1);
Then restart the web server, at that point any sql query called will be logged to your rt.log file, if not enough logging is been written you can increase the level of logging by increasing 1 to 2 or 3 (not sure what each level log). Also I would recommend you log at the sql level , not sure about Oracle but I am sure there is a tool or variable to allow you to log slow queries some where, or you can once you do show queries from the oracle commend line during creating a ticket. By the way what version of DBIx::SearchBuilder and DBD you have installed, have you googled for common problems with the versions you have installed. You can determine the version of modules you have installed by browsing to your: https://YOUR_RT_URL/Admin/Tools/Configuration.html Roy Varun wrote: > > Hello All > > > > I want to trace queries that are dynamically firing in RT to track > where they are making application slow. But I m not able to find out > from where all queries are fired and from which file. My main concern > is to trace Insert query for ticket creation and Update queries. Do > any one has idea where I can find all this queries in which file. > > > > Any help is highly appreciated. > > > > Thanks & Regards > > Varun Vyas > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com