Performance issues for sql developer

1003986 Apr 18, 2013 5:45 PM

1. Does leaving DB connection open from a SQLNavigator has any impact on the DB resources and performance?

1. Re: Performance issues for sql developer

thatJeffSmith-Oracle Apr 18, 2013 7:24 PM (in response to 1003986)

That depends.

If you run a query or browse a table with parallel setup and leave a grid open - you could leave many processes sitting idle on the server waiting for you to fetch the records down.

But in general, 'no.'

Also, what do you mean by a 'SQLNavigator' - you mean SQL Developer, yes?
Like Show 0 Likes(0)

Actions
2. Re: Performance issues for sql developer

1003986 Apr 18, 2013 7:48 PM (in response to thatJeffSmith-Oracle)

Yes I am talking about SQL developer. But the query has already fetched data in the result and then If I just leave the Sql developer open with that query and result open. You know because I was just trying to see some specific set of data. Will it affect my database tables and other things?
Like Show 0 Likes(0)

Actions
3. Re: Performance issues for sql developer

thatJeffSmith-Oracle Apr 18, 2013 7:50 PM (in response to 1003986)

If you've fetched all rows, then should be no impact on database.

You can close the table editor/query results grids just to be sure if you don't know.
Like Show 0 Likes(0)

Actions
4. Re: Performance issues for sql developer

1003986 Apr 18, 2013 9:14 PM (in response to thatJeffSmith-Oracle)

Thanks
Like Show 0 Likes(0)

Actions