Re: use external table to read alert log
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: landstander668@xxxxxxxxx
- Date: Fri, 10 Dec 2010 08:16:18 -0800
On Fri, Dec 10, 2010 at 6:54 AM, Adric Norris <landstander668@xxxxxxxxx> wrote:
> On Thu, Dec 9, 2010 at 6:38 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:
>>
>> Parallel query works on external tables, however if one desires to
>> read the file in line order, there is no reason or benefit to use
>> parallel query that I can think of.
>
> Doesn't parallelism of external tables require fixed-length rows? I thought
> that Oracle had to be able to determine the start/end boundaries for the
> parallel processes up-front, without the need to parse variable-length data
> first...
No, it does not require fixed length rows -- it works with delimited
rows also. When the file is a stream format, like output from using
the external table preprocessor, it can not be broken into granules
and then parallelism is limited to the number of streams.
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
