Table detailed SQL activity no app
From:
2013/01/15 04:00:00
To:
2013/01/16 04:00:00
AIX-11g
ORA11 on lpar26p682e_pub
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000159TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 12:44:17PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
000239TOMToad.exeWORKGROUP\BLUECORE2172.29.149.10011
2013/01/15 16:03:37SELECTSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:03:37ERRORSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:03:52SELECTSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:03:52ERRORSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:04:08SELECTSELECT * FROM "HRAPP"."SALARIES"
WHERE
  "ROWID" = :"Old_ROWID"
FOR UPDATE NOWAIT
2013/01/15 16:04:31UPDATEUPDATE "HRAPP"."SALARIES"
SET
  "SALARY" = :"SALARY", "BONUS" = :"BONUS"
WHERE
  "ROWID" = :"Old_ROWID"
2013/01/15 16:04:31SELECTSELECT "EMP" AS "_1", "SALARY" AS "_2", "BONUS" AS "_3" FROM "HRAPP"."SALARIES"
WHERE
  "ROWID" = :"Old_ROWID"
2013/01/15 16:05:46ERRORselecet * from HRAPP.SALARIES s, HRAPP.EMPLOYEES e where S.EMP = E.ID;
2013/01/15 16:06:11SELECTselect s.*,e.* from HRAPP.SALARIES s, HRAPP.EMPLOYEES e where S.EMP = E.ID
2013/01/15 16:06:02ERRORselecet s.*,e.* from HRAPP.SALARIES s, HRAPP.EMPLOYEES e where S.EMP = E.ID;
2013/01/15 16:06:11ERRORselect s.*,e.* from HRAPP.SALARIES s, HRAPP.EMPLOYEES e where S.EMP = E.ID
000253TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 16:23:16PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'create table mycopy as select * from hrapp.salaries';
  execute immediate(s);
end;
000270TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:05:14CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
000273TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:07:13CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
000274TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:11:02CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
000279TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:24:53CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
000287TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:39:06CREATE TRIGGERcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
000292TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:47:27PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000425TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 12:54:46PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
000535TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 16:09:07SELECTSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:09:12SELECTSELECT * FROM "HRAPP"."SALARIES"
WHERE
  "ROWID" = :"Old_ROWID"
FOR UPDATE NOWAIT
2013/01/15 16:09:38UPDATEUPDATE "HRAPP"."SALARIES"
SET
  "SALARY" = :"SALARY", "BONUS" = :"BONUS"
WHERE
  "ROWID" = :"Old_ROWID"
2013/01/15 16:09:38SELECTSELECT "EMP" AS "_1", "SALARY" AS "_2", "BONUS" AS "_3" FROM "HRAPP"."SALARIES"
WHERE
  "ROWID" = :"Old_ROWID"
000547TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:24:25PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'create table mycopy as select * from hrapp.salaries';
  execute immediate(s);
end;
000575TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:06:18INTERNALcreate or replace view myview as select * from hrapp.salaries
000576TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:08:08ERRORcreate materialized view myview as select * from hrapp.salaries
000580TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:12:03INTERNALcreate synonym mysyn for hrapp.salaries
000583TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:25:48INTERNALcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
000591TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:42:17INTERNALcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
000595TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:50:23PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000991TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 13:03:02PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
001471TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 16:11:44SELECTSELECT  ROWID, ID, CUSTOMER, CARD_NO, 
   EXP_MON, EXP_YEAR, ADDRESS, 
   ZIP
FROM CCAPP.CARDS
2013/01/15 16:11:44ERRORSELECT  ROWID, ID, CUSTOMER, CARD_NO, 
   EXP_MON, EXP_YEAR, ADDRESS, 
   ZIP
FROM CCAPP.CARDS
2013/01/15 16:13:10SELECTselect CCAPP.CARDS.CARD_NO, CCAPP.CARDS.EXP_MON, CCAPP.CARDS.EXP_YEAR from CCAPP.CARDS
2013/01/15 16:13:10ERRORselect CCAPP.CARDS.CARD_NO, CCAPP.CARDS.EXP_MON, CCAPP.CARDS.EXP_YEAR from CCAPP.CARDS
001514TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:26:35PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'create table mycopy as select * from ccapp.cards';
  execute immediate(s);
end;
001618TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:06:55CREATE VIEWcreate or replace view myview as select * from ccapp.cards
001624TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:08:44CREATE MATERIALIZED VIEWcreate materialized view myview as select * from ccapp.cards
001633TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:12:27CREATE SYNONYMcreate synonym mysyn for ccapp.cards
001664TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:26:12CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select card_no,exp_mon,exp_year from ccapp.cards);
end;
001708TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:43:42CREATE TRIGGERcreate or replace trigger card_processing
after insert on ccapp.cards for each row
begin
  insert into mycopy values(:new.card_no, :new.exp_mon, :new.exp_year);
end;
Solaris-10g
ORA10 on steel
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000464TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 12:40:24PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
000740TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 16:06:57SELECTSELECT  ROWID, ID, CUSTOMER, CARD_NO, 
   EXP_MON, EXP_YEAR, ADDRESS, 
   ZIP
FROM CCAPP.CARDS
2013/01/15 16:06:57ERRORSELECT  ROWID, ID, CUSTOMER, CARD_NO, 
   EXP_MON, EXP_YEAR, ADDRESS, 
   ZIP
FROM CCAPP.CARDS
2013/01/15 16:07:25SELECTselect * from ccapp.cards
2013/01/15 16:07:25ERRORselect * from ccapp.cards
000781TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:31:36PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'create table mycopy as select * from ccapp.cards';
  execute immediate(s);
end;
000834TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:11:48INTERNALcreate or replace view myview as select * from ccapp.cards
000837TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:13:40ERRORcreate materialized view myview as select * from ccapp.cards
000842TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:17:16INTERNALcreate synonym mysyn for ccapp.cards
000864TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:31:03INTERNALcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select card_no,exp_mon,exp_year from ccapp.cards);
end;
000889TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:50:12INTERNALcreate or replace trigger card_processing
after insert on ccapp.cards for each row
begin
  insert into mycopy values(:new.card_no, :new.exp_mon, :new.exp_year);
end;
000894TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:54:08PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001610TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 12:16:46PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;
001978TOMToad.exeWORKGROUP\BLUECORE213
2013/01/15 15:51:26SELECTselect * from hrapp.salaries
2013/01/15 15:51:26ERRORselect * from hrapp.salaries
2013/01/15 15:54:10SELECTselect * from hrapp.salaries
2013/01/15 15:54:10ERRORselect * from hrapp.salaries
2013/01/15 15:54:17ERRORselect * from HRAPP.EMPLOYEES
select * from hpapp.salaries s, hpapp.employees e where e.id = s.emp
2013/01/15 15:54:27ERRORselect * from HRAPP.EMPLOYEES
select * from hpapp.salaries s, hpapp.employees e where e.id = s.emp
2013/01/15 15:54:35ERRORselect * from hpapp.salaries s, hpapp.employees e where e.id = s.emp
2013/01/15 15:55:10SELECTselect * from hrapp.salaries s, hrapp.employees e where e.id = s.emp
2013/01/15 15:56:41UPDATEupdate hrapp.salaries set bonus=200000 where emp = 2
2013/01/15 15:55:00ERRORselect * from hpapp.salaries s, hrapp.employees e where e.id = s.emp
2013/01/15 15:55:10ERRORselect * from hrapp.salaries s, hrapp.employees e where e.id = s.emp
2013/01/15 15:56:54SELECTselect * from hrapp.salaries s, hrapp.employees e where e.id = s.emp
2013/01/15 15:56:54ERRORselect * from hrapp.salaries s, hrapp.employees e where e.id = s.emp
002034TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 16:24:46PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'create table mycopy as select * from hrapp.salaries';
  execute immediate(s);
end;
002092TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:05:48CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
002096TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:07:46CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
002104TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:11:00CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
002110TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:15:42CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from employees e, salaries s where s.emp = e.id);
end;
002115TOMsqlplus.exeWORKGROUP\BLUECORE23
2013/01/15 17:17:54CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from employees e, salaries s where s.emp = e.id);
end;
2013/01/15 17:18:27CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select salary, first, last from employees,salaries where emp = id);
end;
2013/01/15 17:23:12CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
002144TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:38:15CREATE TRIGGERcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
002163TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:46:55PL/SQL EXECUTEdeclare t1 varchar2(20);
sqlstm varchar2(100);
begin
  t1 := 'hrapp.salaries';
  sqlstm:= 'select /* test */ * from '|| t1;
  execute immediate sqlstm;
end;