SAP Function Module search on SDO0

Search FMs
  Search FM

SDO0_GET_ALL_TSP_FILE_BYTES - list for each tablespace: total and free space, %, extent count, etc.

SDO0_GET_ALL_TSP_FREE_BYTES - list for each tablespace: total and free space, %, extent count, etc.

SDO0_GET_DBA_FREE_SPACE - Oracle: dba_free_space

SDO0_GET_DBA_SEGMENTS - Oracle: get info from dba_segments

SDO0_GET_DF_SPACE_INFO - Oracle: get tablespace space info

SDO0_GET_FILE_FS_SPACE - Oracle: given a filename, find the filesystem's freespace

SDO0_GET_MAX_NUMEXTENTS - Oracle: get the maximum number of extents of all segments

SDO0_GET_MIN_TSP_FREE_PCT - list for each tablespace: total and free space, %, extent count, etc.

SDO0_GET_NEXT_EXT_LIST - Oracle: get list of next extent sizes and their counts

SDO0_GET_ONE_TSP_FREE_PCT - list for each tablespace: total and free space, %, extent count, etc.

SDO0_GET_ONE_TSP_FREE_PCT1 - list for each tablespace: total and free space, %, extent count, etc.

SDO0_GET_PARAM_VALUE - gets v$parameter.value given v$parameter.name

SDO0_GET_REDOLOG_SIZE - gets v$parameter.value given v$parameter.name

SDO0_GET_TSPNAMES - Oracle: get tablespace_name from dba_tablespaces

SDO0_GET_TSP_SPACE_INFO - Oracle: get tablespace space info

SDO0_LAST_ANALYZE_DAYS_AGO - How many days ago did 'sapdba -analyze PSAP%' run?

SDO0_LAST_ANALYZE_RUN - Get last brconnect run for update statistics

SDO0_LAST_ARCHIVE_DAYS_AGO - How many days ago did last archive log backup run?

SDO0_LAST_ARCHIVE_RUN - Get last brarchive run

SDO0_LAST_BACKUP_DAYS_AGO - How many days ago did last complete database backup run?

SDO0_LAST_BACKUP_RUN - Get last brbackup run

SDO0_LAST_CHECKOPT_DAYS_AGO - How many days ago did 'sapdba -checkopt PSAP%' run?

SDO0_LAST_CHECK_DAYS_AGO - How many days ago did last database check run?

SDO0_LAST_CHECK_RUN - Get last brconnect run for database check

SDO0_SPACE_MAXEXT_COLL - Oracle: get the maximum number of extents of all segments

SDO0_SPACE_SEG_AEXTM - Oracle: get smallest number of allocatable extents limited by max_extents

SDO0_SPACE_SEG_PINCR - Oracle: dba_segments (only SAPR3 schema with pct_increase <> 0)

Return Table index