Re: logging the SQL scripts

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 9 Aug 2004 18:39:10 -0700
Message-ID: <43441e77.0408091739.7bf66974@posting.google.com>

rc_at_die@you@!spammers.sandworm.demon.co.uk wrote in message news:<deqfh09ogrkrsqjb2kaluiqrbht7cieado_at_4ax.com>...
> Hi
>
> 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

Look in sql tracing and tkprof:

alter session set sql_trace true

execute DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,seraial#,TRUE);

These commands will get you all the sql statements of a database session Received on Mon Aug 09 2004 - 20:39:10 CDT