on 11-18-2009 7:03 AM
HI GURUJI
MY DATABASE SIZE IS 250GB IT IS PRODUCTION DATABASE AND MY UNDODATABASE IS 10GB IT IS OK SIZE OF UNDOTABALE SPACE FOR MY DATABASE,ON ORALCE10G AND MY ALL UNDO TABLES, MAX_EXTENTS is 32765
AND
MY UNDOTABLESPACE MANAGMET IS MENUAL AND THERE Max. extents 2,147,483,645
AND
MY SAP SYSTEM GIVE ERROR NUMER OF EXTENT THRESHOLD
IT IS OK OR NOT
PLEASE SAY ME AS SOON AS POSSIBLE
NAINESH SUTHAR
PLEASE D'ONT SHOUT!
There is no relation between database size and undo size needed. The amount of changes (updates/inserts/deletes) per time dictates the size of your undo tablespace.
Please have a look at these notes:
[600141 - Oracle9i: Automatic UNDO Management|https://service.sap.com/sap/support/notes/600141]
[1035137 - Oracle Database 10g: Automatic Undo Retention|https://service.sap.com/sap/support/notes/1035137]
If this does not enlighten your situation, then please give us the exact error you have.
Cheers Michael
Edit: and hey, switch to undo_management = AUTO!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.