Database Tuning (MOSC)

MOSC Banner

SQL*Net message from client

edited Nov 27, 2018 4:00AM in Database Tuning (MOSC) 4 commentsAnswered

I am having this "SQL * Net message from client" event in the auto trace, can it be a problem of lack of resource on the server or network?

SQL ID: 7r2mq75x3zh7k Plan Hash: 3718472611

SELECT  PageBlob 

FROM

(SELECT b.OID,b.PAGENUMBER,b.PAGEBLOB  FROM NEOSDE.N_2_JTopo b WHERE b.OID

  NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID FROM NEOSDE.D12913 WHERE

  DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE

  l.lineage_name = :source_lineage_name AND l.lineage_id <= :source_state_id)

  AND SDE_STATE_ID = 0) UNION ALL SELECT a.OID,a.PAGENUMBER,a.PAGEBLOB  FROM

Tagged:

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