Performance - EBS (MOSC)

MOSC Banner

More "SQL*Net message from client" wait event on a select against nls_session_parameters

edited Sep 10, 2010 3:29AM in Performance - EBS (MOSC) 6 commentsAnswered
Hello Gurus,
Our's is a 5 TB EBS database and we're experiencing some strange situation. One of the self-service page was taking a longer time and I turned on the trace by setting the profile for the user and it generated around 5-6 files. When I tkprof-ed the trace files, I found out that, there's a huge amount of wait time on the event SQL*Net message from client by the following SQL :

select parameter, value
from
 nls_session_parameters

Here're the excerpts from the tkprof output files :

********************************************************************************

select parameter, value
from
 nls_session_parameters


call     count       cpu    elapsed       disk      query    current        rows

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center