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:
|
| 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 :
|
| 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:
|
| 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.
Comments