Connection status wrong

Toad for Oracle
21

Spool SQL window when I click on the disconnected session:

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:04.398
Select t.table_name, user as owner, t.cluster_name,
       t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows,
       t.initial_extent, t.degree, t.logging, t.cache, t.buffer_pool
       , t.monitoring, t.temporary, t.table_type, t.table_type_owner, t.nested
       , t.Compression, t.dropped
       , t.compress_for, t.flash_cache, t.cell_flash_cache, t.segment_created
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') as External
from sys.user_all_tables t
where 1=1
order by table_name;

----------------------------------
-- Timestamp: 16:10:04.424
Disconnect: PLAN@DEV-I

----------------------------------
-- Timestamp: 16:10:05.239
Connect: PLAN@DEV-I

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.056
BEGIN
  SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, :IN_ID);
END;
:IN_MDL(VARCHAR[17],IN)='TOAD 15.0.97.1178' 
:IN_ID(VARCHAR[28],IN)='62920368,690830784,657233440'

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.131
select SYS_CONTEXT('USERENV','SID') sid, sysdate from dual;

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.202
BEGIN   IF DBMS_UTILITY.IS_CLUSTER_DATABASE THEN     :RetVal := 1;   ELSE     :RetVal := 0;   END IF; END;
:RetVal(INTEGER,OUT)=1

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.275
BEGIN   :RetVal := DBMS_UTILITY.CURRENT_INSTANCE; END;
:RetVal(INTEGER,OUT)=1

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.348
select sys_context('USERENV','INSTANCE_NAME') as INSTANCE_NAME,
       sys_context('USERENV','SERVER_HOST') as HOST_NAME
from dual;

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.420
select p1.inst_id, p1.value inst_name, p2.value undo_tablespace
from   gv$parameter p1, gv$parameter p2
where  p1.inst_id = p2.inst_id
and    p1.name = 'instance_name'
and    p2.name = 'undo_tablespace'
order by 1;

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.543
Select t.table_name, user as owner, t.cluster_name,
       t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows,
       t.initial_extent, t.degree, t.logging, t.cache, t.buffer_pool
       , t.monitoring, t.temporary, t.table_type, t.table_type_owner, t.nested
       , t.Compression, t.dropped
       , t.compress_for, t.flash_cache, t.cell_flash_cache, t.segment_created
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') as External
from sys.user_all_tables t
where 1=1
order by table_name;
----------------------------------
-- ORA-03135: connection lost contact
Process ID: 13286
Session ID: 92 Serial number: 15926
-- Reconnected 
----------------------------------

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:06.965
Select user, table_name from sys.user_snapshots
order by table_name;

----------------------------------
-- Session: PLAN@DEV-I
-- Timestamp: 16:10:07.046
Select user, object_name, created, last_ddl_time, object_id from sys.user_objects
Where object_type = 'TABLE'
order by object_name;

After auto reconnect:
image

22

Thanks. I wanted to make sure the error that you had was in our "lost connection error code list". It is.

I'll try again tomorrow. Maybe having multiple connections/windows open is a requirement. I only had one.

Good night.

23

Might require multiple windows and sessions. I currently have 14 application windows open and Toad has 8 session tabs. I'm also using 3 monitors one of which is 4K.

24

I can reproduce it with multiple connections.

1 Like