| redologfile & undo Tablesapce [message #59287] |
Mon, 10 November 2003 00:43  |
Jasmine
Messages: 23
Registered: December 2000
|
Junior Member |
|
|
hi i have to create a db around 10GB,20GB for testing and production and purpose of software development.Currently accessing 30 users for DML activities not for OLTP.HOw much space i have to use to create for redologfiles and undo tablespace.its not running any batch jobs
thanks in advance
jasmine
|
|
|
|
| Re: redologfile & undo Tablesapce [message #59290 is a reply to message #59287] |
Mon, 10 November 2003 04:53  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Redolog : size it so that you get a redolog switch approximately every 20-30mts. If you make it too small,you will encounter frequent log switches(hence checkpoints) and possibly 'checkpoint not complete' errors. If you size it too big,you run the risk of loosing that much of transaction data when you loose the file.You can always tune the size(ie add&drop members)..
Undo Tspace: it depends on your retention needs,size of your biggest job ..
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
