I think I had some issues with this also when we went
from 805 to 816 on Solaris 2.6. Remeber removing all
AQ params from my init.ora (job_queue* params).
- "Mohan, Ross" <MohanR_at_STARS-SMI.com> wrote:
> Ok, settle down. I just migrated from 80520 to 81600
> on Siemens and
> the migrate consistently choked on the AQ$ update
> stuff. Something
> to do with objects...raw data types....
>
> Oracle provided a patch which did not work. We
> finally had to migrate
> holding the database at compatible=8.0.5.2.0,
> but....we think the
> AQ$ stuff may be held back at that level....not
> sure, and oracle
> sure as hell ain't telling.
>
> anyway, heads up.
>
> -----Original Message-----
> Sent: Wednesday, August 15, 2001 10:01 AM
> To: Multiple recipients of list ORACLE-L
>
>
> truncate doesn't change the hwm unless you drop
> storage
>
> also, depending on the number of extents (not the
> number of rows), it can
> take a long time to free up storage if you do
> truncate table ... drop
> storage.
>
> Oracle has to update the UET$ and FET$ tables for
> each extent you release.
>
>
> >From: Hallas John <John.Hallas_at_btcellnet.net>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> >Subject: RE: Speed up Truncate tables
> >Date: Wed, 15 Aug 2001 01:25:59 -0800
> >
> >Chuan,
> >
> >Are you sure you were using the TRUNCATE TABLE
> command rather than DELETE
> >It sounds as if you are running a delete,
> especially if the HWM was not
> >shrunk
> >
> >John
> >-----Original Message-----
> >Sent: 15 August 01 09:10
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi All,
> >
> > Is there any way to speed up the truncating a
> big table with 12
> >million
> >rows?
> >
> >Basically, I implemented truncating that big table
> on Production, but it
> >affected the performance much, so I had to stop it
> in the middle of way.
> >All
> >the rows were truncated but the HWM was not shrunk
> at all. I want to do it
> >again to get the space back. Is there any way to
> speed up this process?
> >
> >Platform: Oracle EE8.0.6 and Solaris 2.7
> >
> >Thanks a lot in advance.
> >
> >Chuan
> >
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Chuan Zhang
> > INET: chuan_at_asiaonline.net
> >
> >Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> >San Diego, California -- Public Internet
> access / Mailing Lists
>
>--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from). You may
> >also send the HELP command for other information
> (like subscribing).
> >
> >
> >
>
>**********************************************************************
> >This email and any attachments may be confidential
> and the subject of
> >legal professional privilege. Any disclosure, use,
> storage or copying
> >of this email without the consent of the sender is
> strictly prohibited.
> >Please notify the sender immediately if you are not
> the intended
> >recipient and then delete the email from your inbox
> and do not
> >disclose the contents to another person, use, copy
> or store the
> >information in any medium.
>
>**********************************************************************
>
>
>
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: MohanR_at_STARS-SMI.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: mkb125_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 15 2001 - 11:48:43 CDT
