"Trace" tab hangs the PL/SQL Developer

[ghou]

Hi:

I try to use "Trace" function in Test window. But whenever I click the "Trace" tab, my whole program hangs...

Why?

Server 81700 on Windows;
DBMA_TRACE package and two trace tables are installed.

Thanks,

 

[Marco Kalter]

How many records are in the trace tables?

------------------
Marco Kalter
Allround Automations

 

[ghou]

I already figured it out. As you implied that too many trace records in trace tables and my system tablespace is 100% full.

I truncated those trace tables and it's OK now.

Another question pop-up in my mind:

How does PL/SQL Developer take care of individual session for tracing and profiling?

If a group of developers working in the same schema traces or profiles their own procedures, can PL/SQL Developer return ONLY their own trace or profile records?

Thanks,

 

[Marco Kalter]

If these developers are using the same oracle user, they will see each others trace reports. The sys.plsql_trace_runs records are identified by the run_owner column.

------------------
Marco Kalter
Allround Automations