Home » RDBMS Server » Server Administration » select * from emp
select * from emp [message #238777] Sat, 19 May 2007 23:32 Go to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

what happens internally when i give select * from emp
Re: select * from emp [message #238778 is a reply to message #238777] Sat, 19 May 2007 23:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>what happens internally when i give select * from emp
Oracle returns all rows in table EMP.
Re: select * from emp [message #238789 is a reply to message #238778] Sun, 20 May 2007 00:17 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

not that one, what is the process hgoing on internally in the SGA
Re: select * from emp [message #238790 is a reply to message #238777] Sun, 20 May 2007 00:20 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>what is the process hgoing on internally in the SGA
SMON
PMON
MMON
Re: select * from emp [message #238791 is a reply to message #238790] Sun, 20 May 2007 00:31 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

how it is linking to SGA in sga we have db_cache,sharedpool, log buffer first which is going to run logically when we issue this selet * from emp, this is my doubt
Re: select * from emp [message #238793 is a reply to message #238777] Sun, 20 May 2007 00:41 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>how it is linking to SGA in sga we have db_cache,sharedpool, log buffer first which is going to run logically when we issue this selet * from emp, this is my doubt
I realize that English is not your first/primary language.
I do not understand your question.
You're On Your Own.
Re: select * from emp [message #238794 is a reply to message #238791] Sun, 20 May 2007 00:41 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best for is to first read Concepts, Chapter 1 "Introduction to the Oracle Database".
Then you can come back here with more precise question on the subject.

Regards
Michel
Previous Topic: can't offline
Next Topic: View or read only from any objects
Goto Forum:
  


Current Time: Sat Dec 10 22:42:09 CST 2016

Total time taken to generate the page: 0.15679 seconds