Thank you for your information, Svein, David.

In Japanease Mailing List, Three solutions hit on me.

(1) Is there any function to trace SQL ? (On Firebird server)
(2) Is there any program to dump port 3050 ? (Application)
(3) Is there any dll to dump SQL statement substitute for original dll(gds32.dll, or something) ?

This mailing list says that firebird server doesn't have (1) function, and recommend to make a
programe having function (2).

In the meantime, I'll try to make dll like (3). I have made the dll like (3) on Oracle few years ago.

Many Thanx,
KIMURA, Meiji(FAMILY Given)
Tokyo, JAPAN



--- David Johnson <d_johnson@...> からのメッセージ：

> Another approach is to insert a pass through proxy to log traffic on
> port 3050, and then review the logs after a couple of weeks operation.
> This imposes a small communications penalty, but if the proxy resides on
> the same box as the server you should be able to limit the impact.
>
> There would be a lot of garbage, but you should be able to write a
> filter program to peel out only the SQL from the logs. After all, the
> information is there for Firebird to peel outthe SQL from the rest of
> the data stream.
>
> On Thu, 2005-05-12 at 09:58 +0000, Svein Erling Tysv脱r wrote:
> > --- In firebird-support@yahoogroups.com, "KIMURA, Meiji" wrote:
> > > Hi All,
> > > 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) ?
> >
> > Hi Meiji!
> >
> > 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

(snip)