I had a text field with autocomplete, there is a sql behind this text field which returns 50,000 records. This sql fires everything time when the page is loaded, which is very frequent. I have a connect by prior tree query as well, along with 4 other bind varialbe reports. I received some blocking session warning message on database, which potentially can be serious warning. I suspect the text field with autocomplete is causing the blocking session. Is 50,000 records a lot to a search text fild or Popup LOV? did anyone have any experience with blocking sessions?