11-07-2007
These are shadow processes of local connections (from the same host). It doesn't come to my mind right now when such connection
could become init's child (while all others, LOCAL=NO, are),
but I would check from inside oracle: v$session/v$process/v$sqlarea what these session are doing and why they are in such state
(in case this is not a normal behavior).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Discussion started by: ashokjaysiv
4 Replies
2. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
3. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
4. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
5. Programming
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies
6. Shell Programming and Scripting
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies
7. Shell Programming and Scripting
Hi,
I am new to perl.How to query oracle database with perl???
Thanks (1 Reply)
Discussion started by: tdev457
1 Replies
8. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
9. Programming
Dear community,
I have to make a query from a database and apply the following filter:
select filed1,field2,field3
from database
where (field1 contains only alphanumeric chars and NOT only numbers)
Let me explain better what I Need:
21test ==> OK
test ==> OK
test21 ==> OK
te21st ==>... (6 Replies)
Discussion started by: Lord Spectre
6 Replies
10. Programming
Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
FIELD1 FIELD2 FIELD3
========= ============== ... (3 Replies)
Discussion started by: Lord Spectre
3 Replies
LEARN ABOUT MINIX
ssl_set_session
SSL_set_session(3SSL) OpenSSL SSL_set_session(3SSL)
NAME
SSL_set_session - set a TLS/SSL session to be used during TLS/SSL connect
SYNOPSIS
#include <openssl/ssl.h>
int SSL_set_session(SSL *ssl, SSL_SESSION *session);
DESCRIPTION
SSL_set_session() sets session to be used when the TLS/SSL connection is to be established. SSL_set_session() is only useful for TLS/SSL
clients. When the session is set, the reference count of session is incremented by 1. If the session is not reused, the reference count is
decremented again during SSL_connect(). Whether the session was reused can be queried with the SSL_session_reused(3) call.
If there is already a session set inside ssl (because it was set with SSL_set_session() before or because the same ssl was already used for
a connection), SSL_SESSION_free() will be called for that session.
NOTES
SSL_SESSION objects keep internal link information about the session cache list, when being inserted into one SSL_CTX object's session
cache. One SSL_SESSION object, regardless of its reference count, must therefore only be used with one SSL_CTX object (and the SSL objects
created from this SSL_CTX object).
RETURN VALUES
The following return values can occur:
0 The operation failed; check the error stack to find out the reason.
1 The operation succeeded.
SEE ALSO
ssl(3), SSL_SESSION_free(3), SSL_get_session(3), SSL_session_reused(3), SSL_CTX_set_session_cache_mode(3)
1.0.1e 2013-02-11 SSL_set_session(3SSL)