Where are cursors created?

Discussion in 'Oracle' started by ankurk, Feb 28, 2008.

  1. ankurk

    ankurk New Member

    Joined:
    Aug 8, 2007
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    0
    Hi plz tell me where are the cursors created in RAM... i mean is it in shared pool or any where else..

    Secondly what are the steps invloved when we issue a query select invloving order by clause....


    Thanks :D
     
  2. venkatesanj@hcl.in

    venkatesanj@hcl.in New Member

    Joined:
    Oct 19, 2007
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    0
    Yes if we try to execute any program, the execution will happen in the RAM. Cursors will stay in the ram but in a seperate sql server application domain.

    Cursors are heavy weight objects too.

    Regards,
    Venkatesan Prabu. J
     
  3. venkatesanj@hcl.in

    venkatesanj@hcl.in New Member

    Joined:
    Oct 19, 2007
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    0
    If we issue select statement with order by clause,

    My database engine will search for the table in the database using the hierarchy

    Servername.Database name.Database owner name.Table name

    The second step is identifying the columns with filter criteria.

    The final step is ordering the data retrieved based on the order by clause.

    Regards,
    Venkatesan Prabu. J
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice