Re: not able to turn on sql_trace for an instance

Niall thank you very much.

The application has a log and we are using it at the moment the problem is that is not very clear; for example it gives two different times :
OPEN DATA 41 min
READ DATA 1h 06 min

at this point it is not clear if the Open data is the time to retrieve the first row or an internal time of the application spent in who knows what.

I think it is the time to retrieve the first row but to be sure of that I would like to trace the run.

I can capture the SQL on the flight with TOAD and then executed it in a traced session, but you can imagine that if I choose a small cube then it is not
so easy to capture it and if I take a long running one then it is a bit boring.

If I am able to generate all the traces can I aggregate them in a big one file before to
use tkprof?

Last question to understan if I got it right this time: I change my init setting sql_trace TRUE
shotdown/start the db
and then I can use the Alter System set sql_trace on... or I have to set the par in init.ora shotdown/start the db then change it again and shotdown/start the db??

Thank you very much again
Fabrizio

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f46305c$0$13641$ed9e5944_at_reading.news.pipex.net

> "Fabrizio Napolitano" <fnapolitano_at_belgacom.net> wrote in message
> news:55d0b4ea1aa465e5a982f1330e9a3d6d.119705_at_mygate.mailgate.org...
> > Thank you,
> >
> > but I think I am still missing something. First of all I realize now I
> > have not given
> > any reference to my system that maybe confusing so here we are:
> > WinNT 4
> > Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.4.1 - Production
> >
> > Then to go on I have to admit I am confused:
> > I tried to follow your advice but what I get is,again:
> > SQL> alter system set sql_trace = true scope = spfile;
>
> spfile is a 9i thing. You would need to set it in your init.ora and bounce
> the instance. It might be worth investigating wether the BI app generates
> any logs as tracking an apps work through multiple dumps would be somewhat
> difficult.

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG