RE: Using create index nologging?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 20 Jul 2004 17:25:42 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKGEBHFBAA.mwf@rsiz.com>

Was 1735MB allocated or filled up? Presumably you're trying to figure this out on the fly so you can't just query the dictionary?

In that case the SQL must still be in the shared pool, so query it up.

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Tuesday, July 20, 2004 4:40 PM
To: oracle-l_at_freelists.org
Subject: RE: Using create index nologging?

Hi,

Why_SAP_R/3_created_an_1735_MB_index_and_it_only_generated_160_MB_of_redo_= logs?
Using_nologging?_How_do_I_verify_this_while_the_index_is_being_created?

SAP_4.6C
Oracle_9.2.0.4
Solaris_9

TIA, Roger_Xu
Database_Administrator
Dr_Pepper_Bottling_Company_of_Texas
(972)721-8337

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20 =

to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20

=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Jul 20 2004 - 16:22:30 CDT