This chapter discusses the features and functions included in oracle database that make it easy to monitor database health, identify performance problems, and implement any corrective actions. Advisors are powerful tools for database management They provide specific advice on how to address key database management challenges, covering a wide range of areas including space, performance, and undo management. The easiest and best way to monitor the database for errors and alerts is with the database home page in oracle enterprise manager cloud control (cloud control). Oracle enterprise manager provides the management and monitoring capabilities with many different notification options This chapter provides recommendations for using enterprise manager to monitor and maintain a highly available environment across all tiers of the application stack.
Use the oracle cloud infrastructure monitoring service to actively and passively monitor cloud resources using the metrics and alarms features The real time sql monitoring page shows in real time the sql statements that are being monitored in the database. By drilling down to other pages from the performance page, you can identify database performance problems in real time If you find a problem, then you can run addm manually to analyze it immediately without having to wait until the next addm analysis. To view information about oracle database threads using oracle administration assistant for windows, you must either enable windows native authentication for the database or run the utility ocfgutil.exe with arguments username and password.
OPEN
