Database Tuning (MOSC)

MOSC Banner

High waiting events appear in production database: SQL*Net more data from client

edited Feb 6, 2016 3:29AM in Database Tuning (MOSC) 3 commentsAnswered

Hello,

I would like to identify the root cause of the number of events "sql*net more data from client" that appears from 12th january.

There are NOT sql_id or program related, we only find machines and samples in the dba_hist_active_sess_history view:

col event format a40

col dia format a15

col machine format a40

select

TO_CHAR(S.BEGIN_INTERVAL_TIME,'yyyy-mm-dd') dia,

event,machine,count(*)

from DBA_HIST_ACTIVE_SESS_HISTORY sql,

dba_hist_snapshot s

WHERE

S.SNAP_ID = SQL.SNAP_ID

and s.dbid = sql.dbid

and s.instance_number=sql.instance_number

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