#oraclearchitecture

Details should be taken before stopping ORACLE DB for planned activity:

In UNIX and Linux, any planned downtime activity at OS/database level needs the oracle database to shutdown prior to the activity. If its a planned activity, taking below details helps to verify the database after activity completed. Also, it helps to validate and find the reason if any critical error occured after downtime activity. Collect the details and save it in notepad which can be removed…

Real time Capacity planning for ORACLE database- step by step:

Capacity planning for ORACLE database comes into play when ORACLE file system reaches above threshold level. The UNIX team will receive file system utilization alert and since its ORACLE database disk, they will ask us to clear some space to bring it under threshold.

Before asking for space, we need to check last one year database growth, tablespace utilization in database and how much space…