Primer DEDICATED - SHARED konekcije

Primer DEDICATED - SHARED konekcije. 1

tnsnames.ora. 1

DEDICATED konekcija. 2

SHARED konekcija. 2

Dictionary informacija V$SESSION kolona SERVER.. 3

Listener SERVISI Handler informacija. 3

tnsnames.ora

XE =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = klijent2.saga-infotech.net)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = XE)

)

)

XEs =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = klijent2.saga-infotech.net)(PORT = 1521))

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = XEXDB)

)

)

DEDICATED konekcija

connect system/*******@XE

select sid, serial# from v$session where audsid= sys_context('userenv','sessionid');

SID SERIAL#

---------- ----------

37 569

SQL> SELECT SID,SERIAL#,STATUS,SERVER from v$session where SERIAL#=569;

SID SERIAL# STATUS SERVER

---------- ---------- -------- ---------

37 569 ACTIVE DEDICATED

SHARED konekcija

SQL> connect system/*******@XEs

Connected.

SQL> select sid, serial# from v$session where audsid= sys_context('userenv','sessionid');

SID SERIAL#

---------- ----------

37 571

SQL> SELECT SID,SERIAL#,STATUS,SERVER from v$session where SERIAL#=571;

SID SERIAL# STATUS SERVER

---------- ---------- -------- ---------

37 571 ACTIVE SHARED

Dictionary informacija V$SESSION kolona SERVER

SERVER VARCHAR2(9) Server type (DEDICATED| SHARED| PSEUDO| NONE)

Listener SERVISI Handler informacija

LSNRCTL> services

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Service "orcl" has 1 instance(s).

Instance "test", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:6171 refused:0 state:ready

LOCAL SERVER

Service "orcl_XPT" has 1 instance(s).

Instance "test", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:6171 refused:0 state:ready

LOCAL SERVER

Service "testXDB" has 1 instance(s).

Instance "test", status READY, has 1 handler(s) for this service...

Handler(s):

"D000" established:0 refused:0 current:0 max:1002 state:ready

DISPATCHER <machine: ORA10GFS, pid: 3148>

(ADDRESS=(PROTOCOL=tcp)(HOST=ora10gfs)(PORT=4203))

The command completed successfully

LSNRCTL>