Toad World® Forums

TOAD freezing when compiling package

This has now happened several times, the waiting cursor is displayed and TOAD does not respond any more.
It still seems to be consuming events, since Windows does not tell me that it is not responding.

I am pretty sure that this happened when I tried to compile a package.

I know that you cannot analyze the problem with this information. Debug is disabled.
Is there any additional information I can provide, or anything I can do with the still running TOAD?

Another instance of TOAD says that this is the current statement is:
SELECT created,
last_ddl_time,
object_id,
status
FROM sys.user_objects
WHERE object_name = :nm AND object_type = :t

Is the package compiling or is Toad hanging prior to sending the DDL over? Are you using Team Coding?

On 02/05/2016 04:14 AM, Peter Lang wrote:

TOAD freezing when compiling package

Thread created by Peter Lang
This has now happened several times, the waiting cursor is displayed and TOAD does not respond any more.

It still seems to be consuming events, since Windows does not tell me that it is not responding.

I am pretty sure that this happened when I tried to compile a package.

I know that you cannot analyze the problem with this information. Debug is disabled.

Is there any additional information I can provide, or anything I can do with the still running TOAD?

Another instance of TOAD says that this is the current statement is:

SELECT created,

   last_ddl_time,

   object_id,

   status

FROM sys.user_objects

WHERE object_name = :nm AND object_type = :t

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

If someone is running a method from that package, then the compile process will appear to hang until that method is done running. I run my editor window in threads so this doesn’t hang TOAD but wonder if running without threads might cause that to happen.

On Fri, Feb 5, 2016 at 11:46 AM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

RE: TOAD freezing when compiling package

Reply by Michael Staszewski
Is the package compiling or is Toad hanging prior to sending the DDL over? Are you using Team Coding?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

I don’t know if the package is already compiling or not, sorry.

There are no other sessions, so nobody is running a method from this package (I even dropped it from another session).

By the way, this instance of TOAD still prompts me for reconnect when returning from hibernate, so the main thread is still running fine.

The hang might be on the Oracle side. You could try compiling the package from SQL*Plus to find out.

I have already dropped that schema (for other reasons), so I am quite sure that Oracle is not involved (any more).

Hi Peter,

start a SQL*Plus session first, then start another session in Toad and compile the package that’s seemingly causing the hang.

When it hangs, switch back to the SQL*Plus session and execute the following:

select seq#,sid,serial#,program,machine,state,event,seconds_in_wait

from v$session

where program = ‘Toad.exe’;

That should show you all the Toad sessions (which is why we are using SQL*Plus rather than another Toad!) that are in the database, and will show you what event they are waiting on.

If the STATE is WAITING, then you are in a wait currently, for the EVENT noted and have been for SECONDS_IN_WAIT. Otherwise, the session is not waiting.

If you see your session waiting on something other than “SQL*Net message from client”, you might get some useful data from the following script:

col spid for a10

col event for a35

col program for a25

col blocked_sid for a40

col blocking_sid for a15

set lines 300 trimspool on

set pages 3000

– Who is blocking other blockers?

