V_$SORT_USAGE equivalent table or structure in bw

[Former Member]

Hi Experts,

I want to access the contents of this oracle data dictionary view V_$SORT_USAGE for a particular tablespace through an abap program, so is there any structure used by a fm or some database tables or view which is equivalent to this view V_$SORT_USAGE.

Through db02 I was able to get the structure similar to DBA_TABLESPACES of oracle database, in similar way i want information for this view in bw database

Does anybody know about this information,

It will be of great use to me.

Thanks,

Hema.

[Former Member]

Hi Prabhakaran,

There is a report like <b>RSORAVDV</b> which has the ability to query the sys views. i.e DBA_TABLE, V$SORT_USAGE, etc.

Sorry for not remembering the report name. Let me look around and get back if you did n't find the report.

Otherwise, the other solution would be directly from the command prompt

SQL>select * from V$SORT_USAGE ;

Ensure you connect as sysdba ie.

$sqlplus user/password@TNSNAME as sysdba

Hope this helps.

Regards

GPK.

Message was edited by: Praveen

Message was edited by: Praveen

[Former Member]

Hi Praveen,

I found the report yesterday itself, for the option V$, it displays V$ views.

I have execute exec sql in abap program to retrieve tablespace information data from the database. I am trying to do that.

If any suggestions please let me know

Thanks,

Prabs