Antwort: Re: Problem with LMT and ASSM
- From: Markus Kuehn <Markus.Kuehn@xxxxxxxxx>
- To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- Date: Wed, 28 Jun 2006 12:02:56 +0200
I tried dbms_repair.segment_fix_status... Now partially freed extents get
reused. But the smaller ones aren't reused yet. This is a bug as Metalink
note 3329096.8 states. A patch for various operating systems is available
but sadly not for AIX. If you're on some other OS search Metalink for this
note. The note also states, that a fix for this bug is incorporated into
9.2.0.6. I assume that either ORACLE forgot to put the fix into the AIX
code or incorporated the fix into 9.2.0.7.
Regards Markus
Markus Kühn
LBS Landesbausparkasse Baden-Württemberg
Abteilung OI
Gruppe Datenbanken und Konfigurationsmanagement
Jägerstraße 36, 70174 Stuttgart
Postfach 10 60 28, 70049 Stuttgart
Siegfried-Kühn-Str. 4, 76135 Karlsruhe
Postfach 14 60, 76003 Karlsruhe
Telefon 07 11 / 1 83 - 2915
Fax 07 11 / 1 83 - 492915
E-Mail Markus.Kuehn@xxxxxxxxx
Amtsgericht Stuttgart HRA 12924
Amtsgericht Karlsruhe HRA 4548
"Alex Gorbachev"
<gorbyx@xxxxxxxxx
> An
Markus.Kuehn@xxxxxxxxx
27.06.2006 22:19 Kopie
oracle-l@xxxxxxxxxxxxx
Thema
Re: Problem with LMT and ASSM
As a hint you might dump the blocks out of those freed extents in the
beginning of the segment and see what's really there.
I hope you will solve this as one of those 150.000 records inserted
daily there might be one "mine". ;-) So I hope you won't run out of
space on "my" row.
2006/6/27, Markus Kuehn <Markus.Kuehn@xxxxxxxxx>:
> Anyone out there has a solution or work-around for this type of
situation.
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
Die LBS Baden-Württemberg verwendet aktuelle Virenschutzprogramme. Wir
haften nicht für Schäden, die dem Empfänger durch diese E-Mail entstehen
könnten. Bitte haben Sie Verständnis, dass wir die rechtliche
Verbindlichkeit für den Inhalt dieser E-Mail ausschließen. Sind Sie nicht
der beabsichtigte Empfänger dieser E-Mail, teilen Sie uns dies bitte mit
und löschen die E-Mail. Vielen Dank.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Antwort: Re: Problem with LMT and ASSM
