database crashing due to SQL Developer???
526272Sep 28 2006 — edited Sep 28 2006Hi,
I have SQL Developer version 1.0.0.14.67. I have a doubt which I would appreciate if someone could clarify it.
In SQL Developer, After I connect to a database and click on one of the tables, it shows me the columns of that table on the right hand side. When I click on data, it shows me the data. Now, does it fetch all the records instantly from the table or does it fetch few at a time as I move the cursor. For eg. if my table A has hundred thousand records and I click on "data" will it fetch all the hundred thousand records or does it fetch a few records initially.
If it fetches all the records, then is there a way for me to put a condition in SQL Developer sp that when I click on any table, it should show me data for the first 100 records or so.
This is because the database has been crashing constantly since yesterday and it seems its due to my clicking on the table and the table fetching all the records. Can this be true??? I'm not sure cause I'm the only one who uses SQL Developer and rest of them use Toad. So they r not too sure too but say that must be the cause. I need to find out if its true??
Thanks in advance.