Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Get Live Help
You have selected a product bundle. Can you please select the individual product for us to better serve your request.*
There is not a technical support engineer currently available to respond to your chat. For prompt service please submit a request using our service request form.
The following articles may solve your issue based on your description.
The Redo Log Storage collection provides a list of all Redo log groups and their overall properties.
The archive status of the log file:
A system-allocated number (SCN), identifying the first time a change was recorded in this log.
The time at which the first SCN in the log was recorded.
The status of the group is one of the following:
This information is derived from the v$log table.
The log group number.
The sequence number.
The size (in megabytes) of the log .
The Sessions Summary collection retrieves information regarding session types.
The average number of active sessions during the specified time range
Active Sessions PCT
The average percentage of active sessions within the total sessions during the specified time range
The average number of background sessions that ran during the specified time range.
The average number of blocked processes that were collected during the specified last sample.
The average number of cached sessions during the specified time range
The average number of foreground sessions that ran during the specified time range.
The average number of inactive sessions during the specified time range
The average number of killed sessions during the specified time range
In multitenant architectures, the name of the pluggable database
The average number of sniped sessions during the specified time range
The average number of sessions during the specified time range
Total Sessions Limit
The maximum allowable number of sessions
The Servers collection provides instance processes.
The number of dedicated server processes. Each dedicated server process service a single client process.
The number of multi-threaded server (MTS) dispatchers. MTS dispatchers coordinate the allocation of shared servers to client tasks.
The number of servers that service more than one client process. This value includes both shared servers and multi-threaded servers (MTS).
The Tablespaces Free Space Fragmentation collection retrieves information regarding the fragmentation of tablespace free space.
None (on-demand collection).
Average Extent Size
The average size of free extents in this tablespace
The number of free extents in this tablespace
Max Extent Size
The size of the largest free extent in the selected tablespace
Min Extent Size
The size of the smallest free extent in this tablespace
The total sum of fragments that are smaller than the maximum allocated extent in the tablespace, but bigger than, or equal to, the minimum allocated extent in the tablespace
The name of the currently selected tablespace
Total sum of fragments whose size is less than the size of the minimum extent in the tablespace
Total sum of fragments that are greater than or equal to the minimum extent in the tablespace.
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
Upgrade to IE 11 Click here
Upgrade to Chrome Click here
If you continue in IE8, 9, or 10 you will not be able to take full advantage of all our great self service features.