rs_script_stats
The following table lists the columns for the rs_script_stats view. The equivalent jcs_script_stats view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| OWNER | VARCHAR2 | The owner (schema) of a script |
| NAME | VARCHAR2 | The unique name of a script within a schema |
| SCRIPT_ID | NUMBER | The internal id of a script |
| VERSION | NUMBER | The version number of a script |
| AVG_CPU_COST | NUMBER | The average CPU cost of the jobs run using this script, in seconds |
| AVG_RUN_TIME | NUMBER | The average run time of the jobs created by the script in seconds |
| AVG_OUTPUT_FILESIZE | NUMBER | The average file size of the output file |
| AVG_LOG_FILESIZE | NUMBER | The average file size of the log file |
| STDDEV_CPU_COST | NUMBER | Standard deviation of the CPU cost in seconds |
| STDDEV_RUN_TIME | NUMBER | Standard deviation of the run time in seconds |
| STDDEV_OUTPUT_FILESIZE | NUMBER | Standard deviation of the file size of the output file |
| STDDEV_LOG_FILESIZE | NUMBER | Standard deviation of the file size of the log file |
| EXECUTION_COUNT | NUMBER | The number of jobs executed successfully |
| INVALID | NUMBER | Is the script valid (Y or N)? |
| FAILED_EXECUTION_COUNT | VARCHAR2 | The number of jobs executed with an error |
| EXECUTED_LAST_MINUTE | NUMBER | The number of jobs that finished in the last minute |
| EXECUTED_LAST_5_MINUTES | NUMBER | The number of jobs that finished in the last 5 minutes |
| EXECUTED_LAST_HOUR | NUMBER | The number of jobs that finished in the last hour |
| EXECUTED_LAST_24_HOURS | NUMBER | The number of jobs that finished in the last 24 hours |
| EXECUTED_LAST_7_DAYS | NUMBER | The number of jobs that finished in the last 7 days |
| COMPLETED_LAST_MINUTE | NUMBER | The number of jobs that finished successfully in the last minute |
| COMPLETED_LAST_5_MINUTES | NUMBER | The number of jobs that finished successfully in the last 5 minutes |
| COMPLETED_LAST_HOUR | NUMBER | The number of jobs that finished successfully in the last hour |
| COMPLETED_LAST_24_HOURS | NUMBER | The number of jobs that finished successfully in the last 24 hours |
| COMPLETED_LAST_7_DAYS | NUMBER | The number of jobs that finished successfully in the last 7 days |
| LAST_EXECUTION_TIMESTAMP | TIMESTAMP | Timestamp when the latest execution finished |
| LAST_COMPLETED_TIMESTAMP | TIMESTAMP | Timestamp when the latest successful execution finished |
| LAST_STATUS | VARCHAR2 | Status of the last execution that finished |
| LAST_STATUSCODE | VARCHAR2 | Short statuscode of the last execution that finished |
| QUEUED | NUMBER | The number of jobs that are currently in the QUEUED status |
| RUNNING | NUMBER | The number of jobs that are currently in the RUNNING, WAITING or CONSOLE status |
| SCHEDULED | NUMBER | The number of jobs that are currently in the SCHEDULED status |
| QUEUING_DELAY | NUMBER | The highest amount of seconds that any of the QUEUED jobs has been queued |
| STEP_COUNT | NUMBER | The number of steps in the chain |
| CURRENT_STEP | NUMBER | Currently executing step (1.STEP_COUNT) |
note
VERSION: Version is not increased with one anymore after changing the object.
note
INVALID: The column invalid always shows N for non OracleJob job definitions and ? for all OracleJob job definitions.
plsqlTopic
onsiteTopic