select lpad(’ ', (level-1) * 2) || sid as blocked_sid, nvl(to_char(blocking_session), ‘<— CULPRIT’) as blocking_sid

from v$session

where blocking_session is not null

or sid in (select blocking_session from v$session where blocking_session is not null)

start with blocking_session is null

connect by prior sid = blocking_session

order siblings by sid;

– And who else is blocked?

select p.spid, s.sid, s.blocking_session, s.program, s.event, s.p1, s.p2, s.p3, s.seconds_in_wait, state

from v$session s, v$process p

where p.addr = s.paddr

and s.state=‘WAITING’

and (s.blocking_session is not null

or s.sid in (select blocking_session from v$session where blocking_session is not null))

order by s.sid;

The first part outputs the blocking and blocked sessions. Any session that is blocking, but not itself blocked is flagged as “CULPRIT” :slight_smile: Look for your SID and see who is blocking it and why.

The second part gives a list of all the blocked and blocking sessions and what is going on with those.

Hopefully, you’ll be able to query V%PROCESS and V$SESSION in your SQL*Plus session.

HTH

Cheers,

Norm.

Why oh why oh why does pasting SQL statements give me blank lines between each line? Aaargh!

Thanks for the suggestions. Since killing the sessions of this TOAD did not help, I doubt that TOAD was waiting for a lock though.

This has just happened again.

I started another instance of TOAD and compiled it there without problems, so it is not locked.

v$session states that the session is WAITING for SQL*Net message from client.

According to the Session Browser, the current statment is:

SELECT created,
last_ddl_time,
object_id,
status
FROM sys.user_objects
WHERE object_name = :nm AND object_type = :t

Anyone else seen this problem?

This has just happened again. Current Statement is again

SELECT created,
last_ddl_time,
object_id,
status
FROM sys.user_objects
WHERE object_name = :nm AND object_type = :t

These are the last lines of ToadDebug.txt:

12:26:17:385 TBaseEditorForm.IsActiveEditorForm: Enter
12:26:17:385 TBaseEditorForm.GetActiveEditorForm: Enter
12:26:17:385 TBaseEditorForm.DoGetActiveForm: Enter
12:26:17:385 TBaseEditorForm.DoGetActiveForm: Exit
12:26:17:385 TBaseEditorForm.GetActiveEditorForm: Exit
12:26:17:385 TSyntaxEditorForm.IsActiveEditorForm: Exit

Session is waiting for

SQL*Net message from client

Anything I can provide next time this happens?

Disconnecting the session does not change anything, TOAD is still waiting.

It doesn’t seem like we’re waiting on the database.

Could it be that Toad is showing a dialog that somehow got behind Toad’s main window, so you can’t see it? Does ESC or ENTER do anything when it gets like this?

Just happened again. I don't think that there is a dialog, because I get a waiting cursor and ESC/Enter do nothing.

Does not seem to be completely dead, Windows does not tell me that it does not react any more.

This is what it looks like (controls turned white after returning from energy saving mode):

Update: After returning from energy saving mode, Windows now prompts me to close the program when clicking the red X.

The problem seems to occur before the source is compiled.
It just happened again and the object in the database was still invalid while I had already fixed my source file and was about to compile the fixed version.

This is what I usually do: Edit source, save my file, compile using F9.
I cannot reproduce it, but could it be that the new picklist dropdown somehow gets in the way? (I don’t see it though)

Ø could it be that the new picklist dropdown somehow gets in the way? (I don’t see it though)

That’s entirely possible if you have either the expected tokens or available identifiers checked or if you just entered a period. Abe reported a slowness in Code Insight that I can reproduce and am looking at. It may knock this out too. I’ll post back when it’s finished.

From: Peter Lang [mailto:bounce-PeterLang@toadworld.com]

Sent: Tuesday, March 08, 2016 9:47 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] TOAD freezing when compiling package

RE: TOAD freezing when compiling package

Reply by Peter Lang

The problem seems to occur before the source is compiled.

It just happened again and the object in the database was still invalid while I had already fixed my source file and was about to compile the fixed version.

This is what I usually do: Edit source, save my file, compile using F9.

I cannot reproduce it, but could it be that the new picklist dropdown somehow gets in the way? (I don’t see it though)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I’m experiencing the very same problem 2-3 times per day in the last months with version 12.8.0.49.

I’ve got used to Ctrl+A Ctrl+C before compilation.

I get waiting cursor and not responsive GUI even killing the original session with another TOAD window.

It never happened before last upgrade.

Disable the Copy Rich Text Format option on the Editor|Behavior page in Options. This is a costly operation and performance is significantly impacted by large selections and/or when connected to very large schemas like APPS schema in Oracle E-Business Suite when the options to highlight object names are enabled. That is likely the problem here.

Michael

On May 13, 2016, at 3:13 AM, alberto.persello bounce-albertopersello@toadworld.com wrote:

RE: TOAD freezing when compiling package

Reply by alberto.persello
I’m experiencing the very same problem 2-3 times per day in the last months with version 12.8.0.49.

I’ve get used to Ctrl+A Ctrl+C before compilation.

I get waiting cursor and not responsive GUI even killing the original session with another TOAD window.

It never happened before last upgrade.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I meant “I’ve got used to Ctrl+A Ctrl+C before compilation to avoid loosing my work”, so that in case TOAD hangs during compilation I can kill the program and paste my work somewhere else.

Sorry for my bad english.