| AUM IN ORACLE [message #140825] |
Wed, 05 October 2005 15:37  |
israel05
Messages: 9
Registered: August 2005
|
Junior Member |
|
|
How can u tell the size of a record OR records that you may update, insert or delete?
We have some sessions using large amounts of undo and we are not sure how large the records.
|
|
|
|
| Re: AUM IN ORACLE [message #141453 is a reply to message #140825] |
Mon, 10 October 2005 06:16  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
When user commits or rollbacks the transaction undosegment free it memory which was holded by old image of record.
In automatic undomanagement oracle decide by it self doing load balancing that which undosegment is used.
Size of record is equal to total size of all coloum which forms the record.
Regards
Always Friend Sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
