Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Archive mode
select log_mode from v$database;
v$instance also gives you some interesting informations particularly in v8.
--
Have a nice day
Michel
<kaprino_at_my-deja.com> a écrit dans le message : 823k70$jqd$1_at_nnrp1.deja.com...
> Hi,
>
> How can I find out if the I'm In ARCHIVELOG mode or NOARCHIVELOG
> mode while database is active. What table will contain imortant
> information about the current instance of the database.
> Thanks,
>
> kaprino
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 01 1999 - 11:24:16 CST
![]() |
![]() |