Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DBMS_UTILITY PACKAGE Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Another export with Query Oracle
  • ORA-01220 Oracle
  • Very clear article about oracle dataguard Oracle
  • Add new columns in dataframe Python/PySpark
  • adding new line after specific pattern using sed Linux/Unix
  • Debugging Shell FIles Linux/Unix
  • Wait Based Tuning Step by step with SQL statement Oracle
  • Implementing Listener Security Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • purge_trc.sh Linux/Unix
  • Good Oracle Architecture In Short and point to point Oracle
  • Explain Plan Output 2 Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle

Session_info.ksh

Posted on 24-Apr-2007 By Admin No Comments on Session_info.ksh

/********* session_info.ksh ****************/

#!/bin/ksh

. /home/oracle/oraprocs/WEBP18F.env

USR_ID=vivek

USR_PASS=viv1ek

database=WEBP18F

a=`ps -ef|grep “session_info.ksh”|grep -v grep|wc -l`

if [ $a -gt 4 ]

then

echo “Exiting because of more than 1 process is running `date`”>>/db3/oradata/log/session_info.log

exit

fi

echo “—–Begin —– Date `date`——————————–” >> /db3/oradata/log/session_info.log

$ORACLE_HOME/bin/sqlplus -s <>/db3/oradata/log/session_info.log

$USR_ID/$USR_PASS@$database

set serverout on

set feedback off

SET PAGES 0

start /home/oracle/scripts/sess_server1.sql

EOF

/home/oracle/scripts/find_proc_mem_mts.sh >> /db3/oradata/log/session_info.log

free -t >>/db3/oradata/log/session_info.log

echo “—–End —– Date `date`——————————–” >> /db3/oradata/log/session_info.log

exit

/************ sess_server1.sql ***************/

column osuser format a10

column username format a30

column machine format a30

column program format a40

column sid format 99999999

column serial# format 99999999

column TOT format 999999 heading “Total Sessions”

break on report

compute sum of TOT on report

set lines 141

set pages 500

select machine, osuser, username, count(1) “TOT” from v$session

group by machine, osuser, username;

select username, status, count(1) “TOT” from v$session

group by username,status;

prompt ‘APPSERVER INACTIVE CONNECTIONS’

select username, status, count(1) “TOT” from v$session

where username like ‘APPSERVER%’ and status=’INACTIVE’

group by username,status

order by status, username;

prompt ‘APPSERVER ACTIVE CONNECTIONS’

select username, status, count(1) “TOT” from v$session

where username like ‘APPSERVER%’ and status=’ACTIVE’

group by username,status

order by status, username;

prompt ‘Total Server Processes’

!ps -ef | grep -v grep | grep WEBP18F |wc -l

Linux/Unix, shell

Post navigation

Previous Post: Facts about SCN and Rollback Segment
Next Post: TOP-N Sql to find Nth max or Top N rows

Related Posts

  • How to sort list of files on basis of their sizes. Linux/Unix
  • send email from unix mailx with attachment. Linux/Unix
  • Logic to chech # of parameters command line parameters Linux/Unix
  • Some useful Unix Commands Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • replace alphabets using sed Linux/Unix

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • logminer and my_lbu Oracle
  • Getting started with notebook Python/PySpark
  • Korn Shell Arithmatic Linux/Unix
  • arch_configUOCIOTTO.ora Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme