function module for db02

[Former Member]

Hi experts ,

I need to extrect the tablespace overview and database size datas of the transaction DB02.

i tried using the following function modules:

DB_ORA_TABLESPACE_HISTORY

GET_TSP_INFO_ORA

DB02_ORA_FILL_TS

But i am not able to get datas of database size overview and

columns, like 'Autoextend' , 'total size', 'sum of all free fragments' , 'contents' in tablespace overview.

waiting for your reply.

[sunny_pahuja2 · Accepted solution]

Hi,

Use function module- DB_ORA_CURRENT_SIZES

Thanks

Sunny

[Former Member · Accepted solution]

Thanks sunny. I tried that.. with that FM i can derive the autoextend status.

But i still need the free fragment details.

Please help me with some other function module.

Points awarded.

Thank you.

[former_member188883 · Accepted solution]

Hi Kirthi,

You this function module

GET_DB_ORA_TABLESPACES_AS

or

C_GET_DB_ORA_TABLE_AS

Regards

Deepak Kori

[Former Member · Accepted solution]

Hi deepak,

Thanks a lot. The function module that u suggested could retrieve the values of the columns 'autoextend' , 'contents' . But still i am unable to get the values of 'total size' , 'sum of all fragments ' , 'no of files' . please help me.

points awarded. thanks.

[former_member188883 · Accepted solution]

Hi Kirthi,

please refer function module C_ORA_TS_INIT. This is the solution to all your requirements.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hey thank you so much deepak.

The function module resolved the problem.

But in the same t-code 'database size' is also retrieved. is there any function module available to get those value?

Points awarded. Thank u so much.

[former_member188883 · Accepted solution]

Hi,

you can use function module C_ORA_DB_OV_INIT

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi deepak,

Thank u so much. The solution u gave solved my problem.

the exact function module to retrieve db size vales is 'C_ORA_DB_INIT'.

Thanks. points awarded.