![Oracle Database 12c: Performance Management Tuning 1z0-064](https://scholarsark.com/wp-content/uploads/2021/06/11064-oracle-database-12c-performance-management-tuning-1z0-064-806x440.jpg)
Oracle Database 12c: Performance Management Tuning 1z0-064
![immagine dell'articolo](https://img-c.udemycdn.com/course/480x270/3923330_c01e_2.jpg?Expires=1624797457&Signature=ZQQSLcjd-0m23ZbG9YYCeb8mwykBPqwHNBEadToBBkiQ-orujZUXgcMBO1NPeRcLjqRRjnowUkyC7XdHyIQDoD3H9YAzXuPb3MgthwHXik2dWUl4Iji6PJ24zl7WHnKpnzZtWSWjS9CvRebnuDah~iK8b6s~vyLC~pQ5txsV-3vLXpTZu5pkXZqPthOlT7lm29VpdwTpJmUwQqsj6OoTQRYOgCqUtXkDtOGMIyYyREiJTgM6D26xZzw9mIx9SGEBkB8zM6WuPKmFB9lHKjL93W0VwUplkOHw6UFv8tKRu~xw9X-4akoPS5lEl2XpQpk09BOpOpqWiN3kA6HjEoyxng__&Key-Pair-Id=APKAITJV77WS5ZT7262A)
Prezzo: $24.99
Basic Tuning Diagnostics
-
Describe the time model
-
Explain wait events
-
Diagnose performance problems using V$ views
Using Automatic Workload Repository
-
Analyze database performance using AWR reports
Using Metrics and Alerts
-
Monitor performance using metric thresholds and alerts
Using Baselines
-
Use AWR baselines to monitor performance
Using AWR-Based Tools
-
Diagnose performance issues using ADDM
-
Diagnose performance issues using ASH reports
Monitoring Real-Time Database Operation
-
Implement Real-Time Database Operation Monitoring
Monitoring Applications
-
Configure and use services to monitor database performance
Identifying Problem SQL Statements
-
Interpret execution plans
-
Use formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements
Influencing the Optimizer
-
Explain how statistics influence the optimizer
-
Configure parameters to influence the optimizer
Reducing the Cost of SQL Operations
-
Use Automatic Segment Space Management to optimize space management
-
Use table compression
-
Diagnose and tune space related issues
Using SQL Performance Analyzer
-
Use SQL Performance Analyzer to test the impact of database changes
SQL Performance Management
-
Manage optimizer statistics
-
Use SQL Profiles and Advisors to tune SQL statements
-
Use SQL Plan Management to tune SQL statements
Using Database Replay
-
Use Database Replay to check impact of system change on performance
Tuning the Shared Pool
-
Diagnose and resolve hard and soft parsing problems
-
Diagnose and resolve performance issues related to the shared pool
Tuning the Buffer Cache
-
Diagnose and resolve performance issues related to the buffer cache
Tuning PGA and Temporary Space
-
Diagnose and resolve performance issues related to PGA
-
Diagnose and resolve performance issues related to temporary tablespace
Using Automatic Memory
-
Use and tune Automatic Shared Memory Management
-
Use and tune Automatic Memory Management
Tuning I/O
-
Diagnose database I/O issues
-
Configure Automatic Storage Management (ASM) for maximum availability
Using the Database Resource Manager
-
Understand and configure the Database Resource Manager
Lascia un commento
Devi accesso o Registrati per aggiungere un nuovo commento .