Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

oracle architecture

This is a discussion on oracle architecture within the Oracle forums, part of the Databases category; how the sql query will process via sga what is the execution path of simple select * from table_name?...

Geeks Talk > Databases > Oracle oracle architecture

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   11-19-2007

pande.dhiraj Junior Member   Join Date: Nov 2007 Location: india Posts: 26 Thanks: 4 Thanked 3 Times in 3 Posts

oracle architecture how the sql query will process via sga what is the execution path of simple select * from table_name?

Sponsored Links

#2 (permalink)   11-19-2007

susarlasireesha Expert Member   Join Date: Apr 2007 Location: Bangalore Posts: 443 Thanks: 20 Thanked 54 Times in 54 Posts

Re: oracle architecture SQL > set autotrace on SQL > SELECT * FROM EMP; u can find execution plan

#3 (permalink)   12-06-2007

susturge Junior Member   Join Date: Dec 2007 Location: pune Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: oracle architecture How database is organised in oracle?

#4 (permalink)   12-06-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,426 Thanks: 8 Thanked 125 Times in 112 Posts

Re: oracle architecture Quote: Originally Posted by susturge How database is organised in oracle? You need to go through some good books for the same ,can also find out all those by investing some time in web searching.

Geeks Talk > Databases > Oracle

« Tips of the Day | Dynamically set Visibility of fields »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MVC Architecture in STRUTS	kalaranjani	Java	6	09-25-2008 05:01 AM
SOA Architecture	Lokesh M	Geeks Lounge	0	09-26-2007 06:55 AM
Tier Architecture	Sampath_Java	Java	1	08-22-2007 03:14 AM
About the architecture of database.	loosecontrol	Oracle	3	06-14-2007 05:41 AM
Architecture of Cognos8	vaibhav_j2000	Data Warehousing	0	03-01-2007 09:49 PM

All times are GMT -4. The time now is 01:41 PM.