Re: use external table to read alert log

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: lzeng@xxxxxxxxxxxxx
  • Date: Thu, 9 Dec 2010 16:38:48 -0800

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.

Perhaps a description of what you are trying to accomplish will aid in
people offering advice.

On Thu, Dec 9, 2010 at 12:07 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:
> Well, I would recommend that you write out a large file and then read it
> back in and see what happens.  If you would post the results to the list, I
> would be interested in them myself.  I suspect that you wont be able to get
> a parallel query to work on an external table, but that is only a suspicion,
> I have no proof one way or another.
>
> On Wed, Dec 8, 2010 at 8:11 PM, Lei Zeng <lzeng@xxxxxxxxxxxxx> wrote:
>>
>> Alert log is just one use case. I am considering the use case of other
>> large files which need to keep the line order in the way like alert log.


-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


Other related posts: