Viewing other reports on users


Warning

This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.

PATROL contains the following reports that provide further information about users and user sessions:

  • Active Sessions
  • SQL Statements
  • Display Oracle Users
  • Profiles
  • Role Information
  • User Account Info
  • User Role/Column Privilege
  • User Session and User Session Data
  • User Session SQL and User Session Detail
  • Users/Objects in SYSTEM
  • Users with DBA Role

These reports are described in the following sections.

Viewing the Active Sessions report

The Active Sessions report lists information about all active user sessions.

Run the report by choosing KM Admin > Reports > Users > Active Sessions from the INSTANCE menu, or Reports > Active Sessions from the USERS menu. The following table shows the information that the report provides.

Active Sessions report

Item Description
Session Statistics
OS User name of the user for the operating system
Oracle User name of the user in Oracle
Session ID ID of the user session in Oracle
Statistic Name name of the statistic that is currently active
Statistic Value value of the currently active statistic
Session Locks Held
Oracle User name of the user in Oracle
Session ID ID of the user session in Oracle
Serial Number
Session serial number
This number uniquely identifies the objects of a session. It guarantees that session-level commands are applied to the correct objects if the session ends and another session begins using the same session ID.
Type type of lock that is held
Resource_id1 lock identifier 1 for the type of lock
Resource_id2 lock identifier 2 for the type of lock
Lock Held user who is holding the lock
Lock Request user who is requesting the lock
Session Details
OS User name of the user for the operating system
Oracle User name of the user in Oracle
Session ID ID of the user session in Oracle
Connect Time in Minutes amount of time in minutes the user has been connected

Viewing the SQL Statements report

The SQL Statements report lists information about SQL statements that were issued by the current sessions.

Run the report by choosing Reports > SQL Statements from the USERS menu, or KM Admin > Reports > Users > SQL Statements from the INSTANCE menu. The following table shows the information that the report provides.



SQL Statements report

Item

Description

Username

user name that the SQL statement ran under

SID

Oracle SID for the session

Name

SQL statement that was run

Memory

memory that the SQL statement used

Runtime Memory

runtime memory that the SQL statement used

Sorts

number of sorts retrieved by the SQL statement

Disk Reads

number of disk reads the SQL statement generated

Buffers Read

number of buffers that were read as a result of the SQL statement


Viewing the Display Oracle Users report

The Display Oracle Users report displays all Oracle users on the instance.

Run this report by choosing Reports > Display Oracle Users from the USERS menu, or KM Admin > Reports > Users > Display Oracle Users from the INSTANCE menu. The following table shows the information that the report provides.



Display Oracle Users report

Item

Description

OS User

the username for the operating system

Username

the username for Oracle

SPID

the system ID number for the session

SID

the session identifier for the session

Program

the program that is running for the SID


Viewing the Profiles report

The Profiles report displays all profiles that are available on the instance.

Run this report by choosing Reports > Profiles from the USERS menu, or KM Admin > Reports > Users > Profiles from the INSTANCE menu. The following table shows the information that the report provides.



Profiles report

Item

Description

Profile

name of the profile

Resource Name

name of the database or system resource

Limit

threshold of the resource that is available to the profile If the limit is UNLIMITED, no thresholds are set for that resource for the profile. If the value is DEFAULT, the thresholds are the default settings that were set by the system administrator.


Viewing the Role Information report

The Roles report displays the currently used roles in the instance.

Run this report by choosing Reports > Role Information from the USERS menu, or KM Admin > Reports > Users > Role Information from the INSTANCE menu. The following table shows the information that the report provides.

Role Information report

Field Description
Roles Granted
User or Role user name or name of the role
Granted Role granted role given to the user name
Admin Option whether the username can act as an administrator for that granted role
Default Role whether the granted role is the default
Role System Privileges Report
Role Name name of the role
Privilege privilege granted to the role
Admin Option whether the role can act as administrator

Viewing the User Account Info report

The User Account Information report displays statistics and information for the user accounts that you select on the instance.

Run this report by choosing Access this report by choosing Reports > User Account Info from the USERS menu, or KM Admin > Reports > Users > User Account Info from the INSTANCE menu. The following table shows the information that the report provides.

User Account Info report

Item Description
User Default/ Temporary Tablespaces Report
Username name of the Oracle user
Default Tablespace default tablespace assigned to that user
Temporary Tablespace temporary tablespace assigned to the user
Profile profile assigned to the user
User Tablespace Quotas Report
Username name of the Oracle user
Tablespace tablespace assigned to the user
Quota (Bytes) amount of space that the user can use on the tablespace A value of -1 indicates there is no limitation.
Used (Bytes) number of bytes that the user has used on the tablespace
Pct Used percentage of the allotted space that the user has used
User System Privileges Report
Username name of the Oracle user
Privilege privilege granted to the user
Admin Option whether the privilege granted to the user includes the ADMIN option

Viewing the User Role/Column Privilege report

The User Role/Column Privilege report displays the column and table privileges for the user roles you select.

Run this report by choosing Reports > User Role/Column Privilege from the USERS menu, or KM Admin > Reports > Users > User Role/Column Privilege from the INSTANCE menu. The following table shows the information that the report provides.



User Column/Role Privilege report

Item

Description

Username

name of the Oracle user

Table Name

name of table that the column is in

Column Name

name of the column that has the object privileges

Privilege

privilege granted to the user

Admin

whether the privilege granted to the user includes the ADMIN option


Viewing the User Session and User Session Data reports

The User Session and User Session Data reports list information about the selected user or users.

Run this report by choosing Reports > User Session from the USERS menu, or KM Admin > Reports > Users > User Session Data from the INSTANCE menu. Select a user or ALL USERS, and then click Accept.

The following table shows the information that these reports provide.

User Session report

Field Description
Current SQL Commands Report
OS User operating system user name
Oracle User Oracle user name
Session ID ID of the session
SQL Statement SQL statement that was used in the session
User Statistics
OS Users operating system user name
Oracle User Oracle user name
Session ID ID of the session
Stat Name

name of the statistic that is reported in this report:

  • CPU used by this session
  • execute count
  • physical reads
  • physical writes
  • session logical reads
  • sorts (disk)
  • sorts (memory)
  • table fetch continued row
  • table scan rows gotten
  • table scans (long tables)
  • table scans (short tables)
  • user commits
  • user rollbacks
Stat Value value of the statistic
Locks Held/Session Report
Oracle Username Oracle user name
Session ID ID of the session
Serial # serial number for the user session
Type type of lock held by the user session
Resource_id1 first resource that is locked by the user session
Resource_id2 second resource that is locked by the user session
Lock Held

the type of lock held :

  • None
  • Null
  • RS - Row Share
  • RX - Row Exclusive
  • S - Share
  • SRX - Share Row Exclusive
  • X - Exclusive
Lock Request user who requested the lock

Viewing the User Session SQL and User Session Detail reports

The User Session SQL report provides the SQL command that was issued by the user in the current session.

From the USERS_INSTANCE menu, choose Reports >User Session SQL.

For more detailed information about a specific user session, from the USERS_INSTANCE menu, choose User Session Detail.

The following table shows the information that the User Session Detail report provides.

User Session Detail report

Field Description
Oracle User Statistics report
OS User ID user name for the operating system account
Oracle User ID user name for the Oracle account
Session ID ID of the session for the username
Statistic Name

name of the statistic that is reported in this report:

  • CPU used by this session
  • execute count
  • physical reads
  • physical writes
  • session logical reads
  • sorts (disk)
  • sorts (memory)
  • table fetch continued row
  • table scan rows gotten
  • table scans (long tables)
  • table scans (short tables)
  • user commits
  • user rollbacks
Statistic Value value of each statistic
Oracle Connect Time/Session report
OS User ID user name for the operating system account
Oracle User ID user name for the Oracle account
Session ID ID of the session for the username
Connect Time in Minutes how long the user has been logged in and running

Viewing the Users/Objects in SYSTEM report

The Users/Objects in SYSTEM report lists the objects and their owners that are in the SYSTEM tablespace. The following information about the objects is displayed:

  • Owner of the object
  • Object name
  • Object Type
  • Status of the object
  • Object creation date

Run this report from a USERS application menu by choosing Reports > Users/Objects in SYSTEM.

Viewing the Users with DBA Role report

The Users with DBA Role report lists all users in the instance that can have DBA privileges.

Run this report from a USERS application menu by choosing Reports > Users with DBA Role.

Was this page helpful? Yes No Submitting... Thank you

Comments