 |
Oficinas en México |
|
|||||||||
   |
||||||||
Database MonitoringIT Consulting ServicesThe DBA is responsible for monitoring the database server on a regular basis to identify bottlenecks. A DBA needs to understand which monitoring tools are available at each of these levels and how to use them to tune the system. Proactive prevention Maintenance is an attitude of designing performance into an application from the start rather than waiting for problems to occur and fixing them. It requires working closely with developers of applications that run against the database to make sure that best practices are followed so good performance will result. It is the DBA’s responsibility to write shell scripts and schedule them to monitor the following the database processes:• Database availability • Database Storage - Disk - Tables - Tablespaces - Extents • Account and schemas close to expiration • RMAN Backups for both Windows and AIX • Oracle DataGuard status • Database Performance • Invalid Oracle Objects • Biometrics Ready to Archive Records • Auditing - Users Logs - Users Privileges modifications - Data Modified • Nightly Processes Status |
||||||||
