PL/SQL (MOSC)

MOSC Banner

Does it valid this natural join with DBA history view

edited Jun 8, 2018 5:00AM in PL/SQL (MOSC) 5 commentsAnswered

Hi all

Is this Natural join valid with DBA history view? any recommendation or inputs would be benefit i used more than 2 tables natural joins because it's how it started to do it, So it doesn't needs to be like that anay other option would it be appreciate it. But the columns I have on this query are the ones I"m looking for, definitely I'm missing something but I'm rushing to get these stats

Thanks in advance

Jesus

  SELECT /*+ MATERIALIZE */

      decode(IO_OFFLOAD_ELIG_BYTES_TOTAL,0,'No','Yes') Offload

      , TO_CHAR(begin_interval_time, 'YYYY-MM-DD') day

      , sql_id

      , plan_hash_value

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center