searching for table & fields

[Former Member]

Hi guys,

i am searching for some database Table & fields in the transaction ST04.those fields r relating to structure ORASESSION. i m trying to find transparent table for all those fields below.

ORASESSION-SID

ORASESSION-SPID

ORASESSION-PROCESS

Regards

pabitra

[Former Member]

Hi

Thse are the possible tables

DBSTATTMSS Table sizes

MSQSNAP MS SQL Server: Database performance snapsh

MSSCNTDEAD Cumulated deadlock statistics data

MSSDBSTATT Table statistics for MS SQL Server

MSSDEADLCK Database Deadlock Information for MSSQL Se

Reward if useful

Narendra

[Former Member]

Hi

Thse are the possible tables

DBSTATTMSS Table sizes

MSQSNAP MS SQL Server: Database performance snapsh

MSSCNTDEAD Cumulated deadlock statistics data

MSSDBSTATT Table statistics for MS SQL Server

MSSDEADLCK Database Deadlock Information for MSSQL Se

Reward if useful

Narendra

[Former Member]

can anyone plz reply myquestion exactly ???

[Clemenss]

Hi pabitra,

use SE16 on table DD02L to get all tables with their respective characteristics (transparanet, cluster, pool, include structure, ...).

Then SE16 on table DD03L to get the fieldnames, data elemets, domains.

Was this your question?

Regards,

Clemens

[Former Member]

Hi,

Go to SE11 --> Input the fieldname --> Click on Where used list --> A pop up window will be displayed --> There select only database table check box rest everything should be deselected --> Press enter. There you can see the database where these fields are used.

Thanks,

Sriram Ponna.