old_contents: # (C) Datadog, Inc. 2019-present
  # All rights reserved
  # Licensed under Simplified BSD License (see LICENSE)
  
  import pytest
  
  METRICS = [
      'oracle.process.pga_maximum_memory',
      'oracle.process.pga_used_memory',
      'oracle.process.pga_freeable_memory',
      'oracle.tablespace.in_use',
      'oracle.logons',
      'oracle.tablespace.used',
      'oracle.process.pga_allocated_memory',
      'oracle.tablespace.offline',
      'oracle.active_sessions',
      'oracle.temp_space_used',
      'oracle.physical_writes',
      'oracle.tablespace.size',
      'oracle.shared_pool_free',
      'oracle.library_cachehit_ratio',
      'oracle.memory_sorts_ratio',
      'oracle.buffer_cachehit_ratio',
      'oracle.physical_reads',
  ]
  
  
  @pytest.mark.e2e
  def test_check(dd_agent_check):
      aggregator = dd_agent_check()
      for metric in METRICS:
          aggregator.assert_metric(metric)
  
new_contents: # (C) Datadog, Inc. 2019-present
  # All rights reserved
  # Licensed under Simplified BSD License (see LICENSE)
  
  import pytest
  
  METRICS = [
      'oracle.tablespace.used',
      # ProcessMetrics
      'oracle.process.pga_used_memory',
      'oracle.process.pga_allocated_memory',
      'oracle.process.pga_freeable_memory',
      'oracle.process.pga_maximum_memory',
      # SystemMetrics
      'oracle.buffer_cachehit_ratio',
      'oracle.cursor_cachehit_ratio',
      'oracle.library_cachehit_ratio',
      'oracle.shared_pool_free',
      'oracle.physical_reads',
      'oracle.physical_writes',
      'oracle.enqueue_timeouts',
      'oracle.gc_cr_block_received',
      'oracle.cache_blocks_corrupt',
      'oracle.cache_blocks_lost',
      'oracle.logons',
      'oracle.active_sessions',
      'oracle.long_table_scans',
      'oracle.service_response_time',
      'oracle.user_rollbacks',
      'oracle.sorts_per_user_call',
      'oracle.rows_per_sort',
      'oracle.disk_sorts',
      'oracle.memory_sorts_ratio',
      'oracle.database_wait_time_ratio',
      'oracle.session_limit_usage',
      'oracle.session_count',
      'oracle.temp_space_used',
      # TableSpaceMetrics
      'oracle.tablespace.in_use',
      'oracle.tablespace.size',
      'oracle.tablespace.in_use',
      'oracle.tablespace.offline',
  ]
  
  
  @pytest.mark.e2e
  def test_check(dd_agent_check):
      aggregator = dd_agent_check()
      for metric in METRICS:
          aggregator.assert_metric(metric)
      aggregator.assert_all_metrics_covered()
  
subject: Add more metrics to e2e tests (#5869)