Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

searching for table & fields

former_member190312
Active Participant
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

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

0 Kudos

can anyone plz reply myquestion exactly ???

0 Kudos

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
0 Kudos

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.