Thanks for the feedback but what I need to know is the session parameters while a session is logged into the database. The clients use an application Icon and therefore doesn't see the SQL prompt.

04-11-2002, 04:25 AM

ssmith

If anyone wants to know I have the following information from Oracle:
"Unfortunately, that information is only available within the user session. There is no data dictionary view which provides insight into the session-level settings for another user. "