Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: awr

Oracle average active sessions high threshold

By adminPosted on January 6, 2023

Question : I am trying make sense of the DB load from the AWR report for a period handed over […]

Oracle average active sessions high threshold

By adminPosted on August 29, 2022

Question : I am trying make sense of the DB load from the AWR report for a period handed over […]

In Oracle AWR report how to use “Latch statistics” section in analysis

By adminPosted on August 10, 2022

Question : Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch […]

What useful information can I get from ASH report which I cannot get from AWR report?

By adminPosted on July 30, 2022

Question : What useful information can I get from ASH report which I cannot get from AWR report? What are […]

AWR dbms_workload_repository ash_global_report_text extract text from output

By adminPosted on March 11, 2022

Question : I want to build a scheduled job in Enterprise Manager to trigger every hour the following query: SELECT […]

How to interpret undo statistics in Oracle AWR report? [closed]

By adminPosted on February 26, 2022

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Oracle AWR shows missing stats for SQL ID as top elapsed statement

By adminPosted on December 19, 2021

Question : Why SQL ID has null number of executions and elapsed time / execution in AWR report. SQL ID […]

In Oracle AWR report how to use “Latch statistics” section in analysis

By adminPosted on November 30, 2021

Question : Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch […]

How to interpret undo statistics in Oracle AWR report? [closed]

By adminPosted on October 17, 2021

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

When is a row added to DBA_HIST_SQLSTAT?

By adminPosted on September 21, 2021

Question : I don’t understand the criteria that entails an additional record in the dba_hist_sqlstat view. I have expected there […]

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding