Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Wed, 2 Nov 2011 16:25:35 +0000
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@xxxxxxxxx> 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@xxxxxxxxx>
>> 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?
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Niall Litchfield
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Chitale, Hemant Krishnarao
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- jonathan
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan..... - Niall Litchfield