How to Resize Redo log groups
791045Jan 20 2011 — edited Jan 21 2011Windows Server 2008 64 bits - Oracle 11g (11.02.0)
We have our first oracle database in implementation.
The go live is supposed to happen in March or April.
Our Oracle courses will start next week but because of performance I need to change the size of our redo log groups.
The users are just loading 2010 year data into the database, but the performance is terrible.
I'd like to know if it's possible to do that by using the Enterprise Manager.
I was able to change the tablespaces and their files, but I don't succeed with redo log groups.
I have 3 groups with 50 MB each one. I'd like to change them to 500 Mb each one.
When I try to edit the groups, it doesn't open the possibility of changing it.
Do I have to stop the database ? do I have to clean the group ? how can I change the size of them ?
Eduardo