Page: 1 2

One of the most common problems in Oracle database is bumping-up against an Oracle database threshold. This happens commonly on many Oracle databases, even with experienced Oracle database administrators. However this problem can be prevented by planning ahead.

In this article I will discuss how to avoid Oracle outage with tablespace growth. This article will help you in preventing the embarrassing situation when growth of database results in outages.

Preventing unplanned database outage:

The test database functions well, and the database only fails when a large number of users access the database. As a result it causes an unplanned database outage. In order to ensure that this never happens, proactive Oracle professionals will always plan for growth, and set the OS and Oracle parameters.

Operating System Settings:

• Within the operating system, the Oracle professional must make sure that the shared memory on the database server is configured.



• This configuration must allow Oracle to consume the entire available RAM on the server.

Operating System Parameters:

The cautious Oracle professional will always set these parameters to a high value to avoid the embarrassing outages that can occur when the database grows.

Page: 1 2

 More Database Articles
   Database Security: Step by step guideline
   Beware of Worse Oracle performance after Migration!!
   Common Oracle Recovery mistakes
   DBA Tips for Oracle Failure to Spawn!!
   DBA Tips for Resizing Online Redo Logs!