01 |
SDO0_GET_MIN_TSP_FREE_PCT |
list for each tablespace: total and free space, %, extent count, etc. |
|
02 |
SDO0_GET_ONE_TSP_FREE_PCT |
list for each tablespace: total and free space, %, extent count, etc. |
|
03 |
SDO0_GET_NEXT_EXT_LIST |
Oracle: get list of next extent sizes and their counts |
|
04 |
SDO0_GET_DBA_FREE_SPACE |
Oracle: dba_free_space |
|
05 |
SDO0_SPACE_MAXEXT_COLL |
Oracle: get the maximum number of extents of all segments |
|
06 |
SDO0_SPACE_SEG_AEXTM |
Oracle: get smallest number of allocatable extents limited by max_extents |
|
07 |
SDO0_SPACE_SEG_PINCR |
Oracle: dba_segments (only SAPR3 schema with pct_increase <> 0) |
|
08 |
SDO0_GET_MAX_NUMEXTENTS |
Oracle: get the maximum number of extents of all segments |
|
09 |
SDO0_GET_TSPNAMES |
Oracle: get tablespace_name from dba_tablespaces |
|
10 |
SDO0_GET_DBA_SEGMENTS |
Oracle: get info from dba_segments |
|
11 |
SDO0_GET_PARAM_VALUE |
gets v$parameter.value given v$parameter.name |
|
12 |
SDO0_GET_REDOLOG_SIZE |
gets v$parameter.value given v$parameter.name |
|
13 |
SDO0_LAST_CHECKOPT_DAYS_AGO |
How many days ago did 'sapdba -checkopt PSAP%' run? |
|
14 |
SDO0_LAST_ANALYZE_DAYS_AGO |
How many days ago did 'sapdba -analyze PSAP%' run? |
|
15 |
SDO0_GET_ONE_TSP_FREE_PCT1 |
list for each tablespace: total and free space, %, extent count, etc. |
|
16 |
SDO0_GET_ALL_TSP_FILE_BYTES |
list for each tablespace: total and free space, %, extent count, etc. |
|
17 |
SDO0_GET_ALL_TSP_FREE_BYTES |
list for each tablespace: total and free space, %, extent count, etc. |
|
18 |
SDO0_GET_TSP_SPACE_INFO |
Oracle: get tablespace space info |
|
19 |
SDO0_GET_DF_SPACE_INFO |
Oracle: get tablespace space info |
|
20 |
SDO0_GET_FILE_FS_SPACE |
Oracle: given a filename, find the filesystem's freespace |
|
21 |
SDO0_LAST_ANALYZE_RUN |
Get last brconnect run for update statistics |
|
22 |
SDO0_LAST_BACKUP_DAYS_AGO |
How many days ago did last complete database backup run? |
|
23 |
SDO0_LAST_BACKUP_RUN |
Get last brbackup run |
|
24 |
SDO0_LAST_ARCHIVE_DAYS_AGO |
How many days ago did last archive log backup run? |
|
25 |
SDO0_LAST_ARCHIVE_RUN |
Get last brarchive run |
|
26 |
SDO0_LAST_CHECK_DAYS_AGO |
How many days ago did last database check run? |
|
27 |
SDO0_LAST_CHECK_RUN |
Get last brconnect run for database check |
|
|
|
|
|