truncate table generate lot of redologs
dbaforuAug 24 2010 — edited Aug 24 2010hiii,
i am working on oracle database 10g as a core dba. I do have a problem.In production environment lot of users truncating a table size 5gb,and puring new data,updating data and again truncating with resuse storage clause. so lot of redo logs are generating..and my database performance is degrading..
can any one tell me why truncate statement generates lot of redos..and what is the impact of this with the performance of database.