Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Where are cursors created? (http://www.go4expert.com/forums/cursors-created-t9084/)

ankurk 28Feb2008 14:59

Where are cursors created?
 
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

venkatesanj@hcl.in 4Mar2008 07:56

Re: Where are cursors created?
 
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

venkatesanj@hcl.in 4Mar2008 07:59

Re: Where are cursors created?
 
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


All times are GMT +5.5. The time now is 01:24.