OS_THREADS

Provides status information about all threads on the current node, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

**Table 1** OS_THREADS columns
Name	Type	Description
node_name	text	Name of the current node.
pid	bigint	ID of the thread running under the current node process.
lwpid	integer	Lightweight thread ID corresponding to pid.
thread_name	text	Name of the thread corresponding to pid.
creation_time	timestamp with time zone	Creation time of the thread corresponding to pid.
dbid	oid	ID of the database to which a thread belongs.