Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Session

The following views provide information about the current Oracle session:

*$MYSTAT

Provides information about current session statistics. One row exists for every entry in *$STATNAME.

*$PROCESS

Lists each process in the instance. You can join this view to *$SESSION to gain more information.

*$SESS_IO

Provides up-to-date I/O information for each session in the database. Available after database is opened.

*$SESSION

Lists each session in the instance.

*$SESSION_CONNECT_INFO

Provides information about the network connection of the current session.

*$SESSION_CURSOR_CACHE

Provides information about the current session’s cursor usage.

*$SESSION_EVENT

Provides information about how much time each session spends waiting on each event specified in *$EVENT_NAME.

*$SESSION_LONGOPS

Provides information about the status of long-running operations for sessions. Details the number of work units already accomplished and the expected amount of work required to complete the operation.

*$SESSION_OBJECT_CACHE

Provides object cache statistics for the current session in the current instance.

*$SESSION_WAIT

Lists the resources upon which each active session is waiting and how long each session has been waiting for each resource.

*$SESSTAT

Provides information about each session’s session statistics. There is one row for each session for each statistic specified in *$STATNAME.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page