DBA DML activity
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.10010
2013/01/15 12:44:02INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 12:44:02INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 12:44:02INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 12:44:06UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 12:44:06UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 12:44:06UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 12:44:19INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 12:44:20INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 12:44:20INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 12:44:24INSERTinsert into x values (sysdate)
000239TOMToad.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 16:04:31UPDATEUPDATE "HRAPP"."SALARIES"
SET
  "SALARY" = :"SALARY", "BONUS" = :"BONUS"
WHERE
  "ROWID" = :"Old_ROWID"
000274TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:11:03UPDATEupdate mysyn set bonus=bonus*2 where emp=2
000279TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 17:24:53DELETEdelete from mycopy
000292TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10010
2013/01/15 17:47:13INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 17:47:13INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 17:47:14INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 17:47:16UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 17:47:16UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 17:47:17UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 17:47:29INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 17:47:29INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 17:47:30INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 17:47:34INSERTinsert into x values (sysdate)
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000425TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 12:54:34INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 12:54:34INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 12:54:34INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 12:54:41UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 12:54:41UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 12:54:41UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 12:54:51INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 12:54:51INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 12:54:51INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 12:54:53INSERTinsert into x values (sysdate)
000535TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:09:38UPDATEUPDATE "HRAPP"."SALARIES"
SET
  "SALARY" = :"SALARY", "BONUS" = :"BONUS"
WHERE
  "ROWID" = :"Old_ROWID"
000580TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:12:03UPDATEupdate mysyn set bonus=bonus*2 where emp=2
000583TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:25:49DELETEdelete from mycopy
000595TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 17:50:15INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 17:50:15INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 17:50:15INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 17:50:18UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 17:50:18UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 17:50:18UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 17:50:24INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 17:50:24INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 17:50:24INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 17:50:25INSERTinsert into x values (sysdate)
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000991TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 13:02:39INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 13:02:39INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 13:02:39INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 13:02:52UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 13:02:52UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 13:02:52UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 13:03:09INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 13:03:09INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 13:03:09INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 13:03:24INSERTinsert into x values (sysdate)
001664TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:26:13DELETEdelete from mycopy
Solaris-10g
ORA10 on steel
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000464TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 12:40:12INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 12:40:12INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 12:40:12INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 12:40:17UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 12:40:17UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 12:40:17UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 12:40:25INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 12:40:25INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 12:40:25INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 12:40:28INSERTinsert into x values (sysdate)
000864TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:31:03DELETEdelete from mycopy
000894TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 17:53:59INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 17:53:59INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 17:53:59INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 17:54:02UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 17:54:02UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 17:54:02UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 17:54:09INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 17:54:09INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 17:54:09INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 17:54:12INSERTinsert into x values (sysdate)
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001610TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 12:16:30INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 12:16:30INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 12:16:30INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 12:16:39UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 12:16:39UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 12:16:39UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 12:16:51INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 12:16:51INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 12:16:51INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 12:16:55INSERTinsert into x values (sysdate)
001978TOMToad.exeWORKGROUP\BLUECORE21
2013/01/15 15:56:41UPDATEupdate hrapp.salaries set bonus=200000 where emp = 2
002104TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:11:00UPDATEupdate mysyn set bonus=bonus*2 where emp=2
002115TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 17:23:31DELETEdelete from mycopy
002163TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 17:46:49INSERTinsert into employee values (111,'Tom','T',sysdate-100,sysdate,91000,'Irvine', 'DBA')
2013/01/15 17:46:49INSERTinsert into employee values (113,'Dick','D',sysdate-300,sysdate,101000,'Irvine', 'Programmer')
2013/01/15 17:46:49INSERTinsert into employee values (114,'Harry','H',sysdate-100,sysdate,111000,'Irvine', 'Manager')
2013/01/15 17:46:50UPDATEupdate employee set Salary=Salary*2 where id=111
2013/01/15 17:46:51UPDATEupdate employee set Salary=Salary*5 where id=111
2013/01/15 17:46:51UPDATEupdate employee set Salary=Salary/2 where id=114
2013/01/15 17:46:59INSERTINSERT INTO varray_table VALUES (1, vcarray('A'))
2013/01/15 17:46:59INSERTINSERT INTO varray_table VALUES (2, vcarray('B', 'C'))
2013/01/15 17:46:59INSERTINSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'))
2013/01/15 17:47:02INSERTinsert into x values (sysdate)