Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How much time can save using _disable_logging on 10g

Re: How much time can save using _disable_logging on 10g

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 11 Oct 2005 12:38:58 -0400
Message-ID: <9177895d0510110938n4205002kcae93e02462bc3c9@mail.gmail.com>


For optimal performance, don't have the tables. If you don't have the tables, no one will modify data. And like Cary says, best kind of optimization is " not doing it " ... you can save a lot of time by not doing this test.

8:)
Raj

On 10/11/05, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> Thanks Chris, I agree with you, a simple shutdown immediate crashed
> my test database too, but anyway is interesting to know its
> limitations.
>
> Can you tell me please how much time you saved :) only for statistics.
> when migrating.
>
> Thanks in Advance.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 11 2005 - 11:41:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US