Long Running Query (Doc ID 2775463.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

Problem Summary
---------------------------------------------------
Long running Query

Problem Description
---------------------------------------------------
A query is running longer on DB.


Below is the query and using the bind variables.

  --select * from(
  SELECT l.ListingID as STREAM_ID, l.ListingID as REQUEST_ID, h.RAW_RECORD_ID, h.
  vendor_instrument_type, h.entity_code,
  i.IndexID, ip.filter, l.listingID as SOLA_ID, 'Indx' as BASKETNAME, f.Fa
  milyID as I_FAMILY_ID, f.name I_CLUSTER_NAME,
  f.LastUpdated as I_CLUSTER_DATE,
  i.CurrencyCode, sp.name as INSTRUMENT_NAME,
  v.Name as RETURN_TYPE, sp.name AS LONG_DESCRIPTION, substr(sp.Name, 1, 4
  0) AS SHORT_DESCRIPTION,
  ip.CalculationMask, f.CurrentDate,
  p.ConstituentCount AS CONSTITUENT_COUNT,
  p.ASATDATE as POSITIONDATE,
  p.Value as INDEX_VALUATION,
  p.CurrencyCode as INDEX_VALUATION_CCY,
  p.Divisor,
  p.indexpositionid,
  p.isopen,
  p.asatdate,
  p.variantid,
  p.value,
  p.marketcap,
  p.cash,
  p.fxdate,
  p.statusflagid,
  p.created,
  p.lastupdated,
  case when sp.primarylistingid = l.listingID then 'Y' else 'N' end primar
  y_listing_flag,
  e.mic exchange,
  case when f.hastplus = 1 then 'Y' else 'N' end has_tplus_flag,
  D.NAME spl_reinvest_schdl,
  CASE WHEN tlep.value = 1 THEN 'Y' WHEN tlep.value = 0 THEN 'N' ELSE null
  END REG_871M_QUALIFIED_INDEX_IND,
  null REG_871M_ELIGIBLE_IND
  --RANK() OVER (PARTITION BY

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.