Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 03:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 03:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 05:13 AM

    Hi,

    Try this function module

    DB6_SHOW_DB_TBS_HIS Display Database and Tablespace History

    Regards,

    Jyothi CH.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2009 at 05:18 AM

    Hi,

    Check this FM:

    DB02_ORA_SELECT_DBA_SEGMENT

    alternatively u can check the tcode: DB02

    thanks|

    Mahesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.