I have already made the changes u told me .But still I m not getting any
queries logged in my rt.log(Don’t know why is it bcoz of log level which I
set or something else ). And I have DBIx::SearchBuilder 1.55 and
DBD::Oracle v1.19.From: Raed El-Hames [mailto:email@example.com]
Sent: Thursday, July 02, 2009 2:03 PM
Subject: Re: [rt-users] Query Tracing
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.
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
You can determine the version of modules you have installed by browsing
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