logging the SQL scripts

From: <rc_at_die@you@!spammers.sandworm.demon.co.uk>
Date: Mon, 09 Aug 2004 22:22:12 +0100
Message-ID: <deqfh09ogrkrsqjb2kaluiqrbht7cieado@4ax.com>

We have Oracle 8.1.7.4 on Solaris 8

What would like to know is there a way in oracle I can see waht sql is being sent to the server by a application.

We have an application that we run on our Oracle db, there are certain functions it does very bad. The tech support from the company is not very good or help full.
And I think the software is badly written, before any one asks no, I cannot ditch the software as it has been use for years @ my company.

Am I looking for something called statspack ?

Thanks Received on Mon Aug 09 2004 - 16:22:12 CDT