PLSD v7 SQL window

Gevorg · Apr 5, 2006

Why PLSD v7 in SQL window does not display anything in Statistics tabsheet when you execute SQL query.
And when you execute SQL query PLSD v7 automatically activates SQL tabsheet.
The same problem is with test window.

Stew Stryker · Apr 5, 2006

Gevorg,

I noticed I wasn't seeing anything in the Statistics tabsheet until I added them to my Preferences manually.

Tools->Preferences
Oracle->Options
Automatic Statistics, Select button
Default button

Good luck,

Gevorg · Apr 6, 2006

Stew,

Thanks it works.

--
Best regards,
Gevorg

Gevorg · Apr 6, 2006

Stew,

Thanks it works.

--
Best regards,
Gevorg

Ingo J · Jun 5, 2006

Hi, I am getting a blank page for statistics too.

I followed steps below(from Stew Stryker's post)
but I am still getting a blank page

Tools->Preferences
Oracle->Options
Automatic Statistics, Select button
Default button

Thanks in advance!

PL/SQL Developer Version 7.0.1.1066 (MBCS)

Marco Kalter · Jun 6, 2006

Did you get any messages when executing the SQL or PL/SQL for which you want to determine the resource usage statistics?

Brendan Kerr · Dec 18, 2006

I also get this problem. Has a reason been found for this?

Marco Kalter · Dec 18, 2006

Not really. Did you get any messages when executing the SQL or PL/SQL for which you want to determine the resource usage statistics?

Can you also let me know your PL/SQL Developer version?

dccase · Dec 18, 2006

I think that when I had that problem, I granted my user "Select Any Dictionary", then re-connected.

There is probably a smaller set of rights that could be granted instead.

Brendan Kerr · Dec 22, 2006

I tried the 'Select any dictionary' permission but to no avail. The version info is:

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
01.24263 - 20 user license
Windows XP version 6.0 (build 2600) Service Pack 2

thanks,
brendan

Marco Kalter · Dec 22, 2006

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

Brendan Kerr · Jan 11, 2007

I opened up PL/SQL dev, ran a simple query and checked the statistics window (note: empty) and then closed pl/sql developer down. Please see debug details generated as requested below:-

PL/SQL Developer 7.0.3.1123 01.24263 - 20 user license
C:\Program Files\PLSQL Developer\plsqldev.exe

11/01/2007 17:19:21 Application started
11/01/2007 17:19:21 InitPreferences
11/01/2007 17:19:21 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
11/01/2007 17:19:21 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
11/01/2007 17:19:21 PreferenceSet.Load OK
11/01/2007 17:19:21 Load C:\Program Files\PLSQL Developer\Preferences\kerrb = 0
11/01/2007 17:19:21 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\kerrb\Default kerrb.ini
11/01/2007 17:19:21 PreferenceSet.Load OK
11/01/2007 17:19:21 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\kerrb\default.ini
11/01/2007 17:19:21 PreferenceSet.Load OK
11/01/2007 17:19:21 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\kerrb\user.prefs
11/01/2007 17:19:21 PreferenceSet.Load OK
11/01/2007 17:19:21 InitPreferences end
11/01/2007 17:19:21 SortPreferenceSets
11/01/2007 17:19:21 - Default savagem
11/01/2007 17:19:21 - Default kerrb
11/01/2007 17:19:21 - System Default
11/01/2007 17:19:22 LoadPreferences
11/01/2007 17:19:22 LoadPreferences searching for default
11/01/2007 17:19:22 C:\Program Files\PLSQL Developer\Preferences\kerrb\Default kerrb.ini
11/01/2007 17:19:22 C:\Program Files\PLSQL Developer\Preferences\kerrb\default.ini
11/01/2007 17:19:22 LoadPreferences end
11/01/2007 17:19:22 FormCreate Logon.Execute
11/01/2007 17:19:28 TOracleSession PLSQLDevForm.Session Start Session.LogOn as ods@dwdev1
11/01/2007 17:19:29 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
11/01/2007 17:19:29 TOracleQuery Query End (1 record processed)
Duration = 0
11/01/2007 17:19:29 TOracleSession PLSQLDevForm.Session End
Duration = 0.609
11/01/2007 17:19:29 LogonHistorySave start
11/01/2007 17:19:29 ChangeUserPref LogonHistory,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref DSA,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref ColumnAssociations,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref ImportAssociations,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref BrowserFilters,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref BrowserFolders,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref SessionQueries,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref ExternalTools,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref Documents,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 ChangeUserPref Reports,
11/01/2007 17:19:29 ChangeUserPref end
11/01/2007 17:19:29 PreferenceSet.Save
11/01/2007 17:19:29 PreferenceSet filename = C:\Program Files\PLSQL Developer\Preferences\kerrb\user.prefs
11/01/2007 17:19:29 PreferenceSet.Save end
11/01/2007 17:19:29 LogonHistorySave end
11/01/2007 17:19:29 FormCreate Session.Connected
11/01/2007 17:19:29 FormCreate Logon.Executed -1
11/01/2007 17:19:29 FormCreate TDBNames.Make
11/01/2007 17:19:29 FormCreate SessionChanged
11/01/2007 17:19:29 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
11/01/2007 17:19:29 TOracleQuery Query End (5 records processed)
Duration = 0
11/01/2007 17:19:29 SessionChanged SetDBAViews
11/01/2007 17:19:29 SessionChanged Authorizations.Load
11/01/2007 17:19:29 TOracleQuery $026BBD30 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
11/01/2007 17:19:29 TOracleQuery $026BBD30 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
11/01/2007 17:19:29 SessionChanged EnableAuthorizedMenus
11/01/2007 17:19:29 TOracleSession $018EB220 Start Session.LogOn as ods@dwdev1
11/01/2007 17:19:29 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
11/01/2007 17:19:29 TOracleQuery Query End (1 record processed)
Duration = 0
11/01/2007 17:19:29 TOracleSession $018EB220 End
Duration = 0.078
11/01/2007 17:19:29 SetSessionAction starts: Main session
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
11/01/2007 17:19:29 TOracleQuery $026BBFF0 Start Query.Execute
SQL = select null from dual
11/01/2007 17:19:29 TOracleQuery $026BBFF0 End (1 record processed)
Duration = 0.016
11/01/2007 17:19:29 TOracleQuery $026BBFF0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
11/01/2007 17:19:29 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
11/01/2007 17:19:29 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
11/01/2007 17:19:29 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBFF0 End
Duration = 0.015
11/01/2007 17:19:29 SetSessionAction ends
11/01/2007 17:19:29 ExecuteConnectScript starts
11/01/2007 17:19:29 ExecuteConnectScript ends
11/01/2007 17:19:29 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
11/01/2007 17:19:29 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.047
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 SessionChanged LoadRecentObjects
11/01/2007 17:19:29 SessionChanged Notify children
11/01/2007 17:19:29 SessionChanged Logoff secondary sessions
11/01/2007 17:19:29 SessionChanged SessionMode = smMulti
11/01/2007 17:19:29 SessionChanged EnableChildFunctions
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.031
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.031
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 Toolbar.NavDisable
11/01/2007 17:19:29 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\oracle\product\10.2.0\client_1
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_1\bin\oci.dll
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.047
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.063
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:29 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:29 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:30 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.031
11/01/2007 17:19:30 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:30 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:30 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:30 TOracleQuery $026BBA70 End (48 records processed)
Duration = 0.016
11/01/2007 17:19:30 TOracleQuery $026BBA70 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
11/01/2007 17:19:30 Toolbar.NavDisable
11/01/2007 17:19:31 SortPreferenceSets
11/01/2007 17:19:31 - Default savagem
11/01/2007 17:19:31 - Default kerrb
11/01/2007 17:19:31 - System Default
11/01/2007 17:19:31 Toolbar.NavDisable
11/01/2007 17:19:31 Toolbar.NavDisable
11/01/2007 17:19:31 Toolbar.NavDisable
11/01/2007 17:19:31 WMUpdatePopups starts
11/01/2007 17:19:31 GetCrashList: 1443088.cfg
11/01/2007 17:19:31 GetCrashList: 327780.cfg
11/01/2007 17:19:31 GetCrashList: 460352.cfg
11/01/2007 17:19:31 LoadDesktop starts
11/01/2007 17:19:31 LoadDesktop ends
11/01/2007 17:19:31 WMUpdatePopups ends
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 1.734
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.047
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:31 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:31 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.031
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.015
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0.016
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:32 TOracleQuery $026BBA70 End (100 records processed)
Duration = 0
11/01/2007 17:19:32 TOracleQuery $026BBA70 Start Query.Next for up to 100 records
11/01/2007 17:19:33 TOracleQuery $026BBA70 End (61 records processed)
Duration = 0.656
11/01/2007 17:19:33 TOracleSession $018EB220 Start Session.LogOff
11/01/2007 17:19:33 TOracleSession $018EB220 End
Duration = 0
11/01/2007 17:19:33 Create TSQLForm
11/01/2007 17:19:33 SQLForm
11/01/2007 17:19:33 NavigationBookmarks.EnableButtons(Rebuild)
11/01/2007 17:19:33 NavigationBookmarks: Backward=0, Forward=0
11/01/2007 17:19:43 SQLForm Initializing...
11/01/2007 17:19:43 SetConnected starts
11/01/2007 17:19:43 SetConnected: Connect starts
11/01/2007 17:19:43 TOracleSession $018EBA00 Start Session.LogOn as ods@dwdev1
11/01/2007 17:19:43 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
11/01/2007 17:19:43 TOracleQuery Query End (1 record processed)
Duration = 0
11/01/2007 17:19:43 TOracleSession $018EBA00 End
Duration = 0.078
11/01/2007 17:19:43 SetConnected: (Dis)connect ends
11/01/2007 17:19:43 SetSessionAction starts: SQL Window - New
11/01/2007 17:19:43 TOracleQuery $026BC570 Start Query.Execute
SQL = select null from dual
11/01/2007 17:19:43 TOracleQuery $026BC570 End (1 record processed)
Duration = 0.016
11/01/2007 17:19:43 TOracleQuery $026BC570 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
11/01/2007 17:19:43 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
11/01/2007 17:19:43 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
11/01/2007 17:19:43 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery $026BC570 End
Duration = 0
11/01/2007 17:19:43 SetSessionAction ends
11/01/2007 17:19:43 ExecuteConnectScript starts
11/01/2007 17:19:43 ExecuteConnectScript ends
11/01/2007 17:19:43 TOracleQuery $026BC570 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
11/01/2007 17:19:43 TOracleQuery $026BC570 End (1 record processed)
Duration = 0
11/01/2007 17:19:43 EnableOutput starts
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable

size);
end if;
end;
:ENABLE = 1
:SIZE = 10000
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
11/01/2007 17:19:43 EnableOutput done
11/01/2007 17:19:43 InitStatistics starts
11/01/2007 17:19:43 TStatistics.Init starts
11/01/2007 17:19:43 InitStatNames starts
11/01/2007 17:19:43 select name from v$statname order by statistic#
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.DynamicQuery End (16 records processed)
Duration = 0
11/01/2007 17:19:43 InitStatNames ends
11/01/2007 17:19:43 StatQuery.Describe starts
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0.016
11/01/2007 17:19:43 StatQuery.Describe ends
11/01/2007 17:19:43 TStatistics.Init ends
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 931
11/01/2007 17:19:43 TOracleQuery PLSQLDevForm.StatQuery End (366 records processed)
Duration = 0
11/01/2007 17:19:43 InitStatistics ends
11/01/2007 17:19:43 NavigationBookmarks.EnableButtons(Rebuild)
11/01/2007 17:19:43 NavigationBookmarks: Backward=0, Forward=0
11/01/2007 17:19:43 SQLForm Executing...
11/01/2007 17:19:43 SQLForm Executing...
11/01/2007 17:19:43 TSQLThread SQLThread.Execute
11/01/2007 17:19:43 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
11/01/2007 17:19:43 TOracleQuery Query End
Duration = 0
11/01/2007 17:19:43 TOracleQuery $026BC830 Start Query.Execute
SQL = select * from ods.jiveforum
11/01/2007 17:19:44 TOracleQuery $026BC830 End (49 records processed)
Duration = 0.359
11/01/2007 17:19:44 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM ods.jiveforum
11/01/2007 17:19:44 TOracleQuery SQLForm.TestQuery End
Duration = 0
11/01/2007 17:19:44 SQLForm Executing... (10)
11/01/2007 17:19:44 SQLForm Executing... (20)
11/01/2007 17:19:44 SQLForm Executing... (30)
11/01/2007 17:19:44 SQLForm Executing... (40)
11/01/2007 17:19:44 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
11/01/2007 17:19:44 TOracleQuery Query End
Duration = 0
11/01/2007 17:19:44 TSQLThread SQLThread Postmessage
11/01/2007 17:19:44 TSQLThread SQLThread Suspend
11/01/2007 17:19:44 TSQLForm.ThreadFinished
11/01/2007 17:19:44 TSQLForm.ThreadFinished: SQLThread.Suspended
11/01/2007 17:19:44 SQLForm 49 rows selected in 0.594 seconds
11/01/2007 17:19:44 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 931
11/01/2007 17:19:44 TOracleQuery PLSQLDevForm.StatQuery End (366 records processed)
Duration = 0.016
11/01/2007 17:19:44 NavigationBookmarks.EnableButtons(Rebuild)
11/01/2007 17:19:44 NavigationBookmarks: Backward=0, Forward=0
11/01/2007 17:19:44 TOracleQuery $026BC6D0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
11/01/2007 17:19:44 TOracleQuery $026BC6D0 End
Duration = 0
11/01/2007 17:19:44 SQLForm 49 rows selected in 0.594 seconds
11/01/2007 17:19:46 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
11/01/2007 17:19:46 TOracleQuery Query End
Duration = 0
11/01/2007 17:19:46 NavigationBookmarks.EnableButtons(Rebuild)
11/01/2007 17:19:46 NavigationBookmarks: Backward=0, Forward=0
11/01/2007 17:19:52 TOracleQuery $026BC6D0 Start Query.Execute
SQL = select 'x' from dual
11/01/2007 17:19:52 TOracleQuery $026BC6D0 End (1 record processed)
Duration = 0
11/01/2007 17:19:52 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
11/01/2007 17:19:52 TOracleQuery Query End
Duration = 0
11/01/2007 17:19:52 MainForm Closing
11/01/2007 17:19:52 ChangeUserPref , PlanViewType
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref Logon, Username
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref Logon, Database
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref Logon, ConnectAs
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref , LastNewsRead
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref , LastNewsItem
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref , LastUpdateItem
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 TOracleSession PLSQLDevForm.Session Start Session.LogOff
11/01/2007 17:19:52 TOracleSession PLSQLDevForm.Session End
Duration = 0
11/01/2007 17:19:52 MainForm Closed
11/01/2007 17:19:52 Destroying TSQLForm
11/01/2007 17:19:52 Destroying - EnableChildFunctions
11/01/2007 17:19:52 Destroying - Session
11/01/2007 17:19:52 TOracleSession $018EBA00 Start Session.LogOff
11/01/2007 17:19:52 TOracleSession $018EBA00 End
Duration = 0
11/01/2007 17:19:52 Destroying - Debugger
11/01/2007 17:19:52 Destroying SQLThread
11/01/2007 17:19:52 TSQLThread SQLThread Suspend ended
11/01/2007 17:19:52 Destroying - Free stuff
11/01/2007 17:19:52 Destroying - UpdateChildList
11/01/2007 17:19:52 Destroyed TSQLForm
11/01/2007 17:19:52 ChangeUserPref LogonHistory,
11/01/2007 17:19:52 ChangeUserPref DSA,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref ColumnAssociations,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref ImportAssociations,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref BrowserFilters,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref BrowserFolders,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref SessionQueries,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref ExternalTools,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref Documents,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 ChangeUserPref Reports,
11/01/2007 17:19:52 ChangeUserPref end
11/01/2007 17:19:52 PreferenceSet.Save
11/01/2007 17:19:52 PreferenceSet filename = C:\Program Files\PLSQL Developer\Preferences\kerrb\user.prefs
11/01/2007 17:19:52 PreferenceSet.Save end
11/01/2007 17:19:52 MainForm Destroying
11/01/2007 17:19:53 MainForm Destroyed
11/01/2007 17:19:53 Finalization HTMLUnit
11/01/2007 17:19:53 Finalization HTMLUnit done
11/01/2007 17:19:53 Finalization PLSCommon
11/01/2007 17:19:53 Finalization PLSCommon done
11/01/2007 17:19:53 Finalization DBObjectUnit
11/01/2007 17:19:53 Finalization DBObjectUnit done
11/01/2007 17:19:53 Finalization PlanUnit
11/01/2007 17:19:53 Finalization PlanUnit done
11/01/2007 17:19:54 Finalization DBNamesUnit
11/01/2007 17:19:54 Finalization DBNamesUnit done
11/01/2007 17:19:54 Finalization MacroUnit
11/01/2007 17:19:54 Finalization MacroUnit done
11/01/2007 17:19:54 Finalization HTMLUnit
11/01/2007 17:19:54 Finalization HTMLUnit done
11/01/2007 17:19:54 Finalization TotalRecallUnit
11/01/2007 17:19:54 Finalization TotalRecallUnit done
11/01/2007 17:19:54 Finalization RepUnit
11/01/2007 17:19:54 Finalization RepUnit done
11/01/2007 17:19:54 Finalization ReportCommon
11/01/2007 17:19:54 Finalization ReportCommon done
11/01/2007 17:19:54 Finalization RowExportUnit
11/01/2007 17:19:54 Finalization RowExportUnit done
11/01/2007 17:19:54 Finalization StatUnit
11/01/2007 17:19:54 Finalization StatUnit done

Marco Kalter · Jan 12, 2007

According to this logging, 366 statistic values were retrieved. I assume nothng was displayed? If so, can you go to Tools > Preferences > Options and verify if any of the statistics are enabled (press the "Select" button to check this)?

Brendan Kerr · Jan 15, 2007

All statistics are selected in the options pane, but the statistics tab on the SQL window is empty.

Marco Kalter · Jan 15, 2007

Can you send me a screenshot of such an empty statistics page?

Brendan Kerr · Feb 1, 2007

screenshot has been e-mailed.

PLSD v7 SQL window

Gevorg

Member²

Stew Stryker

Member³

Gevorg

Member²

Gevorg

Member²

Ingo J

Member

Marco Kalter

Administrator

Brendan Kerr

Member

Marco Kalter

Administrator

dccase

Member

Brendan Kerr

Member

Marco Kalter

Administrator

Brendan Kerr

Member

Marco Kalter

Administrator

Brendan Kerr

Member

Marco Kalter

Administrator

Brendan Kerr

Member

Similar threads