Results 1 to 4 of 4

Thread: oracle architecture

  1. 11-19-2007 #1
    pande.dhiraj
    pande.dhiraj is offline
    Junior Member
    Join Date
    Nov 2007
    Answers
    22
    Send a message via Yahoo to pande.dhiraj oracle architecture

    oracle architecture

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

    Reply With Quote Reply With Quote
  2. 11-19-2007 #2
    susarlasireesha
    susarlasireesha is offline
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: oracle architecture

    SQL > set autotrace on
    SQL > SELECT * FROM EMP;
    u can find execution plan

    Reply With Quote Reply With Quote
  3. 12-06-2007 #3
    susturge
    susturge is offline
    Junior Member
    Join Date
    Dec 2007
    Answers
    1

    Re: oracle architecture

    How database is organised in oracle?

    Reply With Quote Reply With Quote
  4. 12-06-2007 #4
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas oracle architecture

    Re: oracle architecture

    Quote Originally Posted by susturge View Post
    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact