Toad World® Forums

15.0.23.720 - Picklist dropdown freeze

My dropdown froze again so I decided to look at the ASH of the affected session.

This was my code when I triggered the dropdown:

SELECT * FROM user_tab_cols WHERE column_|

The session was executing the following query for 30 seconds:

Select 'REF_INTEGRITY' as type, ... 

After that time (guess I tried to cancel earlier though) the session did the following until I killed it:

"EVENT":"SQL*Net break/reset to client",

Not sure if there's anything you can do with this info but I would really appreciate if TOAD could stop freezing like that :slight_smile:

Full row from gv$active_session_history:

{
  "recordset": [
  {
    "INST_ID":1,
    "SAMPLE_ID":38726638,
    "SAMPLE_TIME":"2020-11-16T11:51:37.967000000+00:00",
    "IS_AWR_SAMPLE":"N",
    "SESSION_ID":249,
    "SESSION_SERIAL#":35330,
    "SESSION_TYPE":"FOREGROUND",
    "FLAGS":16,
    "USER_ID":300,
    "SQL_ID":null,
    "IS_SQLID_CURRENT":"Y",
    "SQL_CHILD_NUMBER":-1,
    "SQL_OPCODE":0,
    "FORCE_MATCHING_SIGNATURE":0,
    "TOP_LEVEL_SQL_ID":null,
    "TOP_LEVEL_SQL_OPCODE":0,
    "SQL_OPNAME":null,
    "SQL_ADAPTIVE_PLAN_RESOLVED":0,
    "SQL_FULL_PLAN_HASH_VALUE":0,
    "SQL_PLAN_HASH_VALUE":0,
    "SQL_PLAN_LINE_ID":null,
    "SQL_PLAN_OPERATION":null,
    "SQL_PLAN_OPTIONS":null,
    "SQL_EXEC_ID":null,
    "SQL_EXEC_START":null,
    "PLSQL_ENTRY_OBJECT_ID":null,
    "PLSQL_ENTRY_SUBPROGRAM_ID":null,
    "PLSQL_OBJECT_ID":null,
    "PLSQL_SUBPROGRAM_ID":null,
    "QC_INSTANCE_ID":null,
    "QC_SESSION_ID":null,
    "QC_SESSION_SERIAL#":null,
    "PX_FLAGS":null,
    "EVENT":"SQL*Net break/reset to client",
    "EVENT_ID":1963888671,
    "EVENT#":398,
    "SEQ#":34,
    "P1TEXT":"driver id",
    "P1":1413697536,
    "P2TEXT":"break?",
    "P2":0,
    "P3TEXT":null,
    "P3":0,
    "WAIT_CLASS":"Application",
    "WAIT_CLASS_ID":4217450380,
    "WAIT_TIME":0,
    "SESSION_STATE":"WAITING",
    "TIME_WAITED":0,
    "BLOCKING_SESSION_STATUS":"NO HOLDER",
    "BLOCKING_SESSION":null,
    "BLOCKING_SESSION_SERIAL#":null,
    "BLOCKING_INST_ID":null,
    "BLOCKING_HANGCHAIN_INFO":null,
    "CURRENT_OBJ#":185183,
    "CURRENT_FILE#":2,
    "CURRENT_BLOCK#":66257,
    "CURRENT_ROW#":0,
    "TOP_LEVEL_CALL#":94,
    "TOP_LEVEL_CALL_NAME":"V8 Bundled Exec",
    "CONSUMER_GROUP_ID":17345,
    "XID":null,
    "REMOTE_INSTANCE#":null,
    "TIME_MODEL":0,
    "IN_CONNECTION_MGMT":"N",
    "IN_PARSE":"N",
    "IN_HARD_PARSE":"N",
    "IN_SQL_EXECUTION":"N",
    "IN_PLSQL_EXECUTION":"N",
    "IN_PLSQL_RPC":"N",
    "IN_PLSQL_COMPILATION":"N",
    "IN_JAVA_EXECUTION":"N",
    "IN_BIND":"N",
    "IN_CURSOR_CLOSE":"N",
    "IN_SEQUENCE_LOAD":"N",
    "IN_INMEMORY_QUERY":"N",
    "IN_INMEMORY_POPULATE":"N",
    "IN_INMEMORY_PREPOPULATE":"N",
    "IN_INMEMORY_REPOPULATE":"N",
    "IN_INMEMORY_TREPOPULATE":"N",
    "CAPTURE_OVERHEAD":"N",
    "REPLAY_OVERHEAD":"N",
    "IS_CAPTURED":"N",
    "IS_REPLAYED":"N",
    "SERVICE_HASH":2429356423,
    "PROGRAM":"Toad.exe",
    "MODULE":"Toad.exe",
    "ACTION":null,
    "CLIENT_ID":null,
    "MACHINE":"X",
    "PORT":60319,
    "ECID":null,
    "DBREPLAY_FILE_ID":0,
    "DBREPLAY_CALL_COUNTER":0,
    "TM_DELTA_TIME":869020,
    "TM_DELTA_CPU_TIME":869005,
    "TM_DELTA_DB_TIME":869020,
    "DELTA_TIME":1000405,
    "DELTA_READ_IO_REQUESTS":0,
    "DELTA_WRITE_IO_REQUESTS":0,
    "DELTA_READ_IO_BYTES":0,
    "DELTA_WRITE_IO_BYTES":0,
    "DELTA_INTERCONNECT_IO_BYTES":0,
    "DELTA_READ_MEM_BYTES":245760,
    "PGA_ALLOCATED":4182016,
    "TEMP_SPACE_ALLOCATED":0,
    "CON_DBID":301373459,
    "CON_ID":0,
    "DBOP_NAME":null,
    "DBOP_EXEC_ID":0
  }
  ]
}

Thanks for the info.

Michael and I have an idea that may help with the freezes. It may be a few weeks before we get a chance to try it out though.

There's also a hang caused by the "Join Suggestions" in Code Insight if the timing is right. An underlying thread encounters deadlock. If you experience this often in the meantime you can disable "Join Suggestions" in Options | Editor |Code Assist in the Code Insight - Include list.

Thanks - let me know when I can re-enable this : )