Subject | Re: Can I trace SQL Statements issued from a client application? |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-05-12T09:58:36Z |
--- In firebird-support@yahoogroups.com, "KIMURA, Meiji" wrote:
I don't know of any way to see all the statements that are sent to the
server - although I'm not certain this is because it does not exist;
it may also be because of my lacking knowledge. Though if you use IBO,
I do know it is possible to use a TIB_Monitor in your application to
see the statements IBO issues within that application.
HTH,
Set
> Hi All,Hi Meiji!
> I want to trace SQL statements issued from the client
> application, in order to omit (or optimize) redundant SQLs for
> tuning. Is there any method to trace SQL statements (like a
> V$SQL_TEXT in Oracle) ?
I don't know of any way to see all the statements that are sent to the
server - although I'm not certain this is because it does not exist;
it may also be because of my lacking knowledge. Though if you use IBO,
I do know it is possible to use a TIB_Monitor in your application to
see the statements IBO issues within that application.
HTH,
Set