|
| Spaced saved from a resize | Borrowed from http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:153612348067
<p>This is a report of how much space could be saved it datafiles are resized via the alter database datafile ... resize .. |
| Free Space | Borrowed from http://asktom.oracle.com/~tkyte/Misc/free.html
<ul><li>Tablespace Name: name of tablespace, leading '*' indicates a good locally managed tablespace, leading blank means it is a bad dictionary managed tablespace. Second character of A implies ASSM managed storage, second character of M implies manually managed (pctused, freelists, etc are used to control space utilization)
<li> Kbytes: allocated space of the tablespace, sum of kbytes consumed by all datafiles associated with tablespace.
<li> Used: space in the tablespace that is used by some segment.
<li> Free: space in the tablespace not allocated to any segment.
<li> %Used: ratio of free to allocated space
<li> largest: mostly useful with dictionary managed tablespaces, the size of the largest contigously set of blocks available. If this number in a dictionary managed tablespace is smaller than the next extent for some object, that object could fail with "out of space" even if the FREE column says there is lots of free space.
<li> MaxPoss Kbytes: the autoextend max size (note CAN be smaller than the allocated size!!!! you can set the maxsize to be less than the current size of a file)
<li> %Max Used: how much of the maximum autoextend size has been used so far
</u;> |
| Segment Access Statsitics | This report gives the access statistics by segment and access type, as given by the v$segment_statistics dynamic view. It takes only the following events: logical reads, physical reads, db block changes, buffer busy waits, row lock waits, physical writes and itl waits. |
| Fnd_Global.apps_initialize (APPS) | Select to retrieve the parameters needed to initizalize apps in sql
Fnd_Global.apps_initialize(user_id,responsability_id,responsabilty_application_id) |
| Sort Usage | Sort usage for current activity |
| Long processes | Show the estimate of the time remaining for long running processes. |
| Graphical segment access Stats (SD 1.1) | This Report gives the segment access statistics (from v$segment_statistics) giving those segments that contribute more than 1% of the total (by statistic) |
| Who | A Report to show active seesion and some details about there activities. Includes 2 Child-reports for Active SQL and PID for the process supporting the session. |
| Objects per user - overview | This report shows a grid that shows how many objects of each type each user has.
It prints a grid with object types as columns and users as rows. |
| Flash_Recovery_Area | Space used by Flash_Recovery_Area |
| Rac_sessions | all sessions in a RAC enviroment. including instance_name, os_process etc etc etc |
| Kill Session | Generate SQL statements Alter System Kill session to kill sessions by user |
| Oracle Applications Applied Patches | Query used to determine whether a patch has been applied to Oracle Applications |
| Kill Session (Parent/Child Report) | A report based on 'Who' by JOACHIM MAYER to generate the SQL for the Kill Session command in the child pane - written so it will not generate the SQL for system processes where the username is null. The SQL for the child report can also be plugged into the 'Who' report to create an extra tab. |
| Java source viewer | This is a master/detail report that displays the owner and name of the Java source in the top pane. When selected the Java is displayed in the lower pane. There's also a second child to display the count of the lines.
(Requires select privileges on DBA_SOURCE) |