Database Monitoring (Standard Plan)
|
Database Administration (Standard Plan)
|
Database Availability
o Database availability
o Listener availability
o Alert log errors
o Data Guard log apply process
Database Space Monitoring
o Tablespace free space
o Temporary tablespace usage
o Autoextend usage
o Datafile I/0
o Extent management
o O/S disk free space
o Flash recovery area free space
Instance Monitoring
o SGA and shared pool utilization
o Sorting efficiency
o Buffer cache hit ratios
o Shared pool hit ratios
o Object fragmentation
o Lock & latch issues
o Blocking locks
Server Utilization
o O/S CPU utilization
o O/S memory utilization
o O/S swap utilization
Backup and Recovery
o RMAN backup successful
o Redolog switches
o Archive log disk space
|
Security
o Manage DB user, roles and profiles
o Object level privileges
o Security audit
o Encryption
o Oracle Data Redaction
o Flashback Data Archive
o Custom PL/SQL triggers
General DB Administration
o Instance parameter configuration
o Database jobs
o Listener configuration
o Identify invalid objects
o Patch assistance
o Oracle SAR management
o Database creation
o Flash back database configuration
o Oracle Database Shell Scripting
Database Storage Management
o Review database structures/layouts
o Manage Oracle data files
o Manage tables/ indexes/storage options
o Manage rollback segments issues
o Manage Redo logs
o Undo tablespace sizing
o Flash recovery area configuration
Backup Management
o Define and design backup and recovery procedures
o Recovery assistance
o Disaster recovery
o Archive log configuration
Instance Tuning
o Index monitoring
o Investigate inefficient SQL
o CBO stats management
o Undo/Rollback segments activity
|
For more information about our DBA Services, Call: (410)-775-6716
