Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 2 Nov 2011 16:25:35 +0000
Message-ID: <CABe10san_FCymA0OCPY04OJbBsoUcADcQ7vm6jDN2xQm_-_SvA_at_mail.gmail.com>

Active SQL Monitoring would be the smart GUI - official page at http://www.oracle.com/technetwork/database/focus-areas/manageability/sqlmonitor-084401.html though Greg's excellent pages rank higher in Google!

On Wed, Nov 2, 2011 at 4:02 PM, Radoulov, Dimitre <cichomitiko_at_gmail.com> wrote:
>
> Thanks, I know that ...
> It's just that I usually refer to it as  v$sql_monitor,
> thus my question.
>
> I was hopping that there was some new GUI which simulated it for free :)
>
>
> Best regards
> Dimitre
>
> On 02/11/2011 16:56, Greg Rahn wrote:
>> Try a Google search for:  oracle sql monitor
>> Or see the Oracle docs:
>> http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/instance_tune.htm#PFGRF94543
>>
>> It does require a license -- SQL monitoring is a feature of the Oracle
>> Database Tuning Pack.
>>
>> On Wed, Nov 2, 2011 at 8:47 AM, Radoulov, Dimitre<cichomitiko_at_gmail.com>  wrote:
>>> Greg,
>>> this is quite useful bit of information.
>>>
>>> So now we know that Mark's insert was performed in serial :)
>>>
>>> P.S. What's SQL Monitor and does it require a separate license?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 02 2011 - 11:25:35 CDT