Best Practices to do after joining new Company.
Best Practices to do after joining new company or taking new customer support responsibilities.
We need to consider and do the below mentioned activities When you join in a new team/company or new set of DBs added in to your support. There are so many activities but below are the important activities.
1)Verify all Database connectivity, OEM/ Monitoring tool connectivity and get the version details.
2) Verify all backups and reports.
3) Allocated SGA and PGA memory analysis
Sometimes we suffer with the alerts like
a)Not able to access the database on xyz host
b)Not able to connect to user
c)Swap Utilization is 95.374%, crossed warning (80) or critical (95) threshold.
d) Message=Failed to connect to database instance: Failed to connect: java.sql.SQLException:
Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections .
Action Item:
Need to verify all SGA and PGA , total memry in the server .
Calculate sum of all allocated memery for each database and subtract the size from total allocated on server.
Note : There should be 20% memory reserved for OS operations.
4) Unnecessary databases or test databases running since many days.
Action Item:
Need to discuss with Apps team and shutdown the unnecessary/test databases
5) Analyze all cron jobs
6) Analyze all long pending issues from KT sessions.
See Also: