| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Net8/SQLNet connections (checking for them at OS process level)
ps -fu oracle | grep -i oracle$ORACLE_SID | grep "(" would probably clinch
it.
This assumes oracle is the main user these processes are running under and the one the RDBMS software is installed under.
HTH Heidi
"Gogala,
Mladen" To: Multiple recipients of list ORACLE-L
<MGogala_at_oxhp <ORACLE-L_at_fatcity.com>
.com> cc:
Sent by: Subject: RE: Net8/SQLNet connections
root_at_fatcity.
com
10/16/00
09:15 PM
Please
respond to
ORACLE-L
That would give me all oracle processes plus some non-oracle processes.
-----Original Message-----
Sent: Monday, October 16, 2000 7:15 PM
To: Multiple recipients of list ORACLE-L
ps -ef |grep ora|wc -l
-----Original Message-----
Mladen
Sent: Monday, October 16, 2000 4:06 PM
To: Multiple recipients of list ORACLE-L
How about v$circuit?
-----Original Message-----
Sent: Monday, October 16, 2000 5:35 PM
To: Multiple recipients of list ORACLE-L
I would like to know how to verify the number of database connections there are currently.
I tried v$session and look at the output from lsnrctl services.
Does anyone else have any suggestions?
Regards.
larry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Taylor
INET: ltaylor_at_iq.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Linda Wang
INET: lwang_at_messagemedia.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Oct 17 2000 - 09:36:00 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |