help!!
- Thread starter shadow
- Start date
Which version are you using?
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.
"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.
PL/SQL Developer 7.0.1.1066 18253.6320 - Unlimited user license
D:\tools\PLSQL Developer\plsqldev.exe
2006-3-25 16:59:48 Application started
2006-3-25 16:59:48 InitPreferences
2006-3-25 16:59:48 Load D:\tools\PLSQL Developer\Preferences\Default = 0
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Default\Default.ini
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 PreferenceSet.Save
2006-3-25 16:59:48 PreferenceSet filename = D:\tools\PLSQL Developer\Preferences\Default\Default.ini
2006-3-25 16:59:48 PreferenceSet.Save end
2006-3-25 16:59:48 Load D:\tools\PLSQL Developer\Preferences\Administrator = 0
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 PreferenceSet.Save
2006-3-25 16:59:48 PreferenceSet filename = D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:48 PreferenceSet.Save end
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Administrator\user.prefs
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 InitPreferences end
2006-3-25 16:59:48 SortPreferenceSets
2006-3-25 16:59:48 - Default Administrator
2006-3-25 16:59:48 - System Default
2006-3-25 16:59:49 LoadPreferences
2006-3-25 16:59:49 LoadPreferences searching for default
2006-3-25 16:59:49 D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:49 LoadPreferences end
2006-3-25 16:59:49 FormCreate Logon.Execute
2006-3-25 16:59:53 TOracleSession PLSQLDevForm.Session Start Session.LogOn as report@ods
2006-3-25 16:59:53 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 16:59:53 TOracleQuery Query End (1 record processed)
Duration = 0.01
2006-3-25 16:59:53 TOracleSession PLSQLDevForm.Session End
Duration = 0.241
2006-3-25 16:59:53 LogonHistorySave start
2006-3-25 16:59:53 ChangeUserPref LogonHistory,
2006-3-25 16:59:53 ChangeUserPref DSA,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ColumnAssociations,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ImportAssociations,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref BrowserFilters,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref BrowserFolders,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref SessionQueries,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ExternalTools,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref Documents,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref Reports,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 LogonHistorySave end
2006-3-25 16:59:53 FormCreate Session.Connected
2006-3-25 16:59:53 FormCreate Logon.Executed -1
2006-3-25 16:59:53 FormCreate TDBNames.Make
2006-3-25 16:59:53 FormCreate SessionChanged
2006-3-25 16:59:53 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
2006-3-25 16:59:53 TOracleQuery Query End (5 records processed)
Duration = 0
2006-3-25 16:59:53 SessionChanged SetDBAViews
2006-3-25 16:59:53 SessionChanged Authorizations.Load
2006-3-25 16:59:53 TOracleQuery $017E6E50 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)
2006-3-25 16:59:53 TOracleQuery $017E6E50 End
Result = ORA-00942: 表或视图不存在
Duration = 0.01
2006-3-25 16:59:53 SessionChanged EnableAuthorizedMenus
2006-3-25 16:59:53 TOracleSession $021BD6F0 Start Session.LogOn as report@ods
2006-3-25 16:59:54 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 16:59:54 TOracleQuery Query End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleSession $021BD6F0 End
Duration = 0.791
2006-3-25 16:59:54 SetSessionAction starts: Main session
2006-3-25 16:59:54 TOracleQuery $017E6F90 Start Query.Execute
SQL = select null from dual
2006-3-25 16:59:54 TOracleQuery $017E6D10 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')
2006-3-25 16:59:54 TOracleQuery $017E6F90 End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6F90 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
2006-3-25 16:59:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6F90 End
Duration = 0.02
2006-3-25 16:59:54 SetSessionAction ends
2006-3-25 16:59:54 ExecuteConnectScript starts
2006-3-25 16:59:54 ExecuteConnectScript ends
2006-3-25 16:59:54 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.03
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.04
2006-3-25 16:59:54 SessionChanged LoadRecentObjects
2006-3-25 16:59:54 SessionChanged Notify children
2006-3-25 16:59:54 SessionChanged Logoff secondary sessions
2006-3-25 16:59:54 SessionChanged SessionMode = smMulti
2006-3-25 16:59:54 SessionChanged EnableChildFunctions
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.06
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.05
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: D:\oracle\ora90
Found: oci.dll
Using: D:\oracle\ora90\bin\oci.dll
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.11
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (71 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 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')
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.341
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.03
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.07
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.05
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.04
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (48 records processed)
Duration = 0.161
2006-3-25 16:59:55 TOracleSession $021BD6F0 Start Session.LogOff
2006-3-25 16:59:55 TOracleSession $021BD6F0 End
Duration = 0
2006-3-25 16:59:56 SortPreferenceSets
2006-3-25 16:59:56 - Default Administrator
2006-3-25 16:59:56 - System Default
2006-3-25 16:59:59 Create TSQLForm
2006-3-25 16:59:59 SQLForm
2006-3-25 17:00:08 SQLForm Initializing...
2006-3-25 17:00:08 SetConnected starts
2006-3-25 17:00:08 SetConnected: Connect starts
2006-3-25 17:00:08 TOracleSession $021BE410 Start Session.LogOn as report@ods
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 17:00:08 TOracleQuery Query End (1 record processed)
Duration = 0
2006-3-25 17:00:08 TOracleSession $021BE410 End
Duration = 0.17
2006-3-25 17:00:08 SetConnected: (Dis)connect ends
2006-3-25 17:00:08 SetSessionAction starts: SQL Window - New
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = select null from dual
2006-3-25 17:00:08 TOracleQuery $017E7490 End (1 record processed)
Duration = 0
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
2006-3-25 17:00:08 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
2006-3-25 17:00:08 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:08 TOracleQuery $017E7490 End
Duration = 0.02
2006-3-25 17:00:08 SetSessionAction ends
2006-3-25 17:00:08 ExecuteConnectScript starts
2006-3-25 17:00:08 ExecuteConnectScript ends
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
2006-3-25 17:00:08 TOracleQuery $017E7490 End
Result = ORA-00942: 表或视图不存在
Duration = 0.01
2006-3-25 17:00:08 EnableOutput starts
2006-3-25 17:00:08 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
2006-3-25 17:00:08 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
2006-3-25 17:00:08 EnableOutput done
2006-3-25 17:00:08 InitStatistics starts
2006-3-25 17:00:08 TStatistics.Init starts
2006-3-25 17:00:08 TStatistics.Init ends
2006-3-25 17:00:08 InitStatistics ends
2006-3-25 17:00:08 SQLForm Executing...
2006-3-25 17:00:08 SQLForm Executing...
2006-3-25 17:00:08 TSQLThread SQLThread.Execute
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:08 TOracleQuery Query End
Duration = 0
2006-3-25 17:00:08 TOracleQuery $017E7710 Start Query.Execute
SQL = select t.*,t.rowid from mid_sms_sum_mon_g_t t
2006-3-25 17:00:08 TOracleQuery $017E7710 End (100 records processed)
Duration = 0.03
2006-3-25 17:00:08 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM mid_sms_sum_mon_g_t
2006-3-25 17:00:08 TOracleQuery SQLForm.TestQuery End
Duration = 0.01
2006-3-25 17:00:08 SQLForm Executing... (10)
2006-3-25 17:00:08 SQLForm Executing... (20)
2006-3-25 17:00:08 SQLForm Executing... (30)
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:08 TOracleQuery Query End
Duration = 0.01
2006-3-25 17:00:08 TSQLThread SQLThread Postmessage
2006-3-25 17:00:08 TSQLThread SQLThread Suspend
2006-3-25 17:00:08 TSQLForm.ThreadFinished
2006-3-25 17:00:08 TSQLForm.ThreadFinished: SQLThread.Suspended
2006-3-25 17:00:08 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:08 TOracleQuery $017E75D0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
2006-3-25 17:00:08 TOracleQuery $017E75D0 End
Duration = 0
2006-3-25 17:00:08 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if
bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner =bject_owner
and object_name =bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
if :deep != 0 then
begin
if
art2 is null then
select constraint_type, owner, constraint_name
intobject_type, bject_owner, bject_name
from sys.all_constraints c
where c.constraint_name =art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name,art3
intobject_type, bject_owner, bject_name, :sub_object
from sys.all_constraints c
where c.constraint_name =art2 and c.owner = art1
and rownum = 1;
end if;
ifbject_type = 'P' then bject_type := 'PRIMARY KEY'; end if;
ifbject_type = 'U' then bject_type := 'UNIQUE KEY'; end if;
ifbject_type = 'R' then bject_type := 'FOREIGN KEY'; end if;
ifbject_type = 'C' then bject_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object :=art2;
ifpart2 is null) or part1 != user) then
begin
select object_type, user,art1
intobject_type, bject_owner, bject_name
from sys.all_objects
where owner = user
and object_name =art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
ifbject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
intobject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object :=art2;
ifart3 is not null then
:sub_object := :sub_object || '.' ||art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
intobject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object :=art3;
begin
select o.object_type, o.owner, o.object_name
intobject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner =art1
and o.object_name =art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
ifart2 is null and art3 is null
then
select 'USER', null,art1
intobject_type, bject_owner, bject_name
from sys.all_users u
where u.username =art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
ifart2 is null and art3 is null and :deep != 0
then
select 'ROLE', null,art1
intobject_type, bject_owner, bject_name
from sys.session_roles r
where r.role =art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = MID_SMS_SUM_MON_G_T
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =
:SUB_OBJECT = Null
ART3 =
EEP = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Execute
SQL = select col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner =wner
and col.table_name = :table_name
and com.Owner (+) = :Owner
and com.Table_Name (+) = :table_name
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = MID_SMS_SUM_MON_G_T
:OWNER = REPORT
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used,
to_char(ini_trans) ini_trans, to_char(max_trans) max_trans,
to_char(initial_extent) initial_extent, to_char(next_extent) next_extent,
to_char(pct_increase) pct_increase,
to_char(min_extents) min_extents, to_char(max_extents) max_extents,
cluster_name
from sys.all_tables
where owner =bject_owner
and table_name =bject_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select *
from sys.all_tables
where owner =bject_owner
and table_name =bject_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select comments from sys.all_tab_comments
where owner =bject_owner
and table_name =bject_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner =wner
and col.table_name = :table_name
and com.Owner (+) = :Owner
and com.Table_Name (+) = :table_name
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = MID_SMS_SUM_MON_G_T
:OWNER = REPORT
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.011
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_constraints
where table_name =bject_name
and owner =bject_owner
and constraint_type in ('P', 'U', 'R', 'C')
order by decode(constraint_type, 'P', 0, 'U', 1, 'R', 2, 3), constraint_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_indexes
where table_name =bject_name
and table_owner =bject_owner
order by index_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_tab_privs
where table_schema =bject_owner
and table_name =bject_name
order by grantee
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_tab_partitions
where table_name =bject_name
and table_owner =bject_owner
and trim(composite) = 'NO'
order by partition_position
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 1.422
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.03
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select column_name
from sys.all_part_key_columns
where owner =bject_owner
and name =bject_name
and trim(object_type) = 'TABLE'
order by column_position
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (2 records processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select partitioning_type
from sys.all_part_tables
where owner =bject_owner
and table_name =bject_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_queue_tables
where queue_table =bject_name
and owner =bject_owner
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:17 SQLForm stat_month, varchar2(8), optional
2006-3-25 17:00:17 SQLForm stat_month, varchar2(8), optional
2006-3-25 17:00:17 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:23 TOracleQuery $017E75D0 Start Query.Execute
SQL = select 'x' from dual
2006-3-25 17:00:23 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:23 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:23 TOracleQuery Query End
Duration = 0
2006-3-25 17:00:23 MainForm Closing
2006-3-25 17:00:23 ChangeUserPref , PlanViewType
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, Username
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, Database
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, ConnectAs
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastNewsRead
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastNewsItem
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastUpdateItem
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 TOracleSession PLSQLDevForm.Session Start Session.LogOff
2006-3-25 17:00:23 TOracleSession PLSQLDevForm.Session End
Duration = 0
2006-3-25 17:00:23 MainForm Closed
2006-3-25 17:00:23 Destroying TSQLForm
2006-3-25 17:00:23 TOracleSession $021BE410 Start Session.LogOff
2006-3-25 17:00:23 TOracleSession $021BE410 End
Duration = 0.01
2006-3-25 17:00:23 TSQLThread SQLThread Suspend ended
2006-3-25 17:00:23 Destroyed TSQLForm
2006-3-25 17:00:23 ChangeUserPref LogonHistory,
2006-3-25 17:00:23 ChangeUserPref DSA,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ColumnAssociations,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ImportAssociations,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref BrowserFilters,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref BrowserFolders,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref SessionQueries,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ExternalTools,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Documents,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Reports,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 MainForm Destroying
2006-3-25 17:00:23 MainForm Destroyed
2006-3-25 17:00:23 Finalization HTMLUnit
2006-3-25 17:00:23 Finalization HTMLUnit done
2006-3-25 17:00:23 Finalization PLSCommon
2006-3-25 17:00:23 Finalization PLSCommon done
2006-3-25 17:00:23 Finalization DBObjectUnit
2006-3-25 17:00:23 Finalization DBObjectUnit done
2006-3-25 17:00:23 Finalization RepUnit
2006-3-25 17:00:23 Finalization RepUnit done
2006-3-25 17:00:23 Finalization ReportCommon
2006-3-25 17:00:23 Finalization ReportCommon done
2006-3-25 17:00:23 Finalization PlanUnit
2006-3-25 17:00:23 Finalization PlanUnit done
2006-3-25 17:00:23 Finalization MacroUnit
2006-3-25 17:00:23 Finalization MacroUnit done
2006-3-25 17:00:23 Finalization StatUnit
2006-3-25 17:00:23 Finalization StatUnit done
2006-3-25 17:00:23 Finalization DBNamesUnit
2006-3-25 17:00:23 Finalization DBNamesUnit done
2006-3-25 17:00:23 Finalization TotalRecallUnit
2006-3-25 17:00:23 Finalization TotalRecallUnit done
2006-3-25 17:00:23 Finalization RowExportUnit
2006-3-25 17:00:23 Finalization RowExportUnit done
D:\tools\PLSQL Developer\plsqldev.exe
2006-3-25 16:59:48 Application started
2006-3-25 16:59:48 InitPreferences
2006-3-25 16:59:48 Load D:\tools\PLSQL Developer\Preferences\Default = 0
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Default\Default.ini
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 PreferenceSet.Save
2006-3-25 16:59:48 PreferenceSet filename = D:\tools\PLSQL Developer\Preferences\Default\Default.ini
2006-3-25 16:59:48 PreferenceSet.Save end
2006-3-25 16:59:48 Load D:\tools\PLSQL Developer\Preferences\Administrator = 0
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 PreferenceSet.Save
2006-3-25 16:59:48 PreferenceSet filename = D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:48 PreferenceSet.Save end
2006-3-25 16:59:48 PreferenceSet.Load D:\tools\PLSQL Developer\Preferences\Administrator\user.prefs
2006-3-25 16:59:48 PreferenceSet.Load OK
2006-3-25 16:59:48 InitPreferences end
2006-3-25 16:59:48 SortPreferenceSets
2006-3-25 16:59:48 - Default Administrator
2006-3-25 16:59:48 - System Default
2006-3-25 16:59:49 LoadPreferences
2006-3-25 16:59:49 LoadPreferences searching for default
2006-3-25 16:59:49 D:\tools\PLSQL Developer\Preferences\Administrator\default.ini
2006-3-25 16:59:49 LoadPreferences end
2006-3-25 16:59:49 FormCreate Logon.Execute
2006-3-25 16:59:53 TOracleSession PLSQLDevForm.Session Start Session.LogOn as report@ods
2006-3-25 16:59:53 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 16:59:53 TOracleQuery Query End (1 record processed)
Duration = 0.01
2006-3-25 16:59:53 TOracleSession PLSQLDevForm.Session End
Duration = 0.241
2006-3-25 16:59:53 LogonHistorySave start
2006-3-25 16:59:53 ChangeUserPref LogonHistory,
2006-3-25 16:59:53 ChangeUserPref DSA,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ColumnAssociations,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ImportAssociations,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref BrowserFilters,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref BrowserFolders,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref SessionQueries,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref ExternalTools,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref Documents,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 ChangeUserPref Reports,
2006-3-25 16:59:53 ChangeUserPref end
2006-3-25 16:59:53 LogonHistorySave end
2006-3-25 16:59:53 FormCreate Session.Connected
2006-3-25 16:59:53 FormCreate Logon.Executed -1
2006-3-25 16:59:53 FormCreate TDBNames.Make
2006-3-25 16:59:53 FormCreate SessionChanged
2006-3-25 16:59:53 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
2006-3-25 16:59:53 TOracleQuery Query End (5 records processed)
Duration = 0
2006-3-25 16:59:53 SessionChanged SetDBAViews
2006-3-25 16:59:53 SessionChanged Authorizations.Load
2006-3-25 16:59:53 TOracleQuery $017E6E50 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)
2006-3-25 16:59:53 TOracleQuery $017E6E50 End
Result = ORA-00942: 表或视图不存在
Duration = 0.01
2006-3-25 16:59:53 SessionChanged EnableAuthorizedMenus
2006-3-25 16:59:53 TOracleSession $021BD6F0 Start Session.LogOn as report@ods
2006-3-25 16:59:54 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 16:59:54 TOracleQuery Query End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleSession $021BD6F0 End
Duration = 0.791
2006-3-25 16:59:54 SetSessionAction starts: Main session
2006-3-25 16:59:54 TOracleQuery $017E6F90 Start Query.Execute
SQL = select null from dual
2006-3-25 16:59:54 TOracleQuery $017E6D10 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')
2006-3-25 16:59:54 TOracleQuery $017E6F90 End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6F90 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
2006-3-25 16:59:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6F90 End
Duration = 0.02
2006-3-25 16:59:54 SetSessionAction ends
2006-3-25 16:59:54 ExecuteConnectScript starts
2006-3-25 16:59:54 ExecuteConnectScript ends
2006-3-25 16:59:54 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.03
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.04
2006-3-25 16:59:54 SessionChanged LoadRecentObjects
2006-3-25 16:59:54 SessionChanged Notify children
2006-3-25 16:59:54 SessionChanged Logoff secondary sessions
2006-3-25 16:59:54 SessionChanged SessionMode = smMulti
2006-3-25 16:59:54 SessionChanged EnableChildFunctions
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.06
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.05
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: D:\oracle\ora90
Found: oci.dll
Using: D:\oracle\ora90\bin\oci.dll
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.11
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:54 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:54 TOracleQuery $017E6D10 End (71 records processed)
Duration = 0.01
2006-3-25 16:59:54 TOracleQuery $017E6D10 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')
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.341
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.03
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.02
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.07
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.01
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.05
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (100 records processed)
Duration = 0.04
2006-3-25 16:59:55 TOracleQuery $017E6D10 Start Query.Next for up to 100 records
2006-3-25 16:59:55 TOracleQuery $017E6D10 End (48 records processed)
Duration = 0.161
2006-3-25 16:59:55 TOracleSession $021BD6F0 Start Session.LogOff
2006-3-25 16:59:55 TOracleSession $021BD6F0 End
Duration = 0
2006-3-25 16:59:56 SortPreferenceSets
2006-3-25 16:59:56 - Default Administrator
2006-3-25 16:59:56 - System Default
2006-3-25 16:59:59 Create TSQLForm
2006-3-25 16:59:59 SQLForm
2006-3-25 17:00:08 SQLForm Initializing...
2006-3-25 17:00:08 SetConnected starts
2006-3-25 17:00:08 SetConnected: Connect starts
2006-3-25 17:00:08 TOracleSession $021BE410 Start Session.LogOn as report@ods
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2006-3-25 17:00:08 TOracleQuery Query End (1 record processed)
Duration = 0
2006-3-25 17:00:08 TOracleSession $021BE410 End
Duration = 0.17
2006-3-25 17:00:08 SetConnected: (Dis)connect ends
2006-3-25 17:00:08 SetSessionAction starts: SQL Window - New
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = select null from dual
2006-3-25 17:00:08 TOracleQuery $017E7490 End (1 record processed)
Duration = 0
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
2006-3-25 17:00:08 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
2006-3-25 17:00:08 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:08 TOracleQuery $017E7490 End
Duration = 0.02
2006-3-25 17:00:08 SetSessionAction ends
2006-3-25 17:00:08 ExecuteConnectScript starts
2006-3-25 17:00:08 ExecuteConnectScript ends
2006-3-25 17:00:08 TOracleQuery $017E7490 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
2006-3-25 17:00:08 TOracleQuery $017E7490 End
Result = ORA-00942: 表或视图不存在
Duration = 0.01
2006-3-25 17:00:08 EnableOutput starts
2006-3-25 17:00:08 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
2006-3-25 17:00:08 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
2006-3-25 17:00:08 EnableOutput done
2006-3-25 17:00:08 InitStatistics starts
2006-3-25 17:00:08 TStatistics.Init starts
2006-3-25 17:00:08 TStatistics.Init ends
2006-3-25 17:00:08 InitStatistics ends
2006-3-25 17:00:08 SQLForm Executing...
2006-3-25 17:00:08 SQLForm Executing...
2006-3-25 17:00:08 TSQLThread SQLThread.Execute
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:08 TOracleQuery Query End
Duration = 0
2006-3-25 17:00:08 TOracleQuery $017E7710 Start Query.Execute
SQL = select t.*,t.rowid from mid_sms_sum_mon_g_t t
2006-3-25 17:00:08 TOracleQuery $017E7710 End (100 records processed)
Duration = 0.03
2006-3-25 17:00:08 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM mid_sms_sum_mon_g_t
2006-3-25 17:00:08 TOracleQuery SQLForm.TestQuery End
Duration = 0.01
2006-3-25 17:00:08 SQLForm Executing... (10)
2006-3-25 17:00:08 SQLForm Executing... (20)
2006-3-25 17:00:08 SQLForm Executing... (30)
2006-3-25 17:00:08 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:08 TOracleQuery Query End
Duration = 0.01
2006-3-25 17:00:08 TSQLThread SQLThread Postmessage
2006-3-25 17:00:08 TSQLThread SQLThread Suspend
2006-3-25 17:00:08 TSQLForm.ThreadFinished
2006-3-25 17:00:08 TSQLForm.ThreadFinished: SQLThread.Suspended
2006-3-25 17:00:08 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:08 TOracleQuery $017E75D0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
2006-3-25 17:00:08 TOracleQuery $017E75D0 End
Duration = 0
2006-3-25 17:00:08 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if
bject_type = 'TABLE' thenselect 1 into dummy
from sys.all_objects
where owner =
bject_ownerand object_name =
bject_nameand object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';end if;
exception
when others then null;
end;
begin
:sub_object := null;
if :deep != 0 then
begin
if
art2 is null thenselect constraint_type, owner, constraint_name
into
bject_type, bject_owner, bject_namefrom sys.all_constraints c
where c.constraint_name =
art1 and c.owner = userand rownum = 1;
else
select constraint_type, owner, constraint_name,
art3into
bject_type, bject_owner, bject_name, :sub_objectfrom sys.all_constraints c
where c.constraint_name =
art2 and c.owner = art1and rownum = 1;
end if;
if
bject_type = 'P' then bject_type := 'PRIMARY KEY'; end if;if
bject_type = 'U' then bject_type := 'UNIQUE KEY'; end if;if
bject_type = 'R' then bject_type := 'FOREIGN KEY'; end if;if
bject_type = 'C' then bject_type := 'CHECK CONSTRAINT'; end if;return;
exception
when no_data_found then null;
end;
end if;
:sub_object :=
art2;if
part2 is null) or part1 != user) thenbegin
select object_type, user,
art1into
bject_type, bject_owner, bject_namefrom sys.all_objects
where owner = user
and object_name =
art1and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if
bject_type = 'SYNONYM' thenselect s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type, bject_owner, bject_namefrom sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object :=
art2;if
art3 is not null then:sub_object := :sub_object || '.' ||
art3;end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type, bject_owner, bject_namefrom sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object :=
art3;begin
select o.object_type, o.owner, o.object_name
into
bject_type, bject_owner, bject_namefrom sys.all_objects o
where o.owner =
art1and o.object_name =
art2and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if
art2 is null and art3 is nullthen
select 'USER', null,
art1into
bject_type, bject_owner, bject_namefrom sys.all_users u
where u.username =
art1and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if
art2 is null and art3 is null and :deep != 0then
select 'ROLE', null,
art1into
bject_type, bject_owner, bject_namefrom sys.session_roles r
where r.role =
art1and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
bject_owner := null;bject_type := null;bject_name := null;:sub_object := null;
end;
ART1 = MID_SMS_SUM_MON_G_T:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =:SUB_OBJECT = Null
ART3 =EEP = 02006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Execute
SQL = select col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner =
wnerand col.table_name = :table_name
and com.Owner (+) = :Owner
and com.Table_Name (+) = :table_name
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = MID_SMS_SUM_MON_G_T
:OWNER = REPORT
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery PLSQLDevForm.ColumnQuery End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used,
to_char(ini_trans) ini_trans, to_char(max_trans) max_trans,
to_char(initial_extent) initial_extent, to_char(next_extent) next_extent,
to_char(pct_increase) pct_increase,
to_char(min_extents) min_extents, to_char(max_extents) max_extents,
cluster_name
from sys.all_tables
where owner =
bject_ownerand table_name =
bject_name:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select *
from sys.all_tables
where owner =
bject_ownerand table_name =
bject_name:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select comments from sys.all_tab_comments
where owner =
bject_ownerand table_name =
bject_name:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner =
wnerand col.table_name = :table_name
and com.Owner (+) = :Owner
and com.Table_Name (+) = :table_name
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = MID_SMS_SUM_MON_G_T
:OWNER = REPORT
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.011
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_constraints
where table_name =
bject_nameand owner =
bject_ownerand constraint_type in ('P', 'U', 'R', 'C')
order by decode(constraint_type, 'P', 0, 'U', 1, 'R', 2, 3), constraint_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_indexes
where table_name =
bject_nameand table_owner =
bject_ownerorder by index_name
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.02
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_tab_privs
where table_schema =
bject_ownerand table_name =
bject_nameorder by grantee
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:15 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:15 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_tab_partitions
where table_name =
bject_nameand table_owner =
bject_ownerand trim(composite) = 'NO'
order by partition_position
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 1.422
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.03
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Next for up to 1 record
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select column_name
from sys.all_part_key_columns
where owner =
bject_ownerand name =
bject_nameand trim(object_type) = 'TABLE'
order by column_position
:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (2 records processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select partitioning_type
from sys.all_part_tables
where owner =
bject_ownerand table_name =
bject_name:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:17 TOracleQuery $017E75D0 Start Query.Execute
SQL = select * from sys.all_queue_tables
where queue_table =
bject_nameand owner =
bject_owner:OBJECT_OWNER = REPORT
:OBJECT_NAME = MID_SMS_SUM_MON_G_T
2006-3-25 17:00:17 TOracleQuery $017E75D0 End (0 records processed)
Duration = 0.01
2006-3-25 17:00:17 SQLForm stat_month, varchar2(8), optional
2006-3-25 17:00:17 SQLForm stat_month, varchar2(8), optional
2006-3-25 17:00:17 SQLForm 32 rows selected in 0.331 seconds (more...)
2006-3-25 17:00:23 TOracleQuery $017E75D0 Start Query.Execute
SQL = select 'x' from dual
2006-3-25 17:00:23 TOracleQuery $017E75D0 End (1 record processed)
Duration = 0.01
2006-3-25 17:00:23 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2006-3-25 17:00:23 TOracleQuery Query End
Duration = 0
2006-3-25 17:00:23 MainForm Closing
2006-3-25 17:00:23 ChangeUserPref , PlanViewType
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, Username
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, Database
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Logon, ConnectAs
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastNewsRead
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastNewsItem
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref , LastUpdateItem
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 TOracleSession PLSQLDevForm.Session Start Session.LogOff
2006-3-25 17:00:23 TOracleSession PLSQLDevForm.Session End
Duration = 0
2006-3-25 17:00:23 MainForm Closed
2006-3-25 17:00:23 Destroying TSQLForm
2006-3-25 17:00:23 TOracleSession $021BE410 Start Session.LogOff
2006-3-25 17:00:23 TOracleSession $021BE410 End
Duration = 0.01
2006-3-25 17:00:23 TSQLThread SQLThread Suspend ended
2006-3-25 17:00:23 Destroyed TSQLForm
2006-3-25 17:00:23 ChangeUserPref LogonHistory,
2006-3-25 17:00:23 ChangeUserPref DSA,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ColumnAssociations,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ImportAssociations,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref BrowserFilters,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref BrowserFolders,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref SessionQueries,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref ExternalTools,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Documents,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 ChangeUserPref Reports,
2006-3-25 17:00:23 ChangeUserPref end
2006-3-25 17:00:23 MainForm Destroying
2006-3-25 17:00:23 MainForm Destroyed
2006-3-25 17:00:23 Finalization HTMLUnit
2006-3-25 17:00:23 Finalization HTMLUnit done
2006-3-25 17:00:23 Finalization PLSCommon
2006-3-25 17:00:23 Finalization PLSCommon done
2006-3-25 17:00:23 Finalization DBObjectUnit
2006-3-25 17:00:23 Finalization DBObjectUnit done
2006-3-25 17:00:23 Finalization RepUnit
2006-3-25 17:00:23 Finalization RepUnit done
2006-3-25 17:00:23 Finalization ReportCommon
2006-3-25 17:00:23 Finalization ReportCommon done
2006-3-25 17:00:23 Finalization PlanUnit
2006-3-25 17:00:23 Finalization PlanUnit done
2006-3-25 17:00:23 Finalization MacroUnit
2006-3-25 17:00:23 Finalization MacroUnit done
2006-3-25 17:00:23 Finalization StatUnit
2006-3-25 17:00:23 Finalization StatUnit done
2006-3-25 17:00:23 Finalization DBNamesUnit
2006-3-25 17:00:23 Finalization DBNamesUnit done
2006-3-25 17:00:23 Finalization TotalRecallUnit
2006-3-25 17:00:23 Finalization TotalRecallUnit done
2006-3-25 17:00:23 Finalization RowExportUnit
2006-3-25 17:00:23 Finalization RowExportUnit done
It seems that your license is not quite legal...
Similar threads
