Re: Urgent! Taking a Long Time to drop Tables

From: bunyamin karadeniz <bunyamink_at_havelsan.com.tr>
Date: Wed, 20 Sep 2000 22:11:14 +0300
Message-Id: <10715.124957@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_013A_01C0234F.B14AC5F0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: Urgent! Taking a Long Time to drop TablesDeallocating extents of a = table ?? How can I do that ? Delete from xxx??

Bunyamin K. Karadeniz
Information Technologies Dept.
Database Group Tel :90-312-2873565/1681
HAVELSAN Ankara / TURKEY

Original Message -----=20 From: Koivu, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, December 19, 2000 10:56 PM Subject: RE: Urgent! Taking a Long Time to drop Tables

Hi Larry,=20

Does your table have a lot of extents? Deallocating the extents may = cause a drop (or truncate) statement to crawl.=20

  Lisa Rutland Koivu=20
  Oracle Database Administrator=20
  Qode.com=20
  4850 North State Road 7=20
  Suite G104=20
  Fort Lauderdale, FL 33319=20

  V: 954.484.3191, x174=20
  F: 954.484.2933=20
  C: 954.658.5849=20

http://www.qode.com=20

"The information contained herein does not express the opinion or = position of Qode.com and cannot be attributed to or made binding upon = Qode.com."

-----Original Message-----=20
From: bunyamin karadeniz [mailto:bunyamink_at_havelsan.com.tr]=20 Sent: Tuesday, December 19, 2000 2:31 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Re: Urgent! Taking a Long Time to drop Tables=20

I do not know the reason .But=20
Perhaps you can truncate them .=20

  **********************************************=20

  Bunyamin K. Karadeniz=20
  Information Technologies Dept.=20
  Database Group Tel :90-312-2873565/1681=20   HAVELSAN Ankara / TURKEY=20

  **********************************************=20

Original Message -----=20 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>=20 Sent: Tuesday, December 19, 2000 10:12 PM=20

> Hi all,=20

  >=20

> Does anyone out there have any suggestions as to=20
> why it would take 12 minutes to drop tables.=20
> Where should I look first?=20

  >=20

> Thanks=20
> Larry=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Larry Taylor=20
> INET: ltaylor_at_iq.com=20

  >=20


  > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20

  > San Diego, California        -- Public Internet access / Mailing =

Lists=20


  > -------------------------------------------------------------------- =

> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from). You may=20
> also send the HELP command for other information (like subscribing). =

  --=20
  Please see the official ORACLE-L FAQ: http://www.orafaq.com=20   --=20
  Author: bunyamin karadeniz=20
    INET: bunyamink_at_havelsan.com.tr=20

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing Lists =

  --------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------=_NextPart_000_013A_01C0234F.B14AC5F0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Urgent! Taking a Long Time to drop Tables</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a6caf0>
<DIV><FONT face=3DArial size=3D2>Deallocating extents of a table =

??  How can I=20
do that ? Delete from xxx??</DIV>

<DIV>**********************************************<BR>Bunyamin K.=20

Karadeniz Information Technologies Dept. Database Group Tel=20 :90-312-2873565/1681 HAVELSAN Ankara /=20

TURKEY<BR>**********************************************</DIV>

<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:lkoivu_at_qode.com" title=3Dlkoivu_at_qode.com>Koivu, = Lisa</A> </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Tuesday, December 19, = 2000 10:56=20
 PM</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: RE: Urgent! Taking a = Long Time=20
 to drop Tables</DIV>

  <DIV><BR></DIV>
  <P><FONT size=3D2>Hi Larry, </FONT></P>
  <P><FONT size=3D2>Does your table have a lot of extents?&nbsp; =

Deallocating the=20
 extents may cause a drop (or truncate) statement to crawl. = 
 Lisa Rutland Koivu Oracle = Database=20
 Administrator Qode.com 4850=20
 North State Road 7 Suite G104 = <FONT=20
 size=3D2>Fort Lauderdale, FL  33319 V: 954.484.3191, x174 F: = 954.484.2933=20
 C: 954.658.5849 <A =

href=3D"http://www.qode.com" =
target=3D_blank>http://www.qode.com</A> "The information contained herein does not express = the opinion=20
 or position of Qode.com and cannot be attributed to or made binding = upon=20
 Qode.com." 
 -----Original Message----- From:=20
 bunyamin karadeniz [<A=20
 =
href=3D"mailto:bunyamink_at_havelsan.com.tr">mailto:bunyamink_at_havelsan.com.t= r</A>]=20
 Sent: Tuesday, December 19, 2000 2:31 PM = <FONT=20
 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>Subject: Re: Urgent! Taking a Long Time to drop Tables = 
 I do not know the reason .But Perhaps=20
 you can truncate them . <FONT=20

  size=3D2>**********************************************</FONT> =

<FONT=20
 size=3D2>Bunyamin K. Karadeniz Information = Technologies=20
 Dept. Database Group Tel = :90-312-2873565/1681=20
 HAVELSAN Ankara / TURKEY <FONT=20

  size=3D2>**********************************************</FONT> =

<FONT=20
 size=3D2>----- Original Message ----- To: = Multiple=20
 recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> = <FONT=20
 size=3D2>Sent: Tuesday, December 19, 2000 10:12 PM > Hi all, > =

</FONT><BR><FONT=20
  size=3D2>&gt; Does anyone out there have any suggestions as to =
</FONT><BR><FONT=20
  size=3D2>&gt; why it would take 12 minutes to drop tables.</FONT> =

<FONT=20
 size=3D2>> Where should I look first? >=20
 > Thanks > = Larry=20
 > -- > Please see = the official=20
 ORACLE-L FAQ: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> > --=20
 > Author: Larry Taylor <FONT=20 size=3D2>>   INET: ltaylor_at_iq.com >=20
 > Fat City Network = Services    --=20
 (858) 538-5051  FAX: (858) 538-5051 > San=20
 Diego, California        -- Public = Internet=20
 access / Mailing Lists >=20 =

--------------------------------------------------------------------</FON=

T>=20
 > To REMOVE yourself from this mailing list, = send an=20
 E-Mail message > to: ListGuru_at_fatcity.com = (note=20
 EXACT spelling of 'ListGuru') and in > = the message=20
 BODY, include a line containing: UNSUB ORACLE-L >=20
 (or the name of mailing list you want to be removed from).  You=20 may > also send the HELP command for = other=20
 information (like subscribing). -- Please see the official = ORACLE-L=20
 FAQ: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> -- =

Author: bunyamin karadeniz <FONT=20 size=3D2>  INET: bunyamink_at_havelsan.com.tr Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note EXACT = spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = Received on Wed Sep 20 2000 - 14:11:14 CDT