Sizing Undo tablespace
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 8 Jul 2009 06:50:36 +0000 (GMT)
Message-ID: <725382.64675.qm_at_web23703.mail.ird.yahoo.com>
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
Date: Wed, 8 Jul 2009 06:50:36 +0000 (GMT)
Message-ID: <725382.64675.qm_at_web23703.mail.ird.yahoo.com>
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-lReceived on Wed Jul 08 2009 - 01:50:36 CDT