RE: Using create index nologging?

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Tue, 20 Jul 2004 16:43:45 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F715AA78@irv2kexch01>

select_*_from_v$sqlare_where_sql_text_like_'%<index_name>%' returns_nothing_Can_somebody_explain_why?

-----Original=20Message-----
From:=20Mark=20W.=20Farnham=20[mailto:mwf_at_rsiz.com] Sent:=20Tuesday,=20July=2020,=202004=204:26=20PM To:=20oracle-l_at_freelists.org
Subject:=20RE:=20Using=20create=20index=20nologging?

Was=201735MB=20allocated=20or=20filled=20up?=20Presumably=20you're=20tryin= g=20to=20figure=20this
out=20on=20the=20fly=20so=20you=20can't=20just=20query=20the=20dictionary?=

In=20that=20case=20the=20SQL=20must=20still=20be=20in=20the=20shared=20poo= l,=20so=20query=20it=20up.

mwf

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

Hi,

Why_SAP_R/3_created_an_1735_MB_index_and_it_only_generated_160_MB_of_redo_=
=3D

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=3D20e-mail=3D20is=3D20intended=3D20solely=3D20for=3D20the=3D20person=3D= 20or=3D20entity=3D20
=3D

to=3D20which=3D20it=3D20is=3D20addressed=3D20and=3D20may=3D20contain=3D20c= onfidential=3D20an=3D
d/or=3D20privileged=3D20information.=3D20Any=3D20review,=3D20dissemination= ,=3D20copyin=3D
g,=3D20printing=3D20or=3D20other=3D20use=3D20of=3D20this=3D20e-mail=3D20by=
=3D20persons=3D20or=3D20
=3D

entities=3D20other=3D20than=3D20the=3D20addressee=3D20is=3D20prohibited.=3D=

20If=3D20you=3D20=3D
have=3D20received=3D20this=3D20e-mail=3D20in=3D20error,=3D20please=3D20con=
tact=3D20the=3D20s=3D

ender=3D20immediately=3D20and=3D20delete=3D20the=3D20material.=3D20

This=3D20email=3D20has=3D20been=3D20scanned=3D20for=3D20all=3D20viruses=3D= 20by=3D20the=3D20Mes=3D
sageLabs=3D20Email=3D20Security=3D20System.=3D20Any=3D20questions=3D20plea= se=3D20call=3D20=3D
972-721-8257=3D20or=3D20email=3D20your=3D20request=3D20to=3D20tech_support= @dp7uptx.com=3D
.

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

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

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


----------------------------------------------------------------
Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com
----------------------------------------------------------------
To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org
put=20'unsubscribe'=20in=20the=20subject=20line.
--
Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=


=20you=20can

call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.

************************************************************************
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
-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 16:42:32 CDT