Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • check_copy_progress.sh Linux/Unix
  • Parallel DML Oracle
  • logminer and my_lbu Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Zip and unzip with tar Linux/Unix
  • export import with parameter file. Oracle
  • oracle 11g RAC on vmware Oracle
  • Check Oracle installed products using one command Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • age_alert.ksh aging out alert.log Linux/Unix
  • lck.sql Oracle
  • UTL_FILE test program Oracle
  • reset Sequence Oracle
  • refre.sql Oracle

To Find Orphan OS processes.

Posted on 19-Feb-2007 By Admin No Comments on To Find Orphan OS processes.

To Find Orphan OS processes.

When a process run from command line its parent process id will be 1. Consider following example:

In current session, we are executing SQLPLUS. whose process id = 22833 and parent is 22822.

process 22822 is ksh. So this is not orphan process. if you find any process with parent id 1, confirm with users for how this program is executed. When a process or program is running directly without Shell, it will have 1 as parent process id and orphan processes also have parent process id as 1.

SQL> !ps -ef | grep -i sqlplus

oracle 6833 22833 0 13:56:39 pts/1 0:00 grep -i sqlplus

oracle 22833 22822 0 12:04:27 pts/1 0:00 sqlplus / as sysdba

SQL> !ps -ef | grep 22822

oracle 22822 22820 0 12:04:14 pts/1 0:00 -ksh

oracle 6934 22833 0 13:57:02 pts/1 0:00 grep 22822

oracle 22833 22822 0 12:04:27 pts/1 0:00 sqlplus / as sysdba

SQL>

Linux/Unix, shell

Post navigation

Previous Post: Another Tuning Article for subheap of shared pool
Next Post: chk_space_SID.ksh

Related Posts

  • create a folder in multiple places Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • set_env_dba Linux/Unix
  • send attachment from unix-shell script Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • normal maintenance for exp-imp and renaming table Oracle
  • reset Sequence Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • FGA Part-I Oracle
  • perf_today.sql Oracle
  • How to know current SID Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Drop database in Oracle 10g Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme