Monitoring PSA table Space

[Former Member]

Hi Experts,

Is there any technical content / BW statistics for monitoring the PSA table spaces.

Or, Any other better way of monitoring the PSA table space.

Any help in the above area would be appreciated.

Regards

Venkata Devaraj !!!

[Former Member]

Hi

Transaction DB02 in BW 3.5

Transaction ORA_SPACE ( DBA cockptit) in BI 7.0

You can have overview and detailed analysis of all the tablespace

Regards

N Ganesh

[Former Member]

Hi,

I think you have not understood my requirement.

We actually want to know which PSA Table is occupying how much space ?

Is there any program / report to check the same ?

Regards

[Former Member]

Hi Venkata,

Goto Trans--> DB02, here there is a option of space, in this option go to tablespaces search for ur tablespace name u will find what percentage of data is filled in ur tablespace.

and then with this tablespace name go into option, tables and indexes here give the tablespace name and move forward.

u will find all the tables present in ur tablespace. u will see a column of size in this table. sort it u will get which table is consuming more space.

[Former Member]

Most probably PSAPODSD and PSAPODSI are two tablespace name for PSA.

At present i even dont know how to get tablespace name. will post it if i find.

Thanks,

Nagesh