Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Viewing other reports on users
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 |
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
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
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
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
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.