select returns data into sql grid slowly

B

Borden Huey

Member
I'm new to this product. I did a select * from a table with 100,000 rows and it took 163 seconds. When I do the same with SQL Navigator, it takes about 10 seconds. Is there some setting I can change to make the data come back faster?
 
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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).
 
me too, very slowly!!!

SQL: SELECT * FROM std_contract

DEBUG LOG:

2011-08-22 03:35:35 SQLForm Initializing...
2011-08-22 03:35:35 SetConnected starts
2011-08-22 03:35:36 Already connected: check connection
2011-08-22 03:35:36 TOracleQuery $03024190 Start Query.Execute
SQL = select 'x' from dual
2011-08-22 03:35:36 TOracleQuery $03024190 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:36 Using existing connection
2011-08-22 03:35:36 EnableOutput starts
2011-08-22 03:35:36 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
2011-08-22 03:35:36 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.063
2011-08-22 03:35:36 EnableOutput done
2011-08-22 03:35:36 InitStatistics starts
2011-08-22 03:35:36 TStatistics.Init starts
2011-08-22 03:35:36 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2011-08-22 03:35:36 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.125
2011-08-22 03:35:36 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2011-08-22 03:35:36 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.141
2011-08-22 03:35:36 InitStatNames starts
2011-08-22 03:35:36 select name from v$statname order by statistic#
2011-08-22 03:35:36 TOracleQuery $03023950 Start Query.Execute
SQL = select name from v$statname order by statistic#
2011-08-22 03:35:36 TOracleQuery $03023950 End (501 records processed)
Duration = 0.344
2011-08-22 03:35:36 TOracleQuery $03023950 Start Query.Next for up to 501 records
2011-08-22 03:35:36 TOracleQuery $03023950 End (127 records processed)
Duration = 0.062
2011-08-22 03:35:36 628 statistics found
2011-08-22 03:35:36 StatQuery.ReadBuffer = 629
2011-08-22 03:35:36 InitStatNames ends
2011-08-22 03:35:36 TStatistics.Init ends
2011-08-22 03:35:36 InitStatistics ends
2011-08-22 03:35:36 NavigationBookmarks.EnableButtons(Rebuild)
2011-08-22 03:35:36 NavigationBookmarks: Backward=0, Forward=0
2011-08-22 03:35:36 Lock
2011-08-22 03:35:36 UnLock
2011-08-22 03:35:36 SQLForm Executing...
2011-08-22 03:35:36 Lock
2011-08-22 03:35:36 UnLock
2011-08-22 03:35:36 SQLForm Executing...
2011-08-22 03:35:36 TSQLThread SQLThread Suspend ended
2011-08-22 03:35:36 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2011-08-22 03:35:37 TOracleQuery Query End
Duration = 0.063
2011-08-22 03:35:37 TOracleQuery $03023ED0 Start Query.Execute
SQL = SELECT * FROM std_contract
2011-08-22 03:35:37 TOracleQuery $03023ED0 End (100 records processed)
Duration = 0.437
2011-08-22 03:35:37 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM std_contract
2011-08-22 03:35:37 TOracleQuery SQLForm.TestQuery End
Duration = 0.078
2011-08-22 03:35:37 TOracleQuery $03023AB0 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
2011-08-22 03:35:37 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.156
2011-08-22 03:35:37 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:37 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:37 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:37 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:37 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.078
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.079
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:38 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:38 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.062
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (25 records processed)
Duration = 0.063
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Next for up to 25 records
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (14 records processed)
Duration = 0.062
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
2011-08-22 03:35:39 TOracleQuery $03023AB0 End
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
2011-08-22 03:35:39 TOracleQuery $03023AB0 End
Duration = 0.063
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
2011-08-22 03:35:39 TOracleQuery $03023AB0 End
Duration = 0.078
2011-08-22 03:35:39 TOracleQuery $03023AB0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
2011-08-22 03:35:39 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0
2011-08-22 03:35:39 TOracleQuery $03024450 Start Query.Execute
SQL = declare
c integer := 0;
p1 varchar2(500);
p2 varchar2(500);
expr varchar2(500);
dblink varchar2(500);
part1_type integer;
object_number integer;
dp integer;
guard_error exception;
pragma exception_init(guard_error, -16224);
begin
:object_type := null;
:object_owner := null;
:object_name := null;
:sub_object := null;
expr := :part1;
if :part2 is not null then expr := expr || '.' || :part2; end if;
if :part3 is not null then expr := expr || '.' || :part3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => :object_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then :object_type := 'INDEX'; end if;
if part1_type = 2 then :object_type := 'TABLE'; end if;
if part1_type = 4 then :object_type := 'VIEW'; end if;
if part1_type = 5 then :object_type := 'SYNONYM'; end if;
if part1_type = 6 then :object_type := 'SEQUENCE'; end if;
if part1_type = 7 then :object_type := 'PROCEDURE'; end if;
if part1_type = 8 then :object_type := 'FUNCTION'; end if;
if part1_type = 9 then :object_type := 'PACKAGE'; end if;
if part1_type = 12 then :object_type := 'TRIGGER'; end if;
if part1_type = 13 then :object_type := 'TYPE'; end if;
if part1_type = 28 then :object_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then :object_type := 'JAVA CLASS'; end if;
if :object_type is null then
select object_type into :object_type
from sys.dba_objects
where object_id = object_number;
end if;
exception
when guard_error then
raise;
when others then
null;
end;
c := c + 1;
if c > 9 then
dp := instr(expr, '.', -1);
if dp > 0 then
if :sub_object is not null then
:sub_object := '.' || :sub_object;
end if;
:sub_object := upper(substr(expr, dp + 1)) || :sub_object;
expr := substr(expr, 1, dp - 1);
c := 0;
end if;
end if;
exit when (:object_type is not null) or (c > 9);
end loop;
if :object_type is not null then
if p1 is null then
:object_name := p2;
elsif p2 is null then
:object_name := p1;
if :object_name = :part1 and :part2 is not null then
:sub_object := :part2;
end if;
if :object_name = :part2 and :part3 is not null then
:sub_object := :part3;
end if;
else
:object_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if :part2 is null and :part3 is null then
select 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.dba_users u
where u.username = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0 then
select 'ROLE', null, :part1
into :object_type, :object_owner, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if :part2 is null then
select constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.dba_constraints c
where c.constraint_name = :part1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.dba_constraints c
where c.constraint_name = :part2
and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then
:object_type := 'PRIMARY KEY';
end if;
if :object_type = 'U' then
:object_type := 'UNIQUE KEY';
end if;
if :object_type = 'R' then
:object_type := 'FOREIGN KEY';
end if;
if :object_type = 'C' then
:object_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
:PART1 = STD_CONTRACT
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 =
:SUB_OBJECT = Null
:PART3 =
:DEEP = 0
:CUR_SCHEMA = AMIS
2011-08-22 03:35:40 TOracleQuery $03024450 End
Duration = 0.078
2011-08-22 03:35:40 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select null from sys.dba_mviews
where owner = :object_owner
and mview_name = :object_name
:OBJECT_OWNER = CL_CNTR3
:OBJECT_NAME = STD_CONTRACT
2011-08-22 03:35:40 TOracleQuery PLSQLDevForm.DynamicQuery End (0 records processed)
Duration = 0
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
2011-08-22 03:35:40 TOracleQuery $03023AB0 End
Duration = 0.078
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
2011-08-22 03:35:40 TOracleQuery $03023AB0 End
Duration = 0.063
2011-08-22 03:35:40 TOracleQuery $03024450 Start Query.Execute
SQL = select col.*, com.Comments
from sys.dba_tab_columns col,
sys.dba_col_comments com
where col.owner = 'CL_CNTR3'
and col.table_name = 'STD_CONTRACT'
and com.Owner (+) = 'CL_CNTR3'
and com.Table_Name (+) = 'STD_CONTRACT'
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = STD_CONTRACT
:OWNER = CL_CNTR3
2011-08-22 03:35:40 TOracleQuery $03024450 End (1 record processed)
Duration = 0.156
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:40 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:40 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:40 TOracleQuery $03024450 End (1 record processed)
Duration = 0.079
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:40 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:40 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:40 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:40 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:40 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:40 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:40 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:41 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:41 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:41 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:41 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:41 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:41 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:41 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:41 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:41 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:41 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:41 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:41 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:41 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:41 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:41 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:41 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:41 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:41 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:41 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:41 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:42 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:42 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:42 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:42 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:42 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:42 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:42 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:42 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:42 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:42 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:42 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:42 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:42 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:42 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:42 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:42 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:42 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:42 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:42 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:42 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:43 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:43 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:43 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:43 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:43 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:43 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:43 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:43 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:43 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:43 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:43 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:43 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:43 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:43 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:43 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:43 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:43 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:43 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:43 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:43 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:44 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:44 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:44 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:44 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:44 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:44 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:44 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:44 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:44 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:44 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:44 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:44 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:44 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:44 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:44 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:44 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:44 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:44 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:44 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:44 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:45 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:45 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:45 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:45 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:45 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:45 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:45 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:45 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:45 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:45 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:45 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:45 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:45 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:45 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:45 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:45 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:45 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:45 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:45 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:45 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:46 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:46 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:46 TOracleQuery $03024450 End (1 record processed)
Duration = 0.079
2011-08-22 03:35:46 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:46 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:46 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:46 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:46 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:46 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:46 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:46 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:46 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:46 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:46 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:46 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:46 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:46 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:46 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:46 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:46 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:47 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:47 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:47 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:47 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:47 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:47 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:47 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:47 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:47 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:47 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:47 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:47 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:47 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:47 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:47 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:47 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:47 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:47 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:47 TOracleQuery $03024450 End (1 record processed)
Duration = 0.062
2011-08-22 03:35:47 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:48 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.141
2011-08-22 03:35:48 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:48 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:48 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:48 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:48 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:48 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:48 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:48 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:48 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:48 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:48 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:48 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.14
2011-08-22 03:35:48 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:48 TOracleQuery $03024450 End (1 record processed)
Duration = 0.063
2011-08-22 03:35:48 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:48 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:48 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:49 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:49 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:49 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:49 TOracleQuery $03024450 End (1 record processed)
Duration = 0.078
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2011-08-22 03:35:49 TOracleQuery $03023AB0 End (1 record processed)
Duration = 0.125
2011-08-22 03:35:49 TOracleQuery $03024450 Start Query.Next for up to 1 record
2011-08-22 03:35:49 TOracleQuery $03024450 End (0 records processed)
Duration = 0.063
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
2011-08-22 03:35:49 TOracleQuery $03023AB0 End
Duration = 0.063
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
2011-08-22 03:35:49 TOracleQuery $03023AB0 End
Duration = 0.062
2011-08-22 03:35:49 TOracleQuery $03024450 Start Query.Execute
SQL = select t.*, o.*, m.comments
from sys.dba_tables t,
sys.dba_tab_comments m,
sys.dba_objects o
where t.owner = :object_owner
and t.table_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and o.owner (+) = :object_owner
and o.object_name (+) = :object_name
and :object_type is not null
and :sub_object is null
:OBJECT_TYPE = TABLE
:OBJECT_OWNER = CL_CNTR3
:OBJECT_NAME = STD_CONTRACT
:SUB_OBJECT = Null
2011-08-22 03:35:49 TOracleQuery $03024450 End (1 record processed)
Duration = 0.157
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
2011-08-22 03:35:49 TOracleQuery $03023AB0 End
Duration = 0.062
2011-08-22 03:35:49 TOracleQuery $03024450 Start Query.Execute
SQL = select v.*, m.comments
from sys.dba_views v,
sys.dba_tab_comments m
where v.owner = :object_owner
and v.view_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and :object_type is not null
and :sub_object is null
:OBJECT_TYPE = VIEW
:OBJECT_OWNER = CL_CNTR3
:OBJECT_NAME = STD_CONTRACT
:SUB_OBJECT = Null
2011-08-22 03:35:49 TOracleQuery $03024450 End (0 records processed)
Duration = 0.141
2011-08-22 03:35:49 TOracleQuery $03023AB0 Start Query.Describe
SQL = select * from sys.dba_tab_cols where rownum < 1
2011-08-22 03:35:49 TOracleQuery $03023AB0 End
Duration = 0.062
2011-08-22 03:35:49 TOracleQuery $03024450 Start Query.Execute
SQL = select column_name from sys.dba_tab_cols
where owner = :object_owner
and table_name = :object_name
and data_type 'XMLTYPE'
and hidden_column 'YES'
and virtual_column = 'YES'
:OBJECT_OWNER = CL_CNTR3
:OBJECT_NAME = STD_CONTRACT
2011-08-22 03:35:50 TOracleQuery $03024450 End (0 records processed)
Duration = 0.125
2011-08-22 03:35:50 SQLForm Executing... (10)
2011-08-22 03:35:50 SQLForm Executing... (20)
2011-08-22 03:35:50 SQLForm Executing... (30)
2011-08-22 03:35:50 NavigationBookmarks.EnableButtons(Rebuild)
2011-08-22 03:35:50 NavigationBookmarks: Backward=0, Forward=0
2011-08-22 03:35:50 SQLForm Executing... (40)
2011-08-22 03:35:50 SQLForm Executing... (50)
2011-08-22 03:35:50 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2011-08-22 03:35:50 TOracleQuery Query End
Duration = 0.063
2011-08-22 03:35:50 TSQLThread SQLThread Postmessage
2011-08-22 03:35:50 TSQLThread SQLThread Suspend
2011-08-22 03:35:50 TSQLForm.ThreadFinished
2011-08-22 03:35:50 TSQLForm.ThreadFinished: SQLThread.Suspended
2011-08-22 03:35:50 SQLForm 50 rows selected in 13.766 seconds (more...)
2011-08-22 03:35:50 Lock
2011-08-22 03:35:50 UnLock
 
