SQL Developer - Selects

Hi together,

some questions about SQL Developer and how it is working with the database...

When I open a datatable (tab data), SQLD does a coresponding select on the table. Looking at enterprise manager i see that the select consists out of ORA_ROWSCN and all the columns from the table. In a table with million records i get an instant result cause only 55 rows in my case are fetched. When i take the same select and execute it, it would take much longer cause i get the whole table. How is it possible to limit the number of records in the result with such a select?
Is the result from such a select from the same point of time? When i change sorting SQLD makes a new select statement.

Another question little bit offtopic is it possible to see a live trace of a oracle session for example like tail, all the statements from one session live?

Thanks for your time.. :)

Markus Received on Wed Oct 31 2007 - 04:20:29 CDT