01 |
SDBORA_LAST_ANALYZE_DAYS_AGO |
How many days ago did 'sapdba -analyze PSAP%' run? |
|
02 |
SDBORA_LAST_CHECKOPT_DAYS_AGO |
How many days ago did 'sapdba -checkopt PSAP%' run? |
|
04 |
SDBORA_GET_PARAM_VALUE |
gets v$parameter.value given v$parameter.name |
|
05 |
SDBORA_GET_DBA_SEGMENTS |
Oracle: get info from dba_segments |
|
06 |
SDBORA_GET_DBA_FREE_SPACE |
Oracle: dba_free_space |
|
07 |
SDBORA_SAPR3_SEGS_PCTINCREASE |
Oracle: dba_segments (only SAPR3 schema with pct_increase <> 0) |
|
08 |
SDBORA_GET_TSP_FREE_SPACE |
list for each tablespace: total and free space, %, extent count, etc. |
|
09 |
SDBORA_GET_MIN_TSP_FREE_PCT |
list for each tablespace: total and free space, %, extent count, etc. |
|
10 |
SDBORA_GET_MAX_NUMEXTENTS |
Oracle: get the maximum number of extents of all segments |
|
11 |
SDBORA_LIST_MANYEXTENTS |
Oracle: get the maximum number of extents of all segments |
|
13 |
SDBORA_GET_REDOLOG_SIZE |
gets v$parameter.value given v$parameter.name |
|
14 |
SDBORA_GET_TSPNAMES |
Oracle: get tablespace_name from dba_tablespaces |
|
15 |
SDBORA_GET_ONE_TSP_FREE_PCT |
|
|
16 |
SDBORA_GET_SEGS_FREEEXT |
Oracle: get info from dba_segments |
|
17 |
SDBORA_GET_SEGS_MAXEXT_MIN |
Oracle: get info from dba_segments |
|
19 |
SDBORA_GET_SEGS_IN_TSP |
Oracle: get info from dba_segments |
|
20 |
SDBORA_GET_NEXTEXT_IN_TSP |
Oracle: for each seg in tsp, get next_extent and ext num. 'til max_extents |
|
21 |
SDBORA_GET_NEXT_EXT_LIST |
Oracle: get list of next extent sizes and their counts |
|
22 |
SDBORA_GET_NEXT_EXT_LIST1 |
Oracle: get list of next extent sizes and their counts |
|
24 |
SDBORA_SPACE_MAXEXT_COLL |
Oracle: get the maximum number of extents of all segments |
|
25 |
SDBORA_SPACE_AEXTM_COLL |
Oracle: get smallest number of allocatable extents limited by max_extents |
|
26 |
SDBORA_SPACE_PINCR_CT |
Oracle: dba_segments (only SAPR3 schema with pct_increase <> 0) |
|
27 |
SDBORA_GET_SEGS_MAXEXT_LIST |
Oracle: get info from dba_segments |
|
|
|
|
|