V $ dynamic performance view in Oracle

V $ database: database information, such as the database name and creation time.

V $ instance information, such as instance name and start time.

V $ parameter information, select * from v $ parameter where name like '% name' ----> show parameter name (executed in sqlplus)

V $ process: Information about processes running, such as PID, SPID, and process name, such as SMON and PMON. in windows, a process similar to Oracle is displayed. the name of a thread such as EXE (PMON.

V $ mystat the session SID and other information .. after knowing the SID, you can query the session-related information.

V $ session information related to sessions connected to the database, such as the machine name, client program name, PID (UNIX), etc.

If you use select distinct (sid) from v $ mystat; to obtain the SID,

You can obtain information about this session, such as the address of the background process serving this session (PADDR) select * from v $ session where sid = 157

After obtaining the PADDR, you can get the background process information: select * from v $ process where addr = '3424e3bc'