Oracle8i Enterprise Edition Release 8.1.7.0.ApexSQL Doc creates database documentation in a variety of formats. That means process=415 will give me sessions=461.īut i only get at most 150 users. I set it as processes=415 and it was 315 before.īase from the ora docs the number of sessions is computed as There was no user connected and this pseudo is still there. I'm little confused on this.ĭatabase select username,program from v$process I have seen this PSEUDO many times but do not understand what it is? Its there even when there is no connection or, say a just started database. bequeathing a connection is part of the bequeath protocol.įrom your example select username, program from v$process * bequeathing a connection - happens over the net with the listener or in a single server without the listener. Your client bequeaths the connection directly to the forked dedicated server. We BEQUEATH a connection using either the beq protocol or from a listener.
technically - the "bequeath PROTOCOL" is used only on single servers. Playing with fine grained semantics here but.
I guess there is the confusion between the exactness of the "bequeath protocol" and "bequeathing a connection". It is just that the second link doesn't say "oh, and by the way, this isn't the only way this happens" The listener initiates the session by spawing a dedicated server. If the client and server do not exist on the same machine, a client connection can be bequeated from the listener to the dedicated server instaled. It should continue on to fill out the entire story (and it does in fact): When the call is over, that process is released back to the pool of processes. A process does not have to be dedicated to a specific connection or session however, for example when using shared server (MTS), your SESSION will grab a process from a pool of processes in order to execute a statement. Sometimes there is a one to many from connection to sessions (eg: like autotrace, one connection, two sessions, one process). Sometimes there is a one to one relationship between CONNECTION->SESSION->PROCESS (eg: a normal dedicated server connection). A process will be used by a session to execute statements. Zero, one or more sessions may be established over a given connection to the database as show above with sqlplus. A connection might be one of many types - most popular begin DEDICATED server and SHARED server. You can see all of the backgrounds and my dedicated set autotrace on statistics Īutotrace for statistics uses ANOTHER session so it can query up the stats for your CURRENT session without impacting the STATS for that select username from v$session where username is not null Ĥ99 bytes received via SQL*Net from clientĢ rows select username, program from v$process ġ4 rows try to put it into a single, simple paragraph:Ī connection is a physical circuit between you and the database. One session, select username, program from v$process Technically - I have a connection, I don't have a sessionįurther, autotrace in sqlplus can be used to show that you can haveĬ) to service two select username from v$session where username is not null Still have my process, but no session, the message is a little "misleading". With the Partitioning, OLAP and Oracle Data Mining options We can see that with sqlplus, consider (single user system here, its all about tkyte]$ ps -auxww | grep tkyte]$ sqlplus /nolog You can be connected to a database yet have 0 or 1 or MORE sessions going on that connection. And user processes like dedicated servers or shared server (multi-threaded server - aka MTS - configuration)Ī connection is a "physical circuit", a pathway to a database. There are many types of processes in Oracle - background processes like SMON, PMON, RECO, ARCH, CKPT, EMNn, DBWR, etc. On unix, you can see a process with "ps" for example. A process is a physical process or thread.