Antwort: Sizing Undo tablespace
- From: "Martin Klier" <Martin.Klier@xxxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Wed, 8 Jul 2009 12:01:40 +0200
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@xxxxxxxxxx
www.klug-is.de
------------------------------------------------------------------------------
Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg
|------------>
| Von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|hrishy <hrishys@xxxxxxxxxxx>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|oracle-l@xxxxxxxxxxxxx
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|08.07.2009 08:54
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Sizing Undo tablespace
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet |
| von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|oracle-l-bounce@xxxxxxxxxxxxx
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Antwort: Sizing Undo tablespace - Martin Klier
