verbose log of oracle queries

[Fernando Simon]

Hi François,
    The line that you report indicates that Mapserver connected in the
Oracle Server, the number is an Mapserver internal identifier for the
connection.
    Maybe to get the SQL executed by Mapserver connection you need to
change your SQL (that you executed as SYS) to retrieve the query's that
the user (my_layer) request. Another way can be enable the audits (FGA
and others) for you table, just to collect the SELECT, but remember that
for Oracle a simple select don't start a transaction.
    Best regards.

-------------------------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer
-------------------------------------------------------------------

François Bruneau wrote:
> Hi Fernando,
>
> Thank you very much for your quick reply.
>
> I now got much more information. The next line indicates that MapServer connects to the right Oracle server :
>
> msConnPoolRegister(my_layer,user/password at MYDB,XXXXXXX)\r
>
> I was just wondering what the XXXXXXX numbers stand for ? 
>
> Still, when I connect to my database as SYSDBA and when I run the following query it doesn't print the queries done by MapServer. 
>
> select a.sid, a.serial#, b.sql_text from v$session a, v$sqlarea b where a.sql_address=b.address;
>
> So I have no "proof" that the queries are indeed executed by *this* database. Any ideas on how to get that proof ?
>
> Thanks in advance,
>
> François.
>
>