Dictionary Query Running Slow on DBA_Types in 12.2 (Doc ID 2585363.1)

Last updated on DECEMBER 16, 2019

Applies to:

Symptoms

• Query running slow on sys.dba_types 12.2:
  File: IN 12.2
  ========

  select *
  from
  sys.dba_types where rownum < :"SYS_B_0"

  call count cpu elapsed disk query current rows
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  Parse 1 0.01 0.01 4 40 0 0
  Execute 1 222.43 222.48 3 30 0 0
  Fetch 1 0.00 0.00 0 0 0 0
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  total 3 222.45 222.50 7 70 0 0

  File: IN 12.1
  ========

  select *
  from
  sys.dba_types where rownum < :"SYS_B_0"

  call count cpu elapsed disk query current rows
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  Parse 1 0.44 0.60 0 4 0 0
  Execute 1 0.00 0.00 0 0 0 0
  Fetch 1 0.00 0.00 0 0 0 0
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  total 3 0.44 0.60 0 4 0 0

   

Changes

 None

Cause

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