Antwort: Sizing Undo tablespace
From: Martin Klier <Martin.Klier_at_klug-is.de>
Date: Wed, 8 Jul 2009 12:01:40 +0200
Message-ID: <OFAC7A6769.34CCBC98-ONC12575ED.003702A3-C12575ED.00371598_at_klug-is.de>
Just another idea: Create an UNDO tablespace with autoextend. At least it's a nice method to find out where it grows to.
Date: Wed, 8 Jul 2009 12:01:40 +0200
Message-ID: <OFAC7A6769.34CCBC98-ONC12575ED.003702A3-C12575ED.00371598_at_klug-is.de>
Just another idea: Create an UNDO tablespace with autoextend. At least it's a nice method to find out where it grows to.
-- Mit freundlichem Gruß Martin Klier Senior Oracle Database Administrator ------------------------------------------------------------------------------ Klug GmbH integrierte Systeme Lindenweg 13, D-92552 Teunz Tel.: +49 9671/9216-245 Fax.: +49 9671/9216-112 mailto: martin.klier_at_klug-is.de www.klug-is.de ------------------------------------------------------------------------------ Geschäftsführer: Johann Klug, Roman Sorgenfrei Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608, HRB Nr. 2037, Amtsgericht AmbergReceived on Wed Jul 08 2009 - 05:01:40 CDT
|------------>
| Von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |hrishy <hrishys_at_yahoo.co.uk> | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |oracle-l_at_freelists.org | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |08.07.2009 08:54 | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |Sizing Undo tablespace | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet | | von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |oracle-l-bounce_at_freelists.org | >--------------------------------------------------------------------------------------------------------------------------------------------------| Hi I am trying to size my undo tablepsace by looking at the undo rates.i.e the column UNDOBLKS in v$undostat. Value for undoblks for particular sql is 13841 and my database size is 8kb.Does this mean that i need to have a undo tablespace size of select 8192*13841/1024/1024 from dual 108Gb ? Not the particular sql does a corelated update ofmere 72762 rows and the figure of 108Gb doesnt make much sense .This is a JDBC app and i dont have much idea if this sql is in some for loop or something. regards Hrishy regards Hrishy -- http://www.freelists.org/webpage/oracle-l