Audit Issue: Exiting a Database Session is Extremely Slow
Last updated on JUNE 21, 2017
Applies to:Oracle Net Services - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.2]
Information in this document applies to any platform.
Logging off from a database session using SQL*Plus or any other tool is extremely slow. It is more likely to reproduce with remote logins and not necessarily with bequeath or local connections. This behavior can occur with any tool (SQL*Plus, JDBC). No action in the database is necessary, simply logging in and logging off might exhibit this problem. Level 16 server sqlnet traces may show a normal logoff and then repeating:
No recent changes necessarily. Auditing is enabled.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms