From Client to SQL

From  Client to SQL

TCP Connection

Client  ----------------------- Application Server --------------- DB Server

http                         -----|---- p

rmi                          -----|---- p

         process ------  iiop  --------Process/Thread -----|---- p

tuxedo                       -----|---- p

cics |

|

SQL （dedicated server）

dedicated server

shared server

嗅探器？???????

LoaderRunner:    Client   和  Application Server   之间

Transaction:   无头有尾

commit

rollback

savepoint

rollback savepoint

set transaction

v$transaction   查看ADDR

v$session

v$sql

v$process

client: sqlplus 11g

server: 9i

OS command:netstat

Oracle Dynamic Views:

v$transaction

v$process

v$session

v$sql

v$transaction 

ses_addr

v$sesseion

saddr

paddr

sql_addr                                 

prev_sql_addr                           v$sql     sql_text,address

v$process

addr

spid

netstat