Background Process In Database

In today’s article, I will be explaining how we can learn about background processes running in the database.

Background processes are kept in the v$process view.

The content of the v$process view can be learned this way.

SQL> SET LINESIZE 9000;
SQL> SELECT ADDR, PID, PNAME, USERNAME, SERIAL#, TERMINAL, PROGRAM FROM V$PROCESS WHERE PNAME IS NOT NULL ORDER BY PNAME;

1 2	SQL> SET LINESIZE 9000; SQL> SELECT ADDR, PID, PNAME, USERNAME, SERIAL#, TERMINAL, PROGRAM FROM V$PROCESS WHERE PNAME IS NOT NULL ORDER BY PNAME;

We can learn the operating system prompt with the following code;

-bash-3.2$ ps -ef | grep ora_

1	-bash-3.2$ ps -ef \| grep ora_

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux