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.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...

  • SQL Error : Multiple ResultSets were returned by the query
    Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
  • MD5 Function in INFORMATICA
    MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...