From oracle-l-bounce@freelists.org Tue Jul 20 16:42:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6KLg7C29328 for ; Tue, 20 Jul 2004 16:42:17 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6KLfv629294 for ; Tue, 20 Jul 2004 16:42:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC2A972D110; Tue, 20 Jul 2004 16:21:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20907-40; Tue, 20 Jul 2004 16:21:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22F4D72C419; Tue, 20 Jul 2004 16:21:21 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Jul 2004 16:19:52 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AEE172C54F for ; Tue, 20 Jul 2004 16:19:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19681-72 for ; Tue, 20 Jul 2004 16:19:51 -0500 (EST) Received: from mail65.messagelabs.com (mail65.messagelabs.com [216.82.244.83]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id AD95D72C57B for ; Tue, 20 Jul 2004 16:19:51 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-6.tower-65.messagelabs.com!1090359943!7039912 X-StarScan-Version: 5.2.10; banners=dp7uptx.com,-,- X-Originating-IP: [216.136.17.254] Received: (qmail 22531 invoked from network); 20 Jul 2004 21:45:44 -0000 Received: from unknown (HELO mail.dp7uptx.com) (216.136.17.254) by server-6.tower-65.messagelabs.com with SMTP; 20 Jul 2004 21:45:44 -0000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Using create index nologging? X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Date: Tue, 20 Jul 2004 16:43:45 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Using create index nologging? Thread-Index: AcRuoC0wIFlaFYK7S/asVAMbxYZ8JgAAb+7Q From: "Roger Xu" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5560 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: roger_xu@dp7uptx.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org select_*_from_v$sqlare_where_sql_text_like_'%%' returns_nothing_Can_somebody_explain_why? -----Original=20Message----- From:=20Mark=20W.=20Farnham=20[mailto:mwf@rsiz.com] Sent:=20Tuesday,=20July=2020,=202004=204:26=20PM To:=20oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On=20Behalf=20Of=20Roger=20Xu Sent:=20Tuesday,=20July=2020,=202004=204:40=20PM To:=20oracle-l@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@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@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@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@dp7uptx.com= . ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------