Keeping an eye on the RAC and Oracle administration…….

Part 5: Oracle Monitoring

18. Keeping an eye on and managing storage

• Structures for storing databases.
• Overview of space management.
• Files Managed by Oracle (OMF)..
• Row migration and chaining.
• Proactive monitoring of the tablespace.
• Resumable Space Allocation Management.
• Tablespace SYSAUX
• Tracking the use of table and index space.
• Managing undos automatically.
• Recreate log files.
• Table Formats.
• Tables with partitions.
• Tables with Indexes (IOT).
• Utilizing SQL to manage index space
• Set the ideal redo log file size.
• Take a look at “Automatic Tuning of Undo Retention.”

19. Task Automation Using the Scheduler

• Organizer Concepts.
• Building a window and a job class.
• Managing priorities for jobs, programmes, chains, events, and schedules.
• Job log viewing and purging.
• Putting together a plan and a schedule.
• Making a position that makes use of a schedule and a programme.
• Changing the job’s programme and timetable and watching the employee’s behaviour alter.
• Tracking job execution.

20. Monitoring of tables and indices

• Tracking table fragmentation and extents.
• Use the views dba tables and dba segments.
• Keeping track of CBO statistics.
• Tracking table fragmentation and extents.
• Finding chains of rows.

21. Monitoring with STATSPACK and AWR

• Making a performance time-series report.
• Using statspackanalyzer.com
• AWR and STATSPACK scripts
• Performance data plotting (WISE, Excel).
• Identifying performance peaks and troughs.
• Oracle environment surveillance
• Oracle session management and display (v$session, v$process).
• Use AWR to track storage, network, and CPU usage.
• Keeping track of the alert log.
• Files for Oracle trace/dump.
• AWR performance management and STATSPACK.
• STATSPACK installation.
• Running reports from STATSPACK.
• Using STATSPACK to interpret a report.
• STATSPACK can be used to obtain time series reports.
• Using STATSPACK to identify performance signatures.

PART – 6. RAC Management

• Review and Overview of the Grid Infrastructure.
• An overview of architecture of RAC databases.
• Oracle RAC installation and configuration.
• Oracle RAC Management.
• Managing RAC’s backup and recovery.
• Backup and recovery for RAC.
• RAC The fusion of global resource management and caching.
• RAC Monitoring and tuning of databases.
• RAC Environment Management of High Availability of Services.
• High Connection Availability Management.
• Application Persistence.
• RAC one Node
• RAC and multitenant architecture.
• Management of service quality.

Our services can also remind you through our website.

We even have Facebook, Instagram and Linked in! Comment or like if your more of the social media type 😉

PostgreSQL Upgrades and Patches, PostgreSQL Performance Tuning PostgreSQL Maintenance: Important Information…….