RE: max proccesses connected to database

  • From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 5 Aug 2004 11:25:35 -0500

Here's a ksh script and sql we use to list the resource activity

        Larry

$DBS where we keep our source
$OR  Oracle Reports
ENV.$DB all environment variables if we ever have to make a change we only
update one script
DB a table that only has a few columns name(Database name), server(server
name) etc.
        We don't use V$DATABASE because too many would show PROD instead of
BOST, NWYK,KNOX,CHGO,DALL,ATLA,JACK,HOUS,SFRN,PHNX etc.

#!/bin/ksh
#  Written by Lawrence Wolfson 07/25/02
#  DB VRL LIST FOR High Water Marks
#
HWMs ()
 (
  . $DBS/ENV.$DB
  print "
  @$DBS/VRL
  EXIT"   |\
  sqlplus "/ as sysdba"
  mv $OR/VRL.$ORACLE_SID $OR/VRL.$ORACLE_SID.$DT3
 )
 
DT3=`date +%y%j%H%M`
DBS={your source}
cd $DBS
#for DB in `cut -f 1 -d':' /var/opt/oracle/oratab` #multiple SIDs
#  do
#    HWMs $DB
DB=PROD
     HWMs $DB
#  done


--Written by Lawrence Wolfson 05/29/01
--V$RESOURCE_LIMIT
SET ECHO     ON
SET LINESIZE  256
SET PAGESIZE  1000
COL RESOURCES FOR A24
COL CURR      FOR 999,999
COL MAX       FOR 999,999
 
SPOOL $OR/VRL.$ORACLE_SID
SELECT name
      ,RESOURCE_NAME       RESOURCES
      ,CURRENT_UTILIZATION CURR
      ,MAX_UTILIZATION     MAX
      ,INITIAL_ALLOCATION  INITIALLY
      ,LIMIT_VALUE
      ,to_char(SYSDATE,'mm/dd/yy hh24:mi:ss') timestamp
  FROM V$RESOURCE_LIMIT
      ,DB
;
SPOOL OFF

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of J.Velikanovs@xxxxxxxx
Sent: Thursday, August 05, 2004 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: max proccesses connected to database


I am not sure you are asking for, may be this can be usefull for you
SYS:XXX> select * from V$LICENSE;

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER 
USERS_MAX
------------ ---------------- ---------------- ------------------ 
----------
           0                0                5                 14 0

SYS:XXX> 

Alert log, as well
===========
Shutting down instance (abort)
License high water mark = 502
Instance terminated by USER, pid = 19050
Tue Jun  1 13:25:09 2004
Starting ORACLE instance (normal)
===========


Jurijs
+371 9268222 (+2 GMT)
============================================
Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html






"Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
05.08.2004 18:55
Please respond to oracle-l
 
        To:     <oracle-l@xxxxxxxxxxxxx>
        cc: 
        Subject:        max proccesses connected to database


Sorry I don't remember and I could'nt find in documentation and I need
urgent.

how can I get the statistics about the maximum processes conected to the
database

Thanks
 
Juan Carlos Reyes Pacheco
OCP
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: