Re: SQL Sniffer

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 01 Oct 2005 13:49:06 +0200
Message-ID: <pqtsj15mf3spu1ka4iem5g39rbvs28cb8s@4ax.com>

On 1 Oct 2005 02:58:19 -0700, "Wolfgang Zeiger" <wolfgang.zeiger_at_t-online.de> wrote:

>Hello group,
>
>i was looking for a tool like a SQL Sniffer or Monitor to view the
>SQL-statements a Oracle-forms-applikation send to the database. I must
>rebuild the functionality of this app because the support for this
>software is not aviable a long time and we must do some changes.
>Has anyone an idea how I could monitor the SQL-Statements, the client
>sends to the database?
>
>Greetings
> Wolfgang

No 'tools' necessary.

alter system set sql_trace = true
/
alter system set max_dump_file_size=unlimited /

should do the trick.
You would of course best start with reverse engineering the schema.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Oct 01 2005 - 06:49:06 CDT