Re: use external table to read alert log
Date: Thu, 9 Dec 2010 16:38:48 -0800
Message-ID: <AANLkTikGoL=VY1Q9kJzjYB5fEU5HPc3_UYpjyv3L45Lk_at_mail.gmail.com>
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_at_gmail.com> 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_at_yahoo-inc.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 09 2010 - 18:38:48 CST