need suggestions on redolog and temp file.

need suggestions on redolog and temp file.

 

  

hello experts,

i need some suggestions from you..
1) How to calculate the appropriated redolog file size..? if need what is
the procedure to change the redolog size.?
2) How to calculate the appropriated temp file size ..? because our
biggest table owns 500 millons of rows and has more than 20Go and temp
file has now 18Go..is that enough..?

thanks a lots.
david...

Oracle LazyDBA home page