Home » SQL & PL/SQL » SQL & PL/SQL » how oracle executes sql statements
how oracle executes sql statements [message #438045] Wed, 06 January 2010 23:22 Go to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi friends
i want to know that when we hit a query then how does oracle execute it, means what happens in background and how the output came on screen(sql prompt).


Thanks
Dhinendra
Re: how oracle executes sql statements [message #438048 is a reply to message #438045] Wed, 06 January 2010 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 24908
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: how oracle executes sql statements [message #438050 is a reply to message #438045] Wed, 06 January 2010 23:56 Go to previous messageGo to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi blackswan i have gone through the link you gave. but i don't understand that what's wrong in my question that inspite of giving me a answer of my question you are sending that link.


Thanks
Dhinendra
Re: how oracle executes sql statements [message #438067 is a reply to message #438045] Thu, 07 January 2010 00:51 Go to previous messageGo to next message
pointers
Messages: 404
Registered: May 2008
Senior Member
search in google you get lot more answers....
basically there are several process involved in this...
when you access oracle instance you are actually accessing different process and memory structures..
search for "parsing", "client process", "server process", "listner" and "dispatchers"


Regards,
Pointers
Re: how oracle executes sql statements [message #438090 is a reply to message #438045] Thu, 07 January 2010 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 24 SQL, PL/SQL, and Java
Section Overview of SQL
Subsection SQL Processing

More than 95% of "How Oracle" questions are answered in this book.

Regards
Michel
Re: how oracle executes sql statements [message #438091 is a reply to message #438090] Thu, 07 January 2010 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also Chapter 1 Introduction to the Oracle Database
Section Oracle Database Architecture
Subsection Overview of the Oracle Instance
Paragraph Process Architecture
and follow the link to chapter 9.

Regards
Michel

[Updated on: Thu, 07 January 2010 02:12]

Report message to a moderator

Re: how oracle executes sql statements [message #438092 is a reply to message #438045] Thu, 07 January 2010 01:41 Go to previous messageGo to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi pointers thanks for reply,so is there any architecture or a flow from which i got to know what's happening in the background


Thanks
Dhinendra
Re: how oracle executes sql statements [message #438093 is a reply to message #438045] Thu, 07 January 2010 01:43 Go to previous message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi michel thanks for reply these links are really useful.



Thanks
Dhinendra
Previous Topic: loop
Next Topic: Need answer to this Query
Goto Forum:
  


Current Time: Tue Sep 27 14:32:01 CDT 2016

Total time taken to generate the page: 0.08982 seconds