Hello,

as far as I know there is no shared memory segment (on classic server)
like shared_pool (SGA) in Oracle.

I don't know if something like SGA is implemented on supersever to
share SQL statements execution plans...

On FB2 there is trace facility implemented o Y valve layer -- look at
FB2 documents.

Best regards Ales Zeleny

On 5/12/05, Svein Erling Tysvær <svein.erling.tysvaer@...> 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
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>