David,

How frequently do the redo log files switch? Check the alert log. If the
time between switches is low, make em bigger. If its very long, make em
smaller. Go for an average 30-60 mins between switches.

Check metalink Note: 1035935.6 for resizing instructions.

For temp size, it depends on the database activity. Temp is used mainly for
sorting and space for index builds/rebuilds. How full does temp get?

John.

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x69388366.[Email address protected]
Sent: 03 April 2007 11:28
To: LazyDBA Discussion
Subject: 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...


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page