Re: Parallel query & supplemental logging

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 01 Nov 2004 23:40:29 +0100
Message-ID: <roedo0d1unkmidh5i8g5l3ajad93bd0hm0@4ax.com>

On Mon, 1 Nov 2004 21:05:52 -0000, "J Williams" <johnwilliams_esq_at_NOThotmail.com> wrote:

>Hi,
>
>Newbie to Oracle, running 9i Rel. 2 on Windows XP. Using OEM (or otherwise)
>how do I determine:
>
>1. Whether the parallel query option is enabled or installed?
>2. Whether supplemental logging (and the type of supplemental logging) is
>enabled on the database instance?
>
>Thanks.
>

select * from v$option

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Nov 01 2004 - 16:40:29 CST