Equivalent way to get running query for different process

Summary:

Equivalent way to get running query for different process

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

Is there a way to get the data from running SQL sessions or other queries ( like there is a provision to get it from v$session , v$process, v$sqlarea table in E-BUsiness Suite)?

Thanks

Parag

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):