Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
956

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
139

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

4 REPLIES 4

Former Member
0 Kudos
140

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
Active Contributor
0 Kudos
139

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
0 Kudos
139

Hi,

Try this function module

DB6_SHOW_DB_TBS_HIS Display Database and Tablespace History

Regards,

Jyothi CH.

former_member222860
Active Contributor
0 Kudos
139

Hi,

Check this FM:

DB02_ORA_SELECT_DBA_SEGMENT

alternatively u can check the tcode: DB02

thanks|

Mahesh