Lber wrote:
> Hi,
> I'm in the process of setting up an Oracle server.
> what sort of maintenance does Oracle need to keep it running at it's optimum
> levels?
>
> FYI it's an 8i server
>
> TIA
For Oracle 8i:
* Keep the table and index statistics up to date, daily, once a week,
or however often is required. Do not gather stats for the SYS schema.
Use SQLPlus to execute a command similar to this:
begin
dbms_stats.gather_schema_stats(ownname=> 'schema_to_be_analyzed_here',
CASCADE=> true);
end;
/
- Set the server up right from the start for performance. Find the
Oracle tuning book by Gaja Krishna Vaidyanatha. You can find some of
his articles on the Internet with titles similar to Tuning without
Cache Hit Ratios.
- Do NOT add to the maintenance schedule rebuilding of indexes, or
export and then import routines in the hope that this will improve
performance.
- Change the default passwords from the start. This will help prevent
problems with Oracle Enterprise Manager, such as
"OracleOra81ManagementServer will Not Start - VTC-1345 Oracle
Management Server is Unavailable in Enterprise Manager"
- Pick up a copy of Cary Millsap's "Optimizing Oracle Performance" book
to help investigate bottleneck areas with specific applications.
- Make certain that your backups are completing, consider using both
RMAN and EXP to create both a physical and logical backup.
- Keep an eye on the performance of online redo logs and the space
occupied by archived redo logs - you do not want to cause Oracle to
crash due to insufficient disk space.
- Watch the memory utilization. If on 32 bit Windows, stay away from
the 2GB per process maximum.
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Wed Nov 08 2006 - 07:13:06 CST