118,040 rows. 230.258 seconds.

PL/SQL Developer
Version 9.0.0.1601
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 4,194,304 kB (3,846,280 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,953,872 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
DebugSQL

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

8/22/2011 2:24:05 PM Application started
8/22/2011 2:24:05 PM InitPreferences
8/22/2011 2:24:05 PM Load C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\default = 0
8/22/2011 2:24:05 PM PreferenceSet.Load C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
8/22/2011 2:24:05 PM PreferenceSet.Load OK
8/22/2011 2:24:05 PM Determine LocalPrefPath
8/22/2011 2:24:05 PM [1]: C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences
8/22/2011 2:24:05 PM LocalPrefPath: C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey
8/22/2011 2:24:05 PM Load C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey = 0
8/22/2011 2:24:05 PM PreferenceSet.Load C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey\default.ini
8/22/2011 2:24:05 PM PreferenceSet.Load OK
8/22/2011 2:24:05 PM PreferenceSet.Load C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey\user.prefs
8/22/2011 2:24:05 PM PreferenceSet.Load OK
8/22/2011 2:24:05 PM InitPreferences end
8/22/2011 2:24:05 PM SortPreferenceSets
8/22/2011 2:24:05 PM - Default huey
8/22/2011 2:24:05 PM - System Default
8/22/2011 2:24:05 PM DoUpdateChildList
8/22/2011 2:24:05 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
8/22/2011 2:24:05 PM ReadString OK
8/22/2011 2:24:05 PM pfReadRegistry: "C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe" "%1"
8/22/2011 2:24:05 PM LoadPreferences
8/22/2011 2:24:05 PM LoadPreferences searching for default
8/22/2011 2:24:05 PM C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey\default.ini
8/22/2011 2:24:05 PM LoadPreferences NewPref := nil
8/22/2011 2:24:05 PM LoadPreferences
8/22/2011 2:24:05 PM LoadPreferences Reading preferences
8/22/2011 2:24:05 PM LoadPreferences ReadPosition
8/22/2011 2:24:05 PM LoadPreferences ToolsBrowserItemClick(nil)
8/22/2011 2:24:05 PM LoadPreferences CreateBrowserFilters...
8/22/2011 2:24:05 PM LoadPreferences Files
8/22/2011 2:24:05 PM LoadPreferences Buttons
8/22/2011 2:24:05 PM LoadPreferences Printer
8/22/2011 2:24:05 PM LoadPreferences FileBrowserFolders
8/22/2011 2:24:05 PM LoadPreferences Connections
8/22/2011 2:24:05 PM LoadPreferences BrowserFolders
8/22/2011 2:24:05 PM LoadPreferences
8/22/2011 2:24:05 PM LoadPreferences end
8/22/2011 2:24:05 PM MacroLibFilename: C:\Program Files (x86)\PLSQL Developer\Macro\huey.emlib
8/22/2011 2:24:10 PM FormCreate Logon.Executed 0
8/22/2011 2:24:10 PM FormCreate SessionChanged
8/22/2011 2:24:10 PM SessionChanged SetDBAViews
8/22/2011 2:24:10 PM SessionChanged Authorizations.Load
8/22/2011 2:24:10 PM SessionChanged EnableAuthorizedMenus
8/22/2011 2:24:10 PM ExecuteConnectScript starts
8/22/2011 2:24:10 PM ExecuteConnectScript ends
8/22/2011 2:24:10 PM SessionChanged LoadRecentObjects
8/22/2011 2:24:10 PM SessionChanged Logoff secondary sessions
8/22/2011 2:24:10 PM SessionChanged EnableChildFunctions
8/22/2011 2:24:10 PM SessionChanged
8/22/2011 2:24:10 PM Lock
8/22/2011 2:24:10 PM UnLock
8/22/2011 2:24:11 PM SortPreferenceSets
8/22/2011 2:24:11 PM - Default huey
8/22/2011 2:24:11 PM - System Default
8/22/2011 2:24:11 PM Lock
8/22/2011 2:24:11 PM UnLock
8/22/2011 2:24:11 PM DoUpdateChildList
8/22/2011 2:24:11 PM FormActivate start
8/22/2011 2:24:11 PM FormActivate end
8/22/2011 2:24:11 PM WMUpdatePopups starts
8/22/2011 2:24:11 PM LoadDesktop starts
8/22/2011 2:24:11 PM DoUpdateChildList
8/22/2011 2:24:11 PM Lock
8/22/2011 2:24:11 PM Lock
8/22/2011 2:24:11 PM UnLock
8/22/2011 2:24:11 PM UnLock
8/22/2011 2:24:11 PM LoadDesktop ends
8/22/2011 2:24:11 PM WMUpdatePopups ends
8/22/2011 2:24:14 PM FormActivate start
8/22/2011 2:24:14 PM FormActivate done
8/22/2011 2:24:24 PM FormActivate start
8/22/2011 2:24:24 PM FormActivate done
8/22/2011 2:24:32 PM TOracleSession $06290990 Start Session.LogOn as erp_owner@cogprd1
8/22/2011 2:24:32 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
8/22/2011 2:24:32 PM TOracleQuery Query End (1 record processed)
Duration = 0.015
8/22/2011 2:24:32 PM TOracleSession $06290990 End
Duration = 0.109
8/22/2011 2:24:32 PM TOracleQuery $062340C0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
8/22/2011 2:24:32 PM TOracleQuery $062340C0 End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleSession $06290C30 Start Session.LogOn as erp_owner@cogprd1
8/22/2011 2:24:32 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
8/22/2011 2:24:32 PM TOracleQuery Query End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleSession $06290C30 End
Duration = 0.063
8/22/2011 2:24:32 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06234220 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = ERP_OWNER
8/22/2011 2:24:32 PM TOracleQuery Query End (5 records processed)
Duration = 0.047
8/22/2011 2:24:32 PM TOracleQuery $06233F60 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)
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
8/22/2011 2:24:32 PM LogonHistorySave start
8/22/2011 2:24:32 PM ChangeUserPref LogonHistory,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref DSA,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref ColumnAssociations,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref ImportAssociations,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref BrowserFilters,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref FileBrowserFolders,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref Connections,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref BrowserFolders,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref SessionQueries,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref ExternalTools,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref Documents,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM ChangeUserPref Reports,
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM TOracleQuery $06234220 End (38 records processed)
Duration = 0.078
8/22/2011 2:24:32 PM ChangeUserPref CurrentConnections,
8/22/2011 2:24:32 PM TOracleQuery $06234220 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from sys.all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
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')
:SCHEMA = ERP_OWNER
8/22/2011 2:24:32 PM ChangeUserPref end
8/22/2011 2:24:32 PM PreferenceSet.Save
8/22/2011 2:24:32 PM PreferenceSet Filename = C:\Users\huey\AppData\Roaming\PLSQL Developer\Preferences\huey\user.prefs
8/22/2011 2:24:32 PM PreferenceSet AltFile = user.prefs
8/22/2011 2:24:32 PM PreferenceSet.Save end
8/22/2011 2:24:32 PM LogonHistorySave end
8/22/2011 2:24:32 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
8/22/2011 2:24:32 PM TOracleQuery Query End (5 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (1 record processed)
Duration = 0.016
8/22/2011 2:24:32 PM SessionChanged SetDBAViews
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Execute
SQL = select null from all_synonyms where 1=0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (0 records processed)
Duration = 0.031
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (0 records processed)
Duration = 0.016
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
8/22/2011 2:24:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0.016
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0.016
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0.015
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:32 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:32 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0.015
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (25 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Next for up to 25 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End (1 record processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.062
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.031
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.406
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.109
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.047
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.031
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.047
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.031
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.015
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.047
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (100 records processed)
Duration = 0.015
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Next for up to 100 records
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.062
8/22/2011 2:24:33 PM TOracleQuery $06233E00 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233E00 End
Duration = 0.063
8/22/2011 2:24:33 PM TOracleQuery $06233E00 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233E00 End
Duration = 0.015
8/22/2011 2:24:33 PM TOracleQuery $06233E00 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233E00 End
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (89 records processed)
Duration = 0.327
8/22/2011 2:24:33 PM TOracleQuery $06234220 Start Query.Execute
SQL =
select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema
or o.owner = 'PUBLIC'
:SCHEMA = ERP_OWNER
8/22/2011 2:24:33 PM TOracleQuery $06234220 End (1 record processed)
Duration = 0.032
8/22/2011 2:24:33 PM TOracleSession $06290C30 Start Session.LogOff
8/22/2011 2:24:33 PM TOracleSession $06290C30 End
Duration = 0
8/22/2011 2:24:33 PM TOracleQuery $06233F60 End
Duration = 0.124
8/22/2011 2:24:33 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.141
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.015
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.078
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.047
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.015
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.015
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.062
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.031
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.015
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.046
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_scheduler_jobs where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.219
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_scheduler_program_args where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_scheduler_job_args where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.015
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_scheduler_wingroup_members where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0.016
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Describe
SQL = select * from sys.dba_scheduler_windows where rownum < 1
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM SessionChanged Authorizations.Load
8/22/2011 2:24:34 PM SessionChanged ApplyPreferences
8/22/2011 2:24:34 PM SortPreferenceSets
8/22/2011 2:24:34 PM - Default huey
8/22/2011 2:24:34 PM - System Default
8/22/2011 2:24:34 PM SessionChanged EnableAuthorizedMenus
8/22/2011 2:24:34 PM ExecuteConnectScript starts
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM ExecuteConnectScript ends
8/22/2011 2:24:34 PM SetSessionAction starts: Primary Session
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Execute
SQL = select null from dual
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End (1 record processed)
Duration = 0
8/22/2011 2:24:34 PM TOracleQuery $06233F60 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
8/22/2011 2:24:34 PM TOracleQuery $06233F60 End
Duration = 0
8/22/2011 2:24:34 PM SetSessionAction ends
8/22/2011 2:24:34 PM SessionChanged LoadRecentObjects
8/22/2011 2:24:34 PM SessionChanged Logoff secondary sessions
8/22/2011 2:24:34 PM SessionChanged EnableChildFunctions
8/22/2011 2:24:34 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\oracle\product\10.2.0\client_1
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_1\bin\oci.dll
8/22/2011 2:24:34 PM Lock
8/22/2011 2:24:34 PM UnLock
8/22/2011 2:25:22 PM Create TSQLForm Start
8/22/2011 2:25:22 PM Create TSQLForm Inherited
8/22/2011 2:25:23 PM TSQLForm.FormCreate Start
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM SQLForm
8/22/2011 2:25:23 PM TSQLForm.FormCreate Finished
8/22/2011 2:25:23 PM Create TSQLForm SetupMainFont
8/22/2011 2:25:23 PM Create TSQLForm Activate
8/22/2011 2:25:23 PM UpdateChildList [timer]
8/22/2011 2:25:23 PM Create TSQLForm Activate done
8/22/2011 2:25:23 PM Create TSQLForm UpdateWindowList
8/22/2011 2:25:23 PM UpdateChildList [timer]
8/22/2011 2:25:23 PM Create TSQLForm Positioning
8/22/2011 2:25:23 PM Create TSQLForm Finished
8/22/2011 2:25:23 PM ExecuteTemplateByName: Default\SQL Window
8/22/2011 2:25:23 PM ExecuteTemplate: C:\Program Files (x86)\PLSQL Developer\Template\Default\SQL Window.tpl
8/22/2011 2:25:23 PM Path: C:\Program Files (x86)\PLSQL Developer\Template\Default\SQL Window.tpl
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM NavigationBookmarks.EnableButtons(Rebuild)
8/22/2011 2:25:23 PM NavigationBookmarks: Backward=0, Forward=0
8/22/2011 2:25:23 PM DoUpdateChildList
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM Lock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:23 PM UnLock
8/22/2011 2:25:24 PM Lock
8/22/2011 2:25:24 PM UnLock
8/22/2011 2:25:29 PM TOracleQuery $061F2FF0 Start Query.Execute
SQL = select 'x' from dual
8/22/2011 2:25:29 PM TOracleQuery $061F2FF0 End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM SQLForm Initializing...
8/22/2011 2:25:32 PM SetConnected starts
8/22/2011 2:25:32 PM SetConnected: Connect starts
8/22/2011 2:25:32 PM TOracleSession $06293630 Start Session.LogOn as erp_owner@cogprd1
8/22/2011 2:25:32 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
8/22/2011 2:25:32 PM TOracleQuery Query End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM TOracleSession $06293630 End
Duration = 0.078
8/22/2011 2:25:32 PM SetConnected: (Dis)connect ends
8/22/2011 2:25:32 PM SetSessionAction starts: SQL Window - New
8/22/2011 2:25:32 PM TOracleQuery $061F2910 Start Query.Execute
SQL = select null from dual
8/22/2011 2:25:32 PM TOracleQuery $061F2910 End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
8/22/2011 2:25:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
8/22/2011 2:25:32 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM TOracleQuery $061F2910 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
8/22/2011 2:25:32 PM TOracleQuery $061F2910 End
Duration = 0
8/22/2011 2:25:32 PM SetSessionAction ends
8/22/2011 2:25:32 PM ExecuteConnectScript starts
8/22/2011 2:25:32 PM TOracleQuery $061F2910 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
8/22/2011 2:25:32 PM TOracleQuery $061F2910 End
Duration = 0
8/22/2011 2:25:32 PM TOracleQuery $061F2910 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
8/22/2011 2:25:32 PM TOracleQuery $061F2910 End
Duration = 0
8/22/2011 2:25:32 PM ExecuteConnectScript ends
8/22/2011 2:25:32 PM TOracleQuery $061F2910 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
8/22/2011 2:25:32 PM TOracleQuery $061F2910 End (1 record processed)
Duration = 0
8/22/2011 2:25:32 PM EnableOutput starts
8/22/2011 2:25:32 PM 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
8/22/2011 2:25:32 PM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.015
8/22/2011 2:25:32 PM EnableOutput done
8/22/2011 2:25:32 PM InitStatistics starts
8/22/2011 2:25:32 PM TStatistics.Init starts
8/22/2011 2:25:32 PM InitStatNames starts
8/22/2011 2:25:32 PM select name from v$statname order by statistic#
8/22/2011 2:25:32 PM TOracleQuery $062339E0 Start Query.Execute
SQL = select name from v$statname order by statistic#
8/22/2011 2:25:33 PM TOracleQuery $062339E0 End (380 records processed)
Duration = 0.031
8/22/2011 2:25:33 PM 380 statistics found
8/22/2011 2:25:33 PM StatQuery.ReadBuffer = 381
8/22/2011 2:25:33 PM InitStatNames ends
8/22/2011 2:25:33 PM StatQuery.Describe starts
8/22/2011 2:25:33 PM TOracleQuery $061F2910 Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
8/22/2011 2:25:33 PM TOracleQuery $061F2910 End
Duration = 0.016
8/22/2011 2:25:33 PM StatQuery.Describe ends
8/22/2011 2:25:33 PM TStatistics.Init ends
8/22/2011 2:25:33 PM StartValues: StatQuery.ReadBuffer = 381
8/22/2011 2:25:33 PM StartValues: StatQuery.ReadBuffer set to 381
8/22/2011 2:25:33 PM TOracleQuery $061F2910 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 847
8/22/2011 2:25:33 PM TOracleQuery $061F2910 End (380 records processed)
Duration = 0
8/22/2011 2:25:33 PM InitStatistics ends
8/22/2011 2:25:33 PM SQL Window Height = 540
8/22/2011 2:25:33 PM SQL Grid Height = 461
8/22/2011 2:25:33 PM SQL Panel Height = 79
8/22/2011 2:25:33 PM NavigationBookmarks.EnableButtons(Rebuild)
8/22/2011 2:25:33 PM NavigationBookmarks: Backward=0, Forward=0
8/22/2011 2:25:33 PM Lock
8/22/2011 2:25:33 PM UnLock
8/22/2011 2:25:33 PM SQLForm Executing...
8/22/2011 2:25:33 PM Lock
8/22/2011 2:25:33 PM UnLock
8/22/2011 2:25:33 PM SQLForm Executing...
8/22/2011 2:25:33 PM TSQLThread SQLThread.Execute
8/22/2011 2:25:33 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
8/22/2011 2:25:33 PM TOracleQuery Query End
Duration = 0
8/22/2011 2:25:33 PM TOracleQuery $061F3150 Start Query.Execute
SQL = select * from fi_out_wbs
8/22/2011 2:25:33 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.031
8/22/2011 2:25:33 PM TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM fi_out_wbs
8/22/2011 2:25:33 PM TOracleQuery SQLForm.TestQuery End
Duration = 0.016
8/22/2011 2:25:33 PM SQLForm Executing... (10)
8/22/2011 2:25:33 PM SQLForm Executing... (20)
8/22/2011 2:25:33 PM SQLForm Executing... (30)
8/22/2011 2:25:33 PM SQLForm Executing... (40)
8/22/2011 2:25:33 PM SQLForm Executing... (50)
8/22/2011 2:25:33 PM SQLForm Executing... (60)
8/22/2011 2:25:33 PM SQLForm Executing... (70)
8/22/2011 2:25:33 PM SQLForm Executing... (80)
8/22/2011 2:25:33 PM SQLForm Executing... (90)
8/22/2011 2:25:33 PM SQLForm Executing... (100)
8/22/2011 2:25:33 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:33 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:33 PM SQLForm Executing... (110)
8/22/2011 2:25:33 PM SQLForm Executing... (120)
8/22/2011 2:25:33 PM SQLForm Executing... (130)
8/22/2011 2:25:33 PM SQLForm Executing... (140)
8/22/2011 2:25:33 PM SQLForm Executing... (150)
8/22/2011 2:25:33 PM SQLForm Executing... (160)
8/22/2011 2:25:33 PM SQLForm Executing... (170)
8/22/2011 2:25:33 PM SQLForm Executing... (180)
8/22/2011 2:25:33 PM SQLForm Executing... (190)
8/22/2011 2:25:33 PM SQLForm Executing... (200)
8/22/2011 2:25:33 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:33 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:33 PM SQLForm Executing... (210)
8/22/2011 2:25:33 PM SQLForm Executing... (220)
8/22/2011 2:25:33 PM SQLForm Executing... (230)
8/22/2011 2:25:33 PM SQLForm Executing... (240)
8/22/2011 2:25:33 PM SQLForm Executing... (250)
8/22/2011 2:25:33 PM SQLForm Executing... (260)
8/22/2011 2:25:33 PM SQLForm Executing... (270)
8/22/2011 2:25:33 PM SQLForm Executing... (280)
8/22/2011 2:25:33 PM SQLForm Executing... (290)
8/22/2011 2:25:33 PM SQLForm Executing... (300)
8/22/2011 2:25:33 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:33 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:33 PM SQLForm Executing... (310)
8/22/2011 2:25:33 PM SQLForm Executing... (320)
8/22/2011 2:25:33 PM SQLForm Executing... (330)
8/22/2011 2:25:33 PM SQLForm Executing... (340)
8/22/2011 2:25:33 PM SQLForm Executing... (350)
8/22/2011 2:25:33 PM SQLForm Executing... (360)
8/22/2011 2:25:33 PM SQLForm Executing... (370)
8/22/2011 2:25:33 PM SQLForm Executing... (380)
8/22/2011 2:25:33 PM SQLForm Executing... (390)
8/22/2011 2:25:33 PM SQLForm Executing... (400)
8/22/2011 2:25:33 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:33 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:33 PM SQLForm Executing... (410)
8/22/2011 2:25:33 PM SQLForm Executing... (420)
8/22/2011 2:25:33 PM SQLForm Executing... (430)
8/22/2011 2:25:34 PM SQLForm Executing... (440)
8/22/2011 2:25:34 PM SQLForm Executing... (450)
8/22/2011 2:25:34 PM SQLForm Executing... (460)
8/22/2011 2:25:34 PM SQLForm Executing... (470)
8/22/2011 2:25:34 PM SQLForm Executing... (480)
8/22/2011 2:25:34 PM SQLForm Executing... (490)
8/22/2011 2:25:34 PM SQLForm Executing... (500)
8/22/2011 2:25:34 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:34 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.016
8/22/2011 2:25:34 PM SQLForm Executing... (510)
8/22/2011 2:25:34 PM SQLForm Executing... (520)
8/22/2011 2:25:34 PM SQLForm Executing... (530)
8/22/2011 2:25:34 PM SQLForm Executing... (540)
8/22/2011 2:25:34 PM SQLForm Executing... (550)
8/22/2011 2:25:34 PM SQLForm Executing... (560)
8/22/2011 2:25:34 PM SQLForm Executing... (570)
8/22/2011 2:25:34 PM SQLForm Executing... (580)
8/22/2011 2:25:34 PM SQLForm Executing... (590)
8/22/2011 2:25:34 PM SQLForm Executing... (600)
8/22/2011 2:25:34 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:34 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:34 PM SQLForm Executing... (610)
8/22/2011 2:25:34 PM SQLForm Executing... (620)
8/22/2011 2:25:34 PM SQLForm Executing... (630)
8/22/2011 2:25:34 PM SQLForm Executing... (640)
8/22/2011 2:25:34 PM SQLForm Executing... (650)
8/22/2011 2:25:34 PM SQLForm Executing... (660)
8/22/2011 2:25:34 PM SQLForm Executing... (670)
8/22/2011 2:25:34 PM SQLForm Executing... (680)
8/22/2011 2:25:34 PM SQLForm Executing... (690)
8/22/2011 2:25:34 PM SQLForm Executing... (700)
8/22/2011 2:25:34 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:34 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:34 PM SQLForm Executing... (710)
8/22/2011 2:25:34 PM SQLForm Executing... (720)
8/22/2011 2:25:34 PM SQLForm Executing... (730)
8/22/2011 2:25:34 PM SQLForm Executing... (740)
8/22/2011 2:25:34 PM SQLForm Executing... (750)
8/22/2011 2:25:34 PM SQLForm Executing... (760)
8/22/2011 2:25:34 PM SQLForm Executing... (770)
8/22/2011 2:25:34 PM SQLForm Executing... (780)
8/22/2011 2:25:34 PM SQLForm Executing... (790)
8/22/2011 2:25:34 PM SQLForm Executing... (800)
8/22/2011 2:25:34 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:34 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:34 PM SQLForm Executing... (810)
8/22/2011 2:25:34 PM SQLForm Executing... (820)
8/22/2011 2:25:34 PM SQLForm Executing... (830)
8/22/2011 2:25:34 PM SQLForm Executing... (840)
8/22/2011 2:25:34 PM SQLForm Executing... (850)
8/22/2011 2:25:34 PM SQLForm Executing... (860)
8/22/2011 2:25:34 PM SQLForm Executing... (870)
8/22/2011 2:25:34 PM SQLForm Executing... (880)
8/22/2011 2:25:34 PM SQLForm Executing... (890)
8/22/2011 2:25:34 PM SQLForm Executing... (900)
8/22/2011 2:25:34 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:34 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:34 PM SQLForm Executing... (910)
8/22/2011 2:25:34 PM SQLForm Executing... (920)
8/22/2011 2:25:34 PM SQLForm Executing... (930)
8/22/2011 2:25:34 PM SQLForm Executing... (940)
8/22/2011 2:25:34 PM SQLForm Executing... (950)
8/22/2011 2:25:35 PM SQLForm Executing... (960)
8/22/2011 2:25:35 PM SQLForm Executing... (970)
8/22/2011 2:25:35 PM SQLForm Executing... (980)
8/22/2011 2:25:35 PM SQLForm Executing... (990)
8/22/2011 2:25:35 PM SQLForm Executing... (1000)
8/22/2011 2:25:35 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:35 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:35 PM SQLForm Executing... (1010)
8/22/2011 2:25:35 PM SQLForm Executing... (1020)
8/22/2011 2:25:35 PM SQLForm Executing... (1030)
8/22/2011 2:25:35 PM SQLForm Executing... (1040)
8/22/2011 2:25:35 PM SQLForm Executing... (1050)
8/22/2011 2:25:35 PM SQLForm Executing... (1060)
8/22/2011 2:25:35 PM SQLForm Executing... (1070)
8/22/2011 2:25:35 PM SQLForm Executing... (1080)
8/22/2011 2:25:35 PM SQLForm Executing... (1090)
8/22/2011 2:25:35 PM SQLForm Executing... (1100)
8/22/2011 2:25:35 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:35 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:35 PM SQLForm Executing... (1110)
8/22/2011 2:25:35 PM SQLForm Executing... (1120)
8/22/2011 2:25:35 PM SQLForm Executing... (1130)
8/22/2011 2:25:35 PM SQLForm Executing... (1140)
8/22/2011 2:25:35 PM SQLForm Executing... (1150)
8/22/2011 2:25:35 PM SQLForm Executing... (1160)
8/22/2011 2:25:35 PM SQLForm Executing... (1170)
8/22/2011 2:25:35 PM SQLForm Executing... (1180)
8/22/2011 2:25:35 PM SQLForm Executing... (1190)
8/22/2011 2:25:35 PM SQLForm Executing... (1200)
8/22/2011 2:25:35 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:35 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.031
8/22/2011 2:25:35 PM SQLForm Executing... (1210)
8/22/2011 2:25:35 PM SQLForm Executing... (1220)
8/22/2011 2:25:35 PM SQLForm Executing... (1230)
8/22/2011 2:25:35 PM SQLForm Executing... (1240)
8/22/2011 2:25:35 PM SQLForm Executing... (1250)
8/22/2011 2:25:35 PM SQLForm Executing... (1260)
8/22/2011 2:25:35 PM SQLForm Executing... (1270)
8/22/2011 2:25:35 PM SQLForm Executing... (1280)
8/22/2011 2:25:35 PM SQLForm Executing... (1290)
8/22/2011 2:25:35 PM SQLForm Executing... (1300)
8/22/2011 2:25:35 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:35 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:35 PM SQLForm Executing... (1310)
8/22/2011 2:25:35 PM SQLForm Executing... (1320)
8/22/2011 2:25:35 PM SQLForm Executing... (1330)
8/22/2011 2:25:35 PM SQLForm Executing... (1340)
8/22/2011 2:25:35 PM SQLForm Executing... (1350)
8/22/2011 2:25:35 PM SQLForm Executing... (1360)
8/22/2011 2:25:35 PM SQLForm Executing... (1370)
8/22/2011 2:25:35 PM SQLForm Executing... (1380)
8/22/2011 2:25:35 PM SQLForm Executing... (1390)
8/22/2011 2:25:35 PM SQLForm Executing... (1400)
8/22/2011 2:25:35 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:35 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:35 PM SQLForm Executing... (1410)
8/22/2011 2:25:35 PM SQLForm Executing... (1420)
8/22/2011 2:25:35 PM SQLForm Executing... (1430)
8/22/2011 2:25:35 PM SQLForm Executing... (1440)
8/22/2011 2:25:35 PM SQLForm Executing... (1450)
8/22/2011 2:25:35 PM SQLForm Executing... (1460)
8/22/2011 2:25:36 PM SQLForm Executing... (1470)
8/22/2011 2:25:36 PM SQLForm Executing... (1480)
8/22/2011 2:25:36 PM SQLForm Executing... (1490)
8/22/2011 2:25:36 PM SQLForm Executing... (1500)
8/22/2011 2:25:36 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:36 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.016
8/22/2011 2:25:36 PM SQLForm Executing... (1510)
8/22/2011 2:25:36 PM SQLForm Executing... (1520)
8/22/2011 2:25:36 PM SQLForm Executing... (1530)
8/22/2011 2:25:36 PM SQLForm Executing... (1540)
8/22/2011 2:25:36 PM SQLForm Executing... (1550)
8/22/2011 2:25:36 PM SQLForm Executing... (1560)
8/22/2011 2:25:36 PM SQLForm Executing... (1570)
8/22/2011 2:25:36 PM SQLForm Executing... (1580)
8/22/2011 2:25:36 PM SQLForm Executing... (1590)
8/22/2011 2:25:36 PM SQLForm Executing... (1600)
8/22/2011 2:25:36 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:36 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:36 PM SQLForm Executing... (1610)
8/22/2011 2:25:36 PM SQLForm Executing... (1620)
8/22/2011 2:25:36 PM SQLForm Executing... (1630)
8/22/2011 2:25:36 PM SQLForm Executing... (1640)
8/22/2011 2:25:36 PM SQLForm Executing... (1650)
8/22/2011 2:25:36 PM SQLForm Executing... (1660)
8/22/2011 2:25:36 PM SQLForm Executing... (1670)
8/22/2011 2:25:36 PM SQLForm Executing... (1680)
8/22/2011 2:25:36 PM SQLForm Executing... (1690)
8/22/2011 2:25:36 PM SQLForm Executing... (1700)
8/22/2011 2:25:36 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:36 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.016
8/22/2011 2:25:36 PM SQLForm Executing... (1710)
8/22/2011 2:25:36 PM SQLForm Executing... (1720)
8/22/2011 2:25:36 PM SQLForm Executing... (1730)
8/22/2011 2:25:36 PM SQLForm Executing... (1740)
8/22/2011 2:25:36 PM SQLForm Executing... (1750)
8/22/2011 2:25:36 PM SQLForm Executing... (1760)
8/22/2011 2:25:36 PM SQLForm Executing... (1770)
8/22/2011 2:25:36 PM SQLForm Executing... (1780)
8/22/2011 2:25:36 PM SQLForm Executing... (1790)
8/22/2011 2:25:36 PM SQLForm Executing... (1800)
8/22/2011 2:25:36 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:36 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.016
8/22/2011 2:25:36 PM SQLForm Executing... (1810)
8/22/2011 2:25:36 PM SQLForm Executing... (1820)
8/22/2011 2:25:36 PM SQLForm Executing... (1830)
8/22/2011 2:25:36 PM SQLForm Executing... (1840)
8/22/2011 2:25:36 PM SQLForm Executing... (1850)
8/22/2011 2:25:36 PM SQLForm Executing... (1860)
8/22/2011 2:25:36 PM SQLForm Executing... (1870)
8/22/2011 2:25:36 PM SQLForm Executing... (1880)
8/22/2011 2:25:36 PM SQLForm Executing... (1890)
8/22/2011 2:25:36 PM SQLForm Executing... (1900)
8/22/2011 2:25:36 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:36 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:36 PM SQLForm Executing... (1910)
8/22/2011 2:25:36 PM SQLForm Executing... (1920)
8/22/2011 2:25:36 PM SQLForm Executing... (1930)
8/22/2011 2:25:36 PM SQLForm Executing... (1940)
8/22/2011 2:25:36 PM SQLForm Executing... (1950)
8/22/2011 2:25:36 PM SQLForm Executing... (1960)
8/22/2011 2:25:36 PM SQLForm Executing... (1970)
8/22/2011 2:25:37 PM SQLForm Executing... (1980)
8/22/2011 2:25:37 PM SQLForm Executing... (1990)
8/22/2011 2:25:37 PM SQLForm Executing... (2000)
8/22/2011 2:25:37 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:37 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:37 PM SQLForm Executing... (2010)
8/22/2011 2:25:37 PM SQLForm Executing... (2020)
8/22/2011 2:25:37 PM SQLForm Executing... (2030)
8/22/2011 2:25:37 PM SQLForm Executing... (2040)
8/22/2011 2:25:37 PM SQLForm Executing... (2050)
8/22/2011 2:25:37 PM SQLForm Executing... (2060)
8/22/2011 2:25:37 PM SQLForm Executing... (2070)
8/22/2011 2:25:37 PM SQLForm Executing... (2080)
8/22/2011 2:25:37 PM SQLForm Executing... (2090)
8/22/2011 2:25:37 PM SQLForm Executing... (2100)
8/22/2011 2:25:37 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:37 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:37 PM SQLForm Executing... (2110)
8/22/2011 2:25:37 PM SQLForm Executing... (2120)
8/22/2011 2:25:37 PM SQLForm Executing... (2130)
8/22/2011 2:25:37 PM SQLForm Executing... (2140)
8/22/2011 2:25:37 PM SQLForm Executing... (2150)
8/22/2011 2:25:37 PM SQLForm Executing... (2160)
8/22/2011 2:25:37 PM SQLForm Executing... (2170)
8/22/2011 2:25:37 PM SQLForm Executing... (2180)
8/22/2011 2:25:37 PM SQLForm Executing... (2190)
8/22/2011 2:25:37 PM SQLForm Executing... (2200)
8/22/2011 2:25:37 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:37 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.032
8/22/2011 2:25:37 PM SQLForm Executing... (2210)
8/22/2011 2:25:37 PM SQLForm Executing... (2220)
8/22/2011 2:25:37 PM SQLForm Executing... (2230)
8/22/2011 2:25:37 PM SQLForm Executing... (2240)
8/22/2011 2:25:37 PM SQLForm Executing... (2250)
8/22/2011 2:25:37 PM SQLForm Executing... (2260)
8/22/2011 2:25:37 PM SQLForm Executing... (2270)
8/22/2011 2:25:37 PM SQLForm Executing... (2280)
8/22/2011 2:25:37 PM SQLForm Executing... (2290)
8/22/2011 2:25:37 PM SQLForm Executing... (2300)
8/22/2011 2:25:37 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:37 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:37 PM SQLForm Executing... (2310)
8/22/2011 2:25:37 PM SQLForm Executing... (2320)
8/22/2011 2:25:37 PM SQLForm Executing... (2330)
8/22/2011 2:25:37 PM SQLForm Executing... (2340)
8/22/2011 2:25:37 PM SQLForm Executing... (2350)
8/22/2011 2:25:37 PM SQLForm Executing... (2360)
8/22/2011 2:25:37 PM SQLForm Executing... (2370)
8/22/2011 2:25:37 PM SQLForm Executing... (2380)
8/22/2011 2:25:37 PM SQLForm Executing... (2390)
8/22/2011 2:25:37 PM SQLForm Executing... (2400)
8/22/2011 2:25:37 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:37 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:37 PM SQLForm Executing... (2410)
8/22/2011 2:25:37 PM SQLForm Executing... (2420)
8/22/2011 2:25:37 PM SQLForm Executing... (2430)
8/22/2011 2:25:37 PM SQLForm Executing... (2440)
8/22/2011 2:25:37 PM SQLForm Executing... (2450)
8/22/2011 2:25:37 PM SQLForm Executing... (2460)
8/22/2011 2:25:37 PM SQLForm Executing... (2470)
8/22/2011 2:25:38 PM SQLForm Executing... (2480)
8/22/2011 2:25:38 PM SQLForm Executing... (2490)
8/22/2011 2:25:38 PM SQLForm Executing... (2500)
8/22/2011 2:25:38 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:38 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:38 PM SQLForm Executing... (2510)
8/22/2011 2:25:38 PM SQLForm Executing... (2520)
8/22/2011 2:25:38 PM SQLForm Executing... (2530)
8/22/2011 2:25:38 PM SQLForm Executing... (2540)
8/22/2011 2:25:38 PM SQLForm Executing... (2550)
8/22/2011 2:25:38 PM SQLForm Executing... (2560)
8/22/2011 2:25:38 PM SQLForm Executing... (2570)
8/22/2011 2:25:38 PM SQLForm Executing... (2580)
8/22/2011 2:25:38 PM SQLForm Executing... (2590)
8/22/2011 2:25:38 PM SQLForm Executing... (2600)
8/22/2011 2:25:38 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:38 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:38 PM SQLForm Executing... (2610)
8/22/2011 2:25:38 PM SQLForm Executing... (2620)
8/22/2011 2:25:38 PM SQLForm Executing... (2630)
8/22/2011 2:25:38 PM SQLForm Executing... (2640)
8/22/2011 2:25:38 PM SQLForm Executing... (2650)
8/22/2011 2:25:38 PM SQLForm Executing... (2660)
8/22/2011 2:25:38 PM SQLForm Executing... (2670)
8/22/2011 2:25:38 PM SQLForm Executing... (2680)
8/22/2011 2:25:38 PM SQLForm Executing... (2690)
8/22/2011 2:25:38 PM SQLForm Executing... (2700)
8/22/2011 2:25:38 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:38 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:38 PM SQLForm Executing... (2710)
8/22/2011 2:25:38 PM SQLForm Executing... (2720)
8/22/2011 2:25:38 PM SQLForm Executing... (2730)
8/22/2011 2:25:38 PM SQLForm Executing... (2740)
8/22/2011 2:25:38 PM SQLForm Executing... (2750)
8/22/2011 2:25:38 PM SQLForm Executing... (2760)
8/22/2011 2:25:38 PM SQLForm Executing... (2770)
8/22/2011 2:25:38 PM SQLForm Executing... (2780)
8/22/2011 2:25:38 PM SQLForm Executing... (2790)
8/22/2011 2:25:38 PM SQLForm Executing... (2800)
8/22/2011 2:25:38 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:38 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.015
8/22/2011 2:25:38 PM SQLForm Executing... (2810)
8/22/2011 2:25:38 PM SQLForm Executing... (2820)
8/22/2011 2:25:38 PM SQLForm Executing... (2830)
8/22/2011 2:25:38 PM SQLForm Executing... (2840)
8/22/2011 2:25:38 PM SQLForm Executing... (2850)
8/22/2011 2:25:38 PM SQLForm Executing... (2860)
8/22/2011 2:25:38 PM SQLForm Executing... (2870)
8/22/2011 2:25:38 PM SQLForm Executing... (2880)
8/22/2011 2:25:38 PM SQLForm Executing... (2890)
8/22/2011 2:25:38 PM SQLForm Executing... (2900)
8/22/2011 2:25:38 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:38 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.047
8/22/2011 2:25:38 PM SQLForm Executing... (2910)
8/22/2011 2:25:38 PM SQLForm Executing... (2920)
8/22/2011 2:25:38 PM SQLForm Executing... (2930)
8/22/2011 2:25:38 PM SQLForm Executing... (2940)
8/22/2011 2:25:38 PM SQLForm Executing... (2950)
8/22/2011 2:25:38 PM SQLForm Executing... (2960)
8/22/2011 2:25:38 PM SQLForm Executing... (2970)
8/22/2011 2:25:39 PM SQLForm Executing... (2980)
8/22/2011 2:25:39 PM SQLForm Executing... (2990)
8/22/2011 2:25:39 PM SQLForm Executing... (3000)
8/22/2011 2:25:39 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:39 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:39 PM SQLForm Executing... (3010)
8/22/2011 2:25:39 PM SQLForm Executing... (3020)
8/22/2011 2:25:39 PM SQLForm Executing... (3030)
8/22/2011 2:25:39 PM SQLForm Executing... (3040)
8/22/2011 2:25:39 PM SQLForm Executing... (3050)
8/22/2011 2:25:39 PM SQLForm Executing... (3060)
8/22/2011 2:25:39 PM SQLForm Executing... (3070)
8/22/2011 2:25:39 PM SQLForm Executing... (3080)
8/22/2011 2:25:39 PM SQLForm Executing... (3090)
8/22/2011 2:25:39 PM SQLForm Executing... (3100)
8/22/2011 2:25:39 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:39 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0.016
8/22/2011 2:25:39 PM SQLForm Executing... (3110)
8/22/2011 2:25:39 PM SQLForm Executing... (3120)
8/22/2011 2:25:39 PM SQLForm Executing... (3130)
8/22/2011 2:25:39 PM SQLForm Executing... (3140)
8/22/2011 2:25:39 PM SQLForm Executing... (3150)
8/22/2011 2:25:39 PM SQLForm Executing... (3160)
8/22/2011 2:25:39 PM SQLForm Executing... (3170)
8/22/2011 2:25:39 PM SQLForm Executing... (3180)
8/22/2011 2:25:39 PM SQLForm Executing... (3190)
8/22/2011 2:25:39 PM SQLForm Executing... (3200)
8/22/2011 2:25:39 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:39 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:39 PM SQLForm Executing... (3210)
8/22/2011 2:25:39 PM SQLForm Executing... (3220)
8/22/2011 2:25:39 PM SQLForm Executing... (3230)
8/22/2011 2:25:39 PM SQLForm Executing... (3240)
8/22/2011 2:25:39 PM SQLForm Executing... (3250)
8/22/2011 2:25:39 PM SQLForm Executing... (3260)
8/22/2011 2:25:39 PM SQLForm Executing... (3270)
8/22/2011 2:25:39 PM SQLForm Executing... (3280)
8/22/2011 2:25:39 PM SQLForm Executing... (3290)
8/22/2011 2:25:39 PM SQLForm Executing... (3300)
8/22/2011 2:25:39 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:39 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:39 PM SQLForm Executing... (3310)
8/22/2011 2:25:39 PM SQLForm Executing... (3320)
8/22/2011 2:25:39 PM SQLForm Executing... (3330)
8/22/2011 2:25:39 PM SQLForm Executing... (3340)
8/22/2011 2:25:39 PM SQLForm Executing... (3350)
8/22/2011 2:25:39 PM SQLForm Executing... (3360)
8/22/2011 2:25:39 PM SQLForm Executing... (3370)
8/22/2011 2:25:39 PM SQLForm Executing... (3380)
8/22/2011 2:25:39 PM SQLForm Executing... (3390)
8/22/2011 2:25:39 PM SQLForm Executing... (3400)
8/22/2011 2:25:39 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:39 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:39 PM SQLForm Executing... (3410)
8/22/2011 2:25:39 PM SQLForm Executing... (3420)
8/22/2011 2:25:39 PM SQLForm Executing... (3430)
8/22/2011 2:25:39 PM SQLForm Executing... (3440)
8/22/2011 2:25:39 PM SQLForm Executing... (3450)
8/22/2011 2:25:39 PM SQLForm Executing... (3460)
8/22/2011 2:25:39 PM SQLForm Executing... (3470)
8/22/2011 2:25:39 PM SQLForm Executing... (3480)
8/22/2011 2:25:39 PM SQLForm Executing... (3490)
8/22/2011 2:25:40 PM SQLForm Executing... (3500)
8/22/2011 2:25:40 PM TOracleQuery $061F3150 Start Query.Next for up to 100 records
8/22/2011 2:25:40 PM TOracleQuery $061F3150 End (100 records processed)
Duration = 0
8/22/2011 2:25:40 PM SQLForm Executing... (3510)
8/22/2011 2:25:40 PM SQLForm Executing... (3520)
8/22/2011 2:25:40 PM SQLForm Executing... (3530)
8/22/2011 2:25:40 PM SQLForm Exec
 
You must log in or register to reply here.

Similar threads

Z
  • Discussion Discussion
Increase Speed when multiline editing in SQL file
Replies
3
Views
442
D.Wenzel
D
J
  • Discussion Discussion
Limitation on Export data as SQL file
Replies
1
Views
1K
Marco Kalter
Marco Kalter
G
  • Discussion Discussion
dbms_output?
Replies
1
Views
515
Marco Kalter
Marco Kalter
A
  • Discussion Discussion
Problem with horizontal scrollbar in SQL-Grid when switching to Single-Record-View and then refresh
Replies
1
Views
519
Marco Kalter
Marco Kalter
S
  • Discussion Discussion
Performance v15
Replies
4
Views
2K
Marco Kalter
Marco Kalter
Back
Top