Thursday, 15 May 2014

Oracle: Server & Client communication

The transaction proceeds as follows:


  • The client sends a request for data.
  • Oracle Net Services packages the request and sends it to the TNS.
  • TNS routes the packaged request to the server.
  • Oracle Net Services on the server side unpackages the request and sends it to Oracle Database 10g.
  • Oracle Database 10g processes the request and sends the requested data to Oracle Net Services.
  • Oracle Net Services packages the data and sends it to TNS.
  • TNS routes the data to the client.
  • Oracle Net Services on the client side unpackages the data and sends it to the application.

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...