function module to find out DATA BASE size, free space, used size

[Former Member]

Is there any function module to find out DATA BASE , free space, used size

FM that gives all the details of the Date base

what data base, what is the size, free space, used space etc...

instead of writing case by case for each data base. based on CASE SY-DBSYS.

[Former Member]

Hi,

Please try these FM

For Oracle:

/SDF/GET_DB16_INFO

/SDF/GET_DB_ORA_TABLES_GROWTH

For SQl:

/SDF/MSS_DB_SPACE_HISTORY

DB6_SHOW_AUDIT_LOG Display/Maintain Database Configuration

DB6_SHOW_DB_TBS_HIS Display Database and Tablespace History

[awin_prabhu]

Hi friend,

Also try T-code AL02.

Click 'Freespace management checked' button in it and see.

Thanks..

Edited by: Sap Fan on Feb 26, 2009 4:59 AM

[Former Member]

Hi,

Try this function module

DB6_SHOW_DB_TBS_HIS Display Database and Tablespace History

Regards,

Jyothi CH.

[former_member222860]

Hi,

Check this FM:

DB02_ORA_SELECT_DBA_SEGMENT

alternatively u can check the tcode: DB02

thanks|

Mahesh