Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Getting started with notebook Python/PySpark
  • Find sort details from Db find_sort.sql Oracle
  • oracle 10g on linux Linux/Unix
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • Remove duplicate rows from table Oracle
  • Monitor Long Running Job Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • How to know current SID Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • ORA-01220 Oracle
  • Pending Transaction Neighbors Script Oracle
  • chk_space_SID.ksh Linux/Unix
  • move_arch_files.ksh /* Good One */ Linux/Unix

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

  • move_arch_files.ksh Linux/Unix
  • Jai Shree Ram Linux/Unix
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • on IBM-AIX for display Linux/Unix
  • note id 373303.1 Linux/Unix
  • tuning commmand for cpu, ip and memory stats 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
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • get_vmstat.ksh for Solaris Oracle
  • Getting started with notebook Python/PySpark
  • ORA-3136 Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme