SQL Developer


No data in trace file view panels


Hello,
I was not aware of the open -> .trc file feature until I saw it posted earlier in this forum.
Do you know if the issue is being investigated?
The running dialog appears for a few minutes with lots of cpu activity and then ... nothing.
I am using Version 2.1.0.63 , Build MAIN-63.73 . (Windows XP, service pack 2)
regards,
Ken 
I am using 2.1.0.63.73 and I am able to open and view Tkprof file in the trace view panel.
Thanks,
Ganesh 
I got this yesterday. The situation was I was tracing an APEX application by using
dbms_monitor.serv_mod_act_trace_enable (service_name=>'***',module_name=>'APEX:APPLICATION 301',binds=>TRUE);
The resulting .trc file couldn't be 'visualized' in SQL Developer.
I also tried a "TKPROF record=file" which came up empty.
Investigating the latter, I found all the statements/cursors in the file had a "dep=1" or higher. That is, they were all 'recursive' and the top level statement hadn't been captured (presumably because it was executed prior to the module name being set). The "record" option ignores recursive statements.
Anyway, I edited the file and replacing all the "dep=1" with "dep=0" (and "dep=2" with "dep=1"). I retried that file in SQL Developer and then I got some output in the window.
This was using SQL Developer 3.1 EA1, but I'd guess it applies to earlier versions too.

Related Links

30EA3->2.*: Weird performance issues for editing objects
SQLDEV 2.1.0.63 gives ORA-904 on UT_TEST_RESULTS when running unit test
SQL Developer 2.1 EA2 Compiler ORA-00911: invalid character error
About SQL Developer tables
EA2 RefCursor and Stored procedure
Can't see my connection details
EA2 Autocompletion stop working for loades sql-Scripts
Invalid column index get valid column index
EA2 "collapse procedure declaration / bodies" doesn't work
2.1 EA2 does not display query results, query works fine in sqlplus
sqldeveloper-2.1.0.62.61 export data to xls, csv slow after > 10.000 rows
Sql Developer 2.1 - "sql server" can't see tables
EA2 "set define off" is not working
EA2 - Table Data tab not refreshed after ALTER TABLE
Access reports through browser
new for sql developer need ur suggestion

Categories

ORACLE DEV
Server & Storage Systems
Globalization Support
Multimedia (formerly i...
Data Warehousing
TopLink/JPA
Oracle Application Exp...
Projects
OLAP
Java - JDBC Archive
Customer Advisory Boar...
Enterprise Manager
Email Server
Email SDK
Berkeley DB Family
SOA Suite (Korean)
JSP (Korean)
Install (Korean)
NLS (Korean)
Business Intelligence ...
Documaker
WebLogic Server - JDBC
Data Service Integrator
Hyperion DRM/Analytica...
bea.kodo.beta
weblogic.developer.int...
AquaLogic User Interac...
JSR 168 & WSRP
BEA Guardian Newsgroups
Hyperion EPM
Exadata
Private Discussion For...
Communications Data Model
Generics
Java System Web Server
Java Technologies for ...
Java Servlet
Java Plug-In
Java Upgrade
Systems Management Tas...
Systems Development an...
New To Java Technology...
Event Handling
Sun ONE Unified Develo...
Database Firewall
バックアップ・リカバリ
Database Migration Ass...
Big Data
Platform as a Service ...
プログラミング一般
Oracle Coherence (MOSC...
Oracle Developer Cloud...
Oracle Cloud Services ...
Build
Software-as-a-Service
E10 Users
Eloqua Users with MS C...
Markies: Sales Impact
Interact 2014 Presenta...
MySQL Community Space
Professional Services ...
Interact 2014: A Moder...
Oracle Applications Us...
Software in Silicon (S...
IDGOUG - (Internationa...
Oracle Management Cloud
Big Data Cloud Infrast...
Duke's Choice Award 2016
Brazil - Eloqua User G...
Modern Marketing Eloqu...
Spatial
Oracle Linux
E-Business Suite
Financials
Oracle Business Rules ...
Data Integrator
CRM On Demand Integrat...
EPM System Management ...
Java Compiler (Develop...
Solaris Archived Forums
RTSJ (Real-Time Specif...
General FLEXCUBE Quest...
English
Middleware Track

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App