Help! : How to get data of the DB02's Tablespaces Overview

[Former Member]

Hi, All

I'm running netweaver 2004s on oracle 10.2 db ,is there any function module by which we can get the data of tablespaces's overview in DB02? i will call them in my customizing program.

[stefan_koehler]

Hello,

the DB02/DB02n perform different function calls to get the whole information.... here are some functions to get the needed data:

- DB_ORA_CURRENT_SIZES

- GET_TSP_INFO_ORA

- DB02_ORA_FILL_TS

Regards

Stefan

[Former Member]

hi,Stefan

first,thank you for your help.

i need these data:

Tablespace

Size total

Size chg/day

Free total

Used total

Used chg/day

Extends total

Extends chg/day

but i don't know how to use these function module to get them.pls more info

[stefan_koehler]

Hello,

you will get these data with the function calls that i mentioned.

Only execute the functions and you will receive an internal table from the function which includes that information.

Regards

Stefan

[former_member213240]

Hi Stefan,

Could you please let me know the FM to extract the data from the below tcode.

DB02 -> Space -> Addn Functions -> BW Analysis.

Thanks in advance,

Regards

Dinesh