Re: use external table to read alert log
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: lzeng@xxxxxxxxxxxxx
- Date: Thu, 9 Dec 2010 14:07:38 -0600
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.
>
>
>
> Thanks,
>
> Lei
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Hemant K Chitale
> *Sent:* Wednesday, December 08, 2010 4:02 PM
> *To:* Lei Zeng
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: use external table to read alert log
>
>
>
> How large is the alert.log that you consider using parallel query ?
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
> sent from my smartphone
>
> On Dec 9, 2010 7:04 AM, "Lei Zeng" <lzeng@xxxxxxxxxxxxx> wrote:
>
> Hi:
>
>
>
> I have read few notes about using external table to read alert log.
>
>
> http://proracle.wordpress.com/how-to-read-oracle-alert-log-file-using-external-table/
>
>
>
> My question is: is it guaranteed that the line number in the file will be
> kept the same as rownum in the table?
>
> I am wondering if I use parallel option to read a file, the sequence of
> lines in the file will be kept?
>
> If no, is there other option to accomplish that?
>
>
>
> Thanks,
>
> Lei
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
