Re: Oracle 11 beginner questions
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 01 Oct 2008 18:45:46 +0200
Message-ID: <48e3a923$0$2861$ba620e4c_at_news.skynet.be>
Date: Wed, 01 Oct 2008 18:45:46 +0200
Message-ID: <48e3a923$0$2861$ba620e4c_at_news.skynet.be>
Gaute schreef:
> Thank you
>
> Sqlplus "set autotrace on explain" solves my second question (B). I also
> found it in "Oracle SQL Developer".
>
> But is there a quick way to see all SQL queries sent to oracle from my
> application with time per query?
> I have been looking around in OEM without luck...
>
> Best regards from Gaute
>
>
Activate trace and analyze the trace-file on the database-server with tkprof Received on Wed Oct 01 2008 - 18:45:46 CEST