Skip to content

My Tech Blog

My Tech Blog

  • Home

Category: Enterprise Manager

Database Growth – OEM

December 17, 2019markLeave a comment

There are many ways to calculate database growth and I’ve certainly had a few, but this is probably the most accurate so far..

Continue Reading

Backup Report from Enterprise Manager

August 17, 2017markLeave a comment

How do we report on databases that haven’t been backed up? We create a report from Enterprise manager and see what has failed and what backups are potentially missing Run this in Enterprise Manager

Continue Reading

Database Capacity Planning

August 16, 2017September 26, 2019markLeave a comment

Capacity and Growth Forecast How to estimate the growth and forecast of a database on a host. Step-by-step guide The procedure is at the bottom of this article. Login to enterprise manager from sqlplus (from omsdbaup03) oracle@omsdbaup03:/users/oracle 2. Follow the following to calculate growth for each database on a host The following…

Continue Reading

Get the Properties From All Targets – Enterprise Manager

August 14, 2017markLeave a comment

Continue Reading

CPU usage from Host via Enterprise Manager

August 14, 2017markLeave a comment

Continue Reading

Current Incidents for the Week

August 14, 2017markLeave a comment

Continue Reading

How can I view the number of targets blacked out in the last 30 days?

August 14, 2017markLeave a comment

The MGMT$BLACKOUT_HISTORY file contains an overview of all finished blackouts for each target. To view the number of targets blacked out in the last 30 days, enter the following query:

Continue Reading

How can I view a list of future scheduled blackouts?

August 14, 2017markLeave a comment

The MGMT$BLACKOUTS file contains definitions of all blackouts known in the system. To view a list of future scheduled blackouts, enter the following query:

Continue Reading

How do I return all targets under a blackout?

August 14, 2017markLeave a comment

To return all targets under blackout, enter the following query:

Continue Reading

Calculate Database Sizes

August 14, 2017August 14, 2017markLeave a comment

Continue Reading

Posts navigation

Page 1 Page 2 Page 3 Next

Recent Posts

  • Python to read Oracle alert.log
  • How to check MSSQL Backups
  • RMAN Backup with Python
  • Calculate RTO from Availability Group SQLServer
  • Backup Sizes

Recent Comments

  • Kesavamoorthy on How to stop and start RDS instance in AWS using Python
  • SAM on ASM Disk Usage
  • user on How to stop and start RDS instance in AWS using Python

Archives

  • October 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2018
  • September 2018
  • August 2018
  • June 2018
  • April 2018
  • January 2018
  • December 2017
  • November 2017
  • September 2017
  • August 2017

Categories

  • Alexa
  • AWS
  • Data Science
  • Enterprise Manager
  • MS SQL
  • MYSQL
  • Oracle AWS
  • Oracle Database
  • Oracle Rman
  • Python
  • RAC
  • UNIX
© 2021 My Tech Blog | WordPress Theme: Lontano Free by CrestaProject.