| How does a SQL Statement work? [message #319195] |
Fri, 09 May 2008 05:29  |
kiran.satyan
Messages: 25
Registered: March 2008
Location: Bangalore
|
Junior Member |
|
|
Hi All,
SQL* Plus places each command into a buffer,when it finds a semi colon Sql* Plus executes that query.
In this explanation the "Buffer",specified is in client's Memory
or in SGA of Server(Assume we have a client connected to a Server)?
When we press enter after typing semicolon exactly what is happening?
If the execution plan is created in SGA,then what is transmitted from the client to the server.
Thanks & Regards
Kiran Sathyan
|
|
|
|
| Re: How does a SQL Statement work? [message #319218 is a reply to message #319195] |
Fri, 09 May 2008 06:24  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
SQL*Plus keeps a copy of the last query run internally - that's why you can re-run the query with a single key stroke.
The query is sent to the server, where it is parsed, an executpion plan is generated for it, the data is fetched, andthen the data is packed up into sets of rows based on the SQL*Plus ARRAYSIZE, and sent interactively to the client.
|
|
|
|
|
|
| Re: How does a SQL Statement work? [message #319236 is a reply to message #319195] |
Fri, 09 May 2008 07:50 |
kiran.satyan
Messages: 25
Registered: March 2008
Location: Bangalore
|
Junior Member |
|
|
Hi Michel,
In which format SQL*PLUS transmits the SQL/PLSQL command?
All the SQL/PLSQL commands are parsed in SGA only ,then in which format it is transmitted from client to server?
So this English sentences are converted to which format?
Its pretty low level,I'm bit curious to get it displayed!
Thanks & Regards
Kiran Sathyan
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
