DBA Non CC SQL 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
000174SYS ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal3
2013/01/15 13:24:06ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:24:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='   ?  @lpar26p682e_pub (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 13:24:07ALTER DATABASEALTER DATABASE DISMOUNT
000193TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10012
2013/01/15 14:01:00SELECTSELECT USER FROM DUAL
2013/01/15 14:01:00INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:01:00PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:01:00SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:01:00SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:01:00PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:01:00INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:01:00SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 14:01:13ERRORselect nname from v$database
2013/01/15 14:01:17SELECTselect name from v$database
2013/01/15 14:01:18SELECTselect name from v$database
2013/01/15 14:01:26SELECTselect * from v$version
000239TOMToad.exeWORKGROUP\BLUECORE2172.29.149.10066
2013/01/15 16:02:53PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:02:53INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:02:53SELECTSELECT version, product, sysdate FROM sys.PRODUCT_COMPONENT_VERSION WHERE UPPER(PRODUCT) LIKE '%ORACLE%'
2013/01/15 16:02:53ERRORselect * from toad.toad_freeware
2013/01/15 16:02:53SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:02:53PL/SQL EXECUTEDeclare debug_connect_session number;_ alter_session number;_ alter_system number;_ alter_database number;_ select_any_table number;_ grant_any_object_priv number;_ select_any_dictionary number;_ update_any_table number;_ create_public_syn number;_ has_dba_synonyms number;_ has_dba_objects number;_ select_catalog_role number;_ db_charset nls_database_parameters.value%type;_ compatible_version varchar2(60);_ sid number;_ local_trans_id varchar2(60);_ qry_str varchar2(4000);_ has_dbms_java number;_ has_dbms_debug number;_ qu_version_owner varchar2(30);_ CTRepositoryVersion number;_ is_RAC number;_ instance_id number;_ instance_name varchar2(100);_ server_name varchar2(100);_ team_coding_schema varchar2(30);_ team_coding_table varchar2(30);_ team_coding_synonym varchar2(30);_ team_coding_table_selectable number;_ has_nav_tc number;_ AmazonRDSPackage varchar2(30);_Begin_ -- Put Toad data into v$session columns_ SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, null);_ -- _ -- _ -- Retrieve specific system privileges_ select_ sum(decode(Privilege, 'DEBUG CONNECT SESSION', 1, 0)) debug_connect_session,_ sum(decode(Privilege, 'ALTER SESSION', 1, 0)) alter_session,_ sum(decode(Privilege, 'ALTER SYSTEM', 1, 0)) alter_system,_ sum(decode(Privilege, 'ALTER DATABASE', 1, 0)) alter_database,_ sum(decode(Privilege, 'SELECT ANY TABLE', 1, 0)) select_any_table,_ sum(decode(Privilege, 'UPDATE ANY TABLE', 1, 0)) update_any_table,_ sum(dec
2013/01/15 16:02:54INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD Freeware 11.6.0.43',ACTION='',CLIENT=''--
2013/01/15 16:02:54SELECTSELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1
2013/01/15 16:03:00PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._18382029961924666952660755823_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN v
2013/01/15 16:03:01PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._61193707279115723412701119_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN vali
2013/01/15 16:03:15SELECTSELECT VALUE FROM V$OPTION WHERE PARAMETER='Objects'
2013/01/15 16:03:15SELECTSelect t.table_name,user as owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.user_all_tables t
where 1=1
2013/01/15 16:03:24SELECTSelect t.table_name,t.owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.DBA_ALL_TABLES t
where 1=1
and t.owner = :own
2013/01/15 16:03:24SELECTSelect owner, table_name
from sys.DBA_SNAPSHOTS
where owner = :own
2013/01/15 16:03:25SELECTSelect owner, object_name, created, last_ddl_time
from sys.DBA_OBJECTS
where object_type = 'TABLE'
and owner = :own
2013/01/15 16:03:28SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,cols.virtual_column
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:03:28SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:03:28SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS."_CURRENT_EDITION_OBJ" O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:03:28SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:03:29SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:03:30SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,cols.virtual_column
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:03:30SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:03:30SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS."_CURRENT_EDITION_OBJ" O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:03:30SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:03:31SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:03:32SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,cols.virtual_column
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:03:32SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:03:32SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS."_CURRENT_EDITION_OBJ" O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:03:32SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:03:33SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
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:37SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:03:37SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:03:43SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:03:43SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:03:43PL/SQL EXECUTEBEGIN SYS.DBMS_APPLICATION_INFO.SET_MODULE('TOAD Freeware 11.6.0.43', null);
END;
2013/01/15 16:03:43SELECTSELECT  ROWID, ID, FIRST, LAST, 
   ADDRESS, SSN, TITLE, 
   MANAGER, DEPT, OFFICE
FROM HRAPP.EMPLOYEES
2013/01/15 16:03:43SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:03:44SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:03:43ERRORSELECT  ROWID, ID, FIRST, LAST, 
   ADDRESS, SSN, TITLE, 
   MANAGER, DEPT, OFFICE
FROM HRAPP.EMPLOYEES
2013/01/15 16:03:44SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:03:52SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:03:52SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:03:52SELECTSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:03:53SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:03:53SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:03:52ERRORSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:04:08INTERNALSAVEPOINT LOCK_
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:04:31INTERNALCommit
2013/01/15 16:04:47SELECTSelect DISTINCT username FROM SYS.DBA_USERS ORDER BY 1
2013/01/15 16:04:47SELECTSelect owner owner, synonym_name, table_owner, table_name
    FROM SYS.DBA_SYNONYMS
   WHERE synonym_name IS NOT NULL
     AND owner = :owner
ORDER BY 1
2013/01/15 16:04:54SELECTSelect object_name, object_type
    FROM SYS.user_objects
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
ORDER BY 1
2013/01/15 16:04:55SELECTSelect object_name, object_type
    FROM SYS.DBA_OBJECTS
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
     AND owner = :owner
ORDER BY 1
2013/01/15 16:05:00SELECTSelect object_name, object_type
    FROM SYS.DBA_OBJECTS
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
     AND owner = :owner
ORDER BY 1
2013/01/15 16:05:25SELECTSelect column_name, data_type, column_id
    FROM SYS.DBA_TAB_COLUMNS
   WHERE owner = :owner AND  table_name = :name
ORDER BY 3
2013/01/15 16:05:32SELECTSelect column_name, data_type, column_id
    FROM SYS.DBA_TAB_COLUMNS
   WHERE owner = :owner AND  table_name = :name
ORDER BY 3
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:29SELECTselect 'x' from dual
2013/01/15 16:06:11ERRORselect s.*,e.* from HRAPP.SALARIES s, HRAPP.EMPLOYEES e where S.EMP = E.ID
2013/01/15 16:06:29PL/SQL EXECUTEbegin :id := sys.dbms_transaction.local_transaction_id; end;
000240TOMToad.exeWORKGROUP\BLUECORE2172.29.149.1005
2013/01/15 16:03:03PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:03:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:03:03PL/SQL EXECUTEbegin sys.dbms_application_info.set_module('TOAD background query session', null); end;
2013/01/15 16:03:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD background query session',ACTION='',CLIENT=''--
2013/01/15 16:03:05SELECTselect object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from   sys.user_objects
where  object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
000252TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1008
2013/01/15 16:21:55SELECTSELECT USER FROM DUAL
2013/01/15 16:21:55INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 16:21:56PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:21:56SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:21:56SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:21:56PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:21:56INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:21:56SELECTSELECT DECODE('A','A','1','2') FROM DUAL
000253TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10012
2013/01/15 16:23:02SELECTSELECT USER FROM DUAL
2013/01/15 16:23:02INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 16:23:02PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:23:02SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:23:02SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:23:02PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:23:02INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:23:02SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:23:16INTERNALalter session set recyclebin=off
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;
2013/01/15 16:23:16SELECTselect * from mycopy
2013/01/15 16:23:17DROP TABLEdrop table mycopy
000257TOM ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal12
2013/01/15 16:28:03SELECTSELECT USER FROM DUAL
2013/01/15 16:28:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='   ?  @lpar26p682e_pub (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:28:03PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:28:03SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:28:03SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:28:03PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:28:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:28:03SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:29:07INTERNALalter session set recyclebin=off
2013/01/15 16:29:07PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'cre'||'ate ta'||'ble myc'||'opy as s';
  s := s || 'elect * fr'||'om h'||'ra'||'pp.sa'||'la'||'ri'||'es';
  execute immediate(s);
end;
2013/01/15 16:29:07SELECTselect * from mycopy
2013/01/15 16:29:08DROP TABLEdrop table mycopy
000269SYS ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal10
2013/01/15 16:58:47INTERNALalter session set recyclebin=off
2013/01/15 16:58:47INTERNAL--DBMS_APPLICATION_INFO: MODULE='   ?  @lpar26p682e_pub (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:58:47CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:00:07PL/SQL EXECUTEBEGIN myproc('xhrqzt1ikqhh3lqsqkotl1ltz1lqsqkn4lqsqkn251vitkt1tdh46'); END;
2013/01/15 17:00:34PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1eeqhh3eqkrl'); END;
2013/01/15 17:01:38DROP TABLEdrop table mycopy
2013/01/15 17:01:44PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1ikqhh3lqsqkotl'); END;
2013/01/15 17:01:49SELECTselect * from mycopy
2013/01/15 17:01:56DROP TABLEdrop table mycopy
2013/01/15 17:02:00DROP PROCEDUREdrop procedure myproc
000270TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10014
2013/01/15 17:05:13SELECTSELECT USER FROM DUAL
2013/01/15 17:05:13INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:05:13PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:05:13SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:05:14SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:05:14PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:05:14INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:05:14SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:05:14INTERNALalter session set recyclebin=off
2013/01/15 17:05:14GRANT OBJECTgrant select any table to tom
2013/01/15 17:05:14CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:05:14SELECTselect * from myview
2013/01/15 17:05:15REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:05:15DROP VIEWdrop view myview
000273TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10012
2013/01/15 17:07:12SELECTSELECT USER FROM DUAL
2013/01/15 17:07:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:07:12PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:07:12SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:07:12SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:07:12PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:07:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:07:13SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:07:13INTERNALalter session set recyclebin=off
2013/01/15 17:07:13CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:07:13SELECTselect * from myview
2013/01/15 17:07:14DROP MATERIALIZED VIEWdrop materialized view myview
000274TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10014
2013/01/15 17:11:01SELECTSELECT USER FROM DUAL
2013/01/15 17:11:01INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:11:01PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:11:02SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:11:02SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:11:02PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:11:02INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:11:02SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:11:02INTERNALalter session set recyclebin=off
2013/01/15 17:11:02CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
2013/01/15 17:11:02SELECTselect * from mysyn
2013/01/15 17:11:03UPDATEupdate mysyn set bonus=bonus*2 where emp=2
2013/01/15 17:11:03SELECTselect * from mysyn
2013/01/15 17:11:03DROP SYNONYMdrop synonym mysyn
000279TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10017
2013/01/15 17:24:52SELECTSELECT USER FROM DUAL
2013/01/15 17:24:52INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:24:52PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:24:52SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:24:53SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:24:53PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:24:53INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:24:53SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:24:53INTERNALalter session set recyclebin=off
2013/01/15 17:24:53CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:24:53GRANT OBJECTgrant select any table to tom
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;
2013/01/15 17:24:53DELETEdelete from mycopy
2013/01/15 17:24:54REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:24:54SELECTselect * from mycopy
2013/01/15 17:24:54DROP TRIGGERdrop trigger mytrig
2013/01/15 17:24:54DROP TABLEdrop table mycopy
000287TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10017
2013/01/15 17:39:05SELECTSELECT USER FROM DUAL
2013/01/15 17:39:05INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:39:05PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:39:05SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:39:05SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:39:05PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:39:05INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:39:05SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:39:06INTERNALalter session set recyclebin=off
2013/01/15 17:39:06CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:39:06GRANT OBJECTgrant insert any table to hrapp
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;
2013/01/15 17:39:06PL/SQL EXECUTEBEGIN dbms_lock.sleep(60); END;
2013/01/15 17:40:06SELECTselect * from mycopy
2013/01/15 17:40:06REVOKE OBJECTrevoke insert any table from hrapp
2013/01/15 17:40:06DROP TRIGGERdrop trigger salary_processing
2013/01/15 17:40:06DROP TABLEdrop table mycopy
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000450SYSsqlplus@centos32 (TNS V1-V3)centos32local3
2013/01/15 13:27:32ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:27:44INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos32 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 13:27:44ALTER DATABASEALTER DATABASE DISMOUNT
000456SYSsqlplus@centos32 (TNS V1-V3)centos32local2
2013/01/15 13:28:03ALTER DATABASEALTER DATABASE OPEN
2013/01/15 13:28:23INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos32 (TNS V1-V3)',ACTION='',CLIENT=''--
000480TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10913
2013/01/15 14:02:38SELECTSELECT USER FROM DUAL
2013/01/15 14:02:38INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:02:38PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:02:38SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:02:38SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:02:38PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:02:38INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:02:38SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 14:02:46ERRORselect namme from v$version
2013/01/15 14:02:56SELECTselect name from v$database
2013/01/15 14:02:52ERRORselect namme from v$database
2013/01/15 14:02:57SELECTselect name from v$database
2013/01/15 14:03:01SELECTselect * from v$version
000535TOMToad.exeWORKGROUP\BLUECORE2172.16.0.10940
2013/01/15 16:08:11PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:08:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:08:11SELECTSELECT version, product, sysdate FROM sys.PRODUCT_COMPONENT_VERSION WHERE UPPER(PRODUCT) LIKE '%ORACLE%'
2013/01/15 16:08:12SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:08:12PL/SQL EXECUTEDeclare debug_connect_session number;_ alter_session number;_ alter_system number;_ alter_database number;_ select_any_table number;_ grant_any_object_priv number;_ select_any_dictionary number;_ update_any_table number;_ create_public_syn number;_ has_dba_synonyms number;_ has_dba_objects number;_ select_catalog_role number;_ db_charset nls_database_parameters.value%type;_ compatible_version varchar2(60);_ sid number;_ local_trans_id varchar2(60);_ qry_str varchar2(4000);_ has_dbms_java number;_ has_dbms_debug number;_ qu_version_owner varchar2(30);_ CTRepositoryVersion number;_ is_RAC number;_ instance_id number;_ instance_name varchar2(100);_ server_name varchar2(100);_ team_coding_schema varchar2(30);_ team_coding_table varchar2(30);_ team_coding_synonym varchar2(30);_ team_coding_table_selectable number;_ has_nav_tc number;_Begin_ -- Put Toad data into v$session columns_ SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, null);_ -- _ -- _ -- Retrieve specific system privileges_ select_ sum(decode(Privilege, 'DEBUG CONNECT SESSION', 1, 0)) debug_connect_session,_ sum(decode(Privilege, 'ALTER SESSION', 1, 0)) alter_session,_ sum(decode(Privilege, 'ALTER SYSTEM', 1, 0)) alter_system,_ sum(decode(Privilege, 'ALTER DATABASE', 1, 0)) alter_database,_ sum(decode(Privilege, 'SELECT ANY TABLE', 1, 0)) select_any_table,_ sum(decode(Privilege, 'UPDATE ANY TABLE', 1, 0)) update_any_table,_ sum(decode(Privilege, 'GRANT ANY OBJECT
2013/01/15 16:08:13INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD Freeware 11.6.0.43',ACTION='',CLIENT=''--
2013/01/15 16:08:13SELECTSELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1
2013/01/15 16:08:19PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._15411288935644466462145253008_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN v
2013/01/15 16:08:21PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._788567253174915115948938460_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN val
2013/01/15 16:08:35SELECTSELECT VALUE FROM V$OPTION WHERE PARAMETER='Objects'
2013/01/15 16:08:36SELECTSelect t.table_name,user as owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.user_all_tables t
where 1=1
2013/01/15 16:08:52SELECTSelect t.table_name,t.owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.DBA_ALL_TABLES t
where 1=1
and t.owner = :own
2013/01/15 16:08:52SELECTSelect owner, table_name
from sys.DBA_SNAPSHOTS
where owner = :own
2013/01/15 16:08:53SELECTSelect owner, object_name, created, last_ddl_time
from sys.DBA_OBJECTS
where object_type = 'TABLE'
and owner = :own
2013/01/15 16:08:56SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:08:56SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:08:56SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS.OBJ$ O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:08:57SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:08:57SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:09:02SELECTSELECT  ROWID, ID, FIRST, LAST, 
   ADDRESS, SSN, TITLE, 
   MANAGER, DEPT, OFFICE
FROM HRAPP.EMPLOYEES
2013/01/15 16:09:02SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:09:02ERRORSELECT  ROWID, ID, FIRST, LAST, 
   ADDRESS, SSN, TITLE, 
   MANAGER, DEPT, OFFICE
FROM HRAPP.EMPLOYEES
2013/01/15 16:09:02SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:09:07SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:09:07SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:09:07SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS.OBJ$ O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:09:07SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:09:07SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:09:07SELECTSELECT  ROWID, EMP, SALARY, BONUS
FROM HRAPP.SALARIES
2013/01/15 16:09:07SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:09:07SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:09:12INTERNALSAVEPOINT LOCK_
2013/01/15 16:09:12SELECTSELECT * FROM "HRAPP"."SALARIES"
WHERE
  "ROWID" = :"Old_ROWID"
FOR UPDATE NOWAIT
2013/01/15 16:09:31PL/SQL EXECUTEBEGIN SYS.DBMS_APPLICATION_INFO.SET_MODULE('TOAD Freeware 11.6.0.43', null);
END;
2013/01/15 16:09:31SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
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"
2013/01/15 16:09:38INTERNALCommit
2013/01/15 16:09:49SELECTselect 'x' from dual
2013/01/15 16:09:49PL/SQL EXECUTEbegin :id := sys.dbms_transaction.local_transaction_id; end;
000536TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1095
2013/01/15 16:08:22PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:08:22INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:08:22PL/SQL EXECUTEbegin sys.dbms_application_info.set_module('TOAD background query session', null); end;
2013/01/15 16:08:22INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD background query session',ACTION='',CLIENT=''--
2013/01/15 16:08:24SELECTselect object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from   sys.user_objects
where  object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
000547TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 16:24:25SELECTSELECT USER FROM DUAL
2013/01/15 16:24:25INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 16:24:25PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:24:25SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:24:25SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:24:25PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:24:25INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:24:25SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:24:25ALTER SESSIONalter session set recyclebin=off
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;
2013/01/15 16:24:25SELECTselect * from mycopy
2013/01/15 16:24:25INTERNALdrop table mycopy
000550TOMsqlplus@centos32 (TNS V1-V3)centos32local12
2013/01/15 16:28:55SELECTSELECT USER FROM DUAL
2013/01/15 16:28:55INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos32 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:28:55PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:28:55SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
2013/01/15 16:28:55SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:28:55PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:28:55INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:28:55SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:30:28ALTER SESSIONalter session set recyclebin=off
2013/01/15 16:30:28PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'cre'||'ate ta'||'ble myc'||'opy as s';
  s := s || 'elect * fr'||'om h'||'ra'||'pp.sa'||'la'||'ri'||'es';
  execute immediate(s);
end;
2013/01/15 16:30:29SELECTselect * from mycopy
2013/01/15 16:30:29INTERNALdrop table mycopy
000570SYSsqlplus@centos32 (TNS V1-V3)centos32local11
2013/01/15 16:59:46ALTER SESSIONalter session set recyclebin=off
2013/01/15 16:59:46INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos32 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:59:46INTERNALcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:01:02PL/SQL EXECUTEBEGIN myproc('xhrqzt1ikqhh3lqsqkotl1ltz1lqsqkn4lqsqkn251vitkt1tdh46'); END;
2013/01/15 17:01:26PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1eeqhh3eqkrl'); END;
2013/01/15 17:01:32SELECTselect * from mycopy
2013/01/15 17:01:56INTERNALdrop table mycopy
2013/01/15 17:02:04PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1ikqhh3lqsqkotl'); END;
2013/01/15 17:02:08SELECTselect * from mycopy
2013/01/15 17:02:13INTERNALdrop table mycopy
2013/01/15 17:02:17INTERNALdrop procedure myproc
000575TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10914
2013/01/15 17:06:14SELECTSELECT USER FROM DUAL
2013/01/15 17:06:14INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:06:14PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:06:14SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:06:14SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:06:14PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:06:14INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:06:14SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:06:14ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:06:18GRANT OBJECTgrant select any table to tom
2013/01/15 17:06:18INTERNALcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:06:19SELECTselect * from myview
2013/01/15 17:06:19REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:06:19INTERNALdrop view myview
000576TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 17:08:08SELECTSELECT USER FROM DUAL
2013/01/15 17:08:08INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:08:08PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:08:08SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:08:08SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:08:08PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:08:08INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:08:08SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:08:08ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:08:08ERRORcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:08:10ERRORselect * from myview
2013/01/15 17:08:10ERRORdrop materialized view myview
000580TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10914
2013/01/15 17:12:03SELECTSELECT USER FROM DUAL
2013/01/15 17:12:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:12:03PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:12:03SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:12:03SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:12:03PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:12:03INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:12:03SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:12:03ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:12:03INTERNALcreate synonym mysyn for hrapp.salaries
2013/01/15 17:12:03SELECTselect * from mysyn
2013/01/15 17:12:03UPDATEupdate mysyn set bonus=bonus*2 where emp=2
2013/01/15 17:12:03SELECTselect * from mysyn
2013/01/15 17:12:03INTERNALdrop synonym mysyn
000583TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:25:48SELECTSELECT USER FROM DUAL
2013/01/15 17:25:48INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:25:48PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:25:48SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:25:48SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:25:48PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:25:48INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:25:48SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:25:48ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:25:48CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:25:48GRANT OBJECTgrant select any table to tom
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;
2013/01/15 17:25:49DELETEdelete from mycopy
2013/01/15 17:25:49REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:25:49SELECTselect * from mycopy
2013/01/15 17:25:49INTERNALdrop trigger mytrig
2013/01/15 17:25:49INTERNALdrop table mycopy
000591TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:42:17SELECTSELECT USER FROM DUAL
2013/01/15 17:42:17INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:42:17PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:42:17SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:42:17SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:42:17PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:42:17INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:42:17SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:42:17ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:42:17CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:42:17GRANT OBJECTgrant insert any table to hrapp
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;
2013/01/15 17:42:17PL/SQL EXECUTEBEGIN dbms_lock.sleep(60); END;
2013/01/15 17:43:17SELECTselect * from mycopy
2013/01/15 17:43:17REVOKE OBJECTrevoke insert any table from hrapp
2013/01/15 17:43:17INTERNALdrop trigger salary_processing
2013/01/15 17:43:17INTERNALdrop table mycopy
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001066SYSsqlplus@centos64 (TNS V1-V3)centos64local3
2013/01/15 13:31:00ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:31:04INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos64 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 13:31:04ALTER DATABASEALTER DATABASE DISMOUNT
001161TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10914
2013/01/15 14:05:30SELECTSELECT USER FROM DUAL
2013/01/15 14:05:30INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:05:31PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:05:31SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:05:31SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:05:31PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:05:31INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:05:31SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 14:05:50ERRORselect name from v$$database
2013/01/15 14:05:55SELECTselect name from v$database
2013/01/15 14:06:04ERRORselect * from v$version;
2013/01/15 14:06:07SELECTselect * from v$version
2013/01/15 14:06:10SELECTselect * from v$version
2013/01/15 14:06:11SELECTselect * from v$version
001471TOMToad.exeWORKGROUP\BLUECORE2172.16.0.10933
2013/01/15 16:10:50PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:10:51INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:10:51SELECTSELECT version, product, sysdate FROM sys.PRODUCT_COMPONENT_VERSION WHERE UPPER(PRODUCT) LIKE '%ORACLE%'
2013/01/15 16:10:51ERRORselect * from toad.toad_freeware
2013/01/15 16:10:52SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:10:52PL/SQL EXECUTEDeclare debug_connect_session number;_ alter_session number;_ alter_system number;_ alter_database number;_ select_any_table number;_ grant_any_object_priv number;_ select_any_dictionary number;_ update_any_table number;_ create_public_syn number;_ has_dba_synonyms number;_ has_dba_objects number;_ select_catalog_role number;_ db_charset nls_database_parameters.value%type;_ compatible_version varchar2(60);_ sid number;_ local_trans_id varchar2(60);_ qry_str varchar2(4000);_ has_dbms_java number;_ has_dbms_debug number;_ qu_version_owner varchar2(30);_ CTRepositoryVersion number;_ is_RAC number;_ instance_id number;_ instance_name varchar2(100);_ server_name varchar2(100);_ team_coding_schema varchar2(30);_ team_coding_table varchar2(30);_ team_coding_synonym varchar2(30);_ team_coding_table_selectable number;_ has_nav_tc number;_ AmazonRDSPackage varchar2(30);_Begin_ -- Put Toad data into v$session columns_ SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, null);_ -- _ -- _ -- Retrieve specific system privileges_ select_ sum(decode(Privilege, 'DEBUG CONNECT SESSION', 1, 0)) debug_connect_session,_ sum(decode(Privilege, 'ALTER SESSION', 1, 0)) alter_session,_ sum(decode(Privilege, 'ALTER SYSTEM', 1, 0)) alter_system,_ sum(decode(Privilege, 'ALTER DATABASE', 1, 0)) alter_database,_ sum(decode(Privilege, 'SELECT ANY TABLE', 1, 0)) select_any_table,_ sum(decode(Privilege, 'UPDATE ANY TABLE', 1, 0)) update_any_table,_ sum(dec
2013/01/15 16:10:56INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD Freeware 11.6.0.43',ACTION='',CLIENT=''--
2013/01/15 16:10:56SELECTSELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1
2013/01/15 16:11:08PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._12035001101797030282850818489_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN v
2013/01/15 16:11:10PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._2697596501956434220341002721_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN va
2013/01/15 16:11:16SELECTSELECT VALUE FROM V$OPTION WHERE PARAMETER='Objects'
2013/01/15 16:11:17SELECTSelect t.table_name,user as owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.user_all_tables t
where 1=1
2013/01/15 16:11:34SELECTSelect t.table_name,t.owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(tablespace_name, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.DBA_ALL_TABLES t
where 1=1
and t.owner = :own
2013/01/15 16:11:35SELECTSelect owner, table_name
from sys.DBA_SNAPSHOTS
where owner = :own
2013/01/15 16:11:36SELECTSelect owner, object_name, created, last_ddl_time
from sys.DBA_OBJECTS
where object_type = 'TABLE'
and owner = :own
2013/01/15 16:11:40SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,cols.virtual_column
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:11:41SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:11:41SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS."_CURRENT_EDITION_OBJ" O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:11:41SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:11:42SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
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:11:44SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:11:44SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:12:00SELECTSelect DISTINCT username FROM SYS.DBA_USERS ORDER BY 1
2013/01/15 16:12:00SELECTSelect owner owner, synonym_name, table_owner, table_name
    FROM SYS.DBA_SYNONYMS
   WHERE synonym_name IS NOT NULL
     AND owner = :owner
ORDER BY 1
2013/01/15 16:12:10SELECTSelect object_name, object_type
    FROM SYS.user_objects
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
ORDER BY 1
2013/01/15 16:12:11SELECTSelect object_name, object_type
    FROM SYS.DBA_OBJECTS
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
     AND owner = :owner
ORDER BY 1
2013/01/15 16:12:13SELECTSelect column_name, data_type, column_id
    FROM SYS.DBA_TAB_COLUMNS
   WHERE owner = :owner AND  table_name = :name
ORDER BY 3
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
2013/01/15 16:13:23SELECTselect 'x' from dual
2013/01/15 16:13:23PL/SQL EXECUTEbegin :id := sys.dbms_transaction.local_transaction_id; end;
001476TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1095
2013/01/15 16:11:11PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:11:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:11:11PL/SQL EXECUTEbegin sys.dbms_application_info.set_module('TOAD background query session', null); end;
2013/01/15 16:11:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD background query session',ACTION='',CLIENT=''--
2013/01/15 16:11:13SELECTselect object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from   sys.user_objects
where  object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
001514TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 16:26:35SELECTSELECT USER FROM DUAL
2013/01/15 16:26:35INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 16:26:35PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:26:35SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:26:35SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:26:35PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:26:35INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:26:35SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:26:35INTERNALalter session set recyclebin=off
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;
2013/01/15 16:26:38SELECTselect * from mycopy
2013/01/15 16:26:38DROP TABLEdrop table mycopy
001521TOMsqlplus@centos64 (TNS V1-V3)centos64local12
2013/01/15 16:29:16SELECTSELECT USER FROM DUAL
2013/01/15 16:29:16INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos64 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:29:16PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:29:16SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:29:16SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:29:16PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:29:16INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:29:17SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:32:14INTERNALalter session set recyclebin=off
2013/01/15 16:32:14PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'cre'||'ate ta'||'ble myc'||'opy as s';
  s := s || 'elect * fr'||'om c'||'ca'||'pp.ca'||'rd'||'s';
  execute immediate(s);
end;
2013/01/15 16:32:15SELECTselect * from mycopy
2013/01/15 16:32:15DROP TABLEdrop table mycopy
001602SYSsqlplus@centos64 (TNS V1-V3)centos64local7
2013/01/15 17:00:07INTERNALalter session set recyclebin=off
2013/01/15 17:00:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos64 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 17:00:07CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:03:47PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1eeqhh3eqkrl'); END;
2013/01/15 17:03:51SELECTselect * from mycopy
2013/01/15 17:03:54DROP TABLEdrop table mycopy
2013/01/15 17:03:59DROP PROCEDUREdrop procedure myproc
001618TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10914
2013/01/15 17:06:54SELECTSELECT USER FROM DUAL
2013/01/15 17:06:54INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:06:54PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:06:54SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:06:54SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:06:54PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:06:54INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:06:54SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:06:54INTERNALalter session set recyclebin=off
2013/01/15 17:06:54GRANT OBJECTgrant select any table to tom
2013/01/15 17:06:55CREATE VIEWcreate or replace view myview as select * from ccapp.cards
2013/01/15 17:06:55SELECTselect * from myview
2013/01/15 17:06:55REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:06:55DROP VIEWdrop view myview
001624TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 17:08:44SELECTSELECT USER FROM DUAL
2013/01/15 17:08:44INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:08:44PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:08:44SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:08:44SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:08:44PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:08:44INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:08:44SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:08:44INTERNALalter session set recyclebin=off
2013/01/15 17:08:44CREATE MATERIALIZED VIEWcreate materialized view myview as select * from ccapp.cards
2013/01/15 17:08:49SELECTselect * from myview
2013/01/15 17:08:49DROP MATERIALIZED VIEWdrop materialized view myview
001633TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 17:12:27SELECTSELECT USER FROM DUAL
2013/01/15 17:12:27INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:12:27PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:12:27SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:12:27SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:12:27PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:12:27INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:12:27SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:12:27INTERNALalter session set recyclebin=off
2013/01/15 17:12:27CREATE SYNONYMcreate synonym mysyn for ccapp.cards
2013/01/15 17:12:27SELECTselect * from mysyn
2013/01/15 17:12:27DROP SYNONYMdrop synonym mysyn
001664TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:26:11SELECTSELECT USER FROM DUAL
2013/01/15 17:26:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:26:11PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:26:11SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:26:11SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:26:11PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:26:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:26:11SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:26:11INTERNALalter session set recyclebin=off
2013/01/15 17:26:11CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:26:12GRANT OBJECTgrant select any table to tom
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;
2013/01/15 17:26:13DELETEdelete from mycopy
2013/01/15 17:26:13REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:26:13SELECTselect * from mycopy
2013/01/15 17:26:13DROP TRIGGERdrop trigger mytrig
2013/01/15 17:26:13DROP TABLEdrop table mycopy
001708TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:43:41SELECTSELECT USER FROM DUAL
2013/01/15 17:43:41INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:43:41PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:43:41SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:43:41SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:43:41PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:43:41INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:43:41SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:43:41INTERNALalter session set recyclebin=off
2013/01/15 17:43:41CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:43:42GRANT OBJECTgrant insert any table to ccapp
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;
2013/01/15 17:43:42PL/SQL EXECUTEBEGIN dbms_lock.sleep(60); END;
2013/01/15 17:44:42SELECTselect * from mycopy
2013/01/15 17:44:42REVOKE OBJECTrevoke insert any table from ccapp
2013/01/15 17:44:42DROP TRIGGERdrop trigger card_processing
2013/01/15 17:44:43DROP TABLEdrop table mycopy
Solaris-10g
ORA10 on steel
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000515SYSsqlplus@steel (TNS V1-V3)steellocal3
2013/01/15 13:24:13ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:24:27INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@steel (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 13:24:27ALTER DATABASEALTER DATABASE DISMOUNT
000523SYSsqlplus@steel (TNS V1-V3)steellocal2
2013/01/15 13:24:51ALTER DATABASEALTER DATABASE OPEN
2013/01/15 13:24:58INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@steel (TNS V1-V3)',ACTION='',CLIENT=''--
000574TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1098
2013/01/15 14:03:24SELECTSELECT USER FROM DUAL
2013/01/15 14:03:24INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:03:24PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:03:24SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:03:24SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:03:24PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:03:24INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:03:24SELECTSELECT DECODE('A','A','1','2') FROM DUAL
000575TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10911
2013/01/15 14:03:31SELECTSELECT USER FROM DUAL
2013/01/15 14:03:31INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:03:31PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:03:31SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:03:31SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:03:31PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:03:31INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:03:31SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 14:03:42SELECTselect * from v$version
2013/01/15 14:03:44ERRORselect * from v$versionn
2013/01/15 14:03:58SELECTselect name from v$database
000577TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10910
2013/01/15 14:03:55ERRORselect namee from v$database
2013/01/15 14:04:07SELECTSELECT USER FROM DUAL
2013/01/15 14:04:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 14:04:07PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 14:04:07SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 14:04:07SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 14:04:07PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 14:04:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 14:04:07SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 14:04:10SELECTselect name from v$database
000740TOMToad.exeWORKGROUP\BLUECORE2172.16.0.10954
2013/01/15 16:03:56PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:03:57INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:03:57SELECTSELECT version, product, sysdate FROM sys.PRODUCT_COMPONENT_VERSION WHERE UPPER(PRODUCT) LIKE '%ORACLE%'
2013/01/15 16:03:57SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:03:57PL/SQL EXECUTEDeclare debug_connect_session number;_ alter_session number;_ alter_system number;_ alter_database number;_ select_any_table number;_ grant_any_object_priv number;_ select_any_dictionary number;_ update_any_table number;_ create_public_syn number;_ has_dba_synonyms number;_ has_dba_objects number;_ select_catalog_role number;_ db_charset nls_database_parameters.value%type;_ compatible_version varchar2(60);_ sid number;_ local_trans_id varchar2(60);_ qry_str varchar2(4000);_ has_dbms_java number;_ has_dbms_debug number;_ qu_version_owner varchar2(30);_ CTRepositoryVersion number;_ is_RAC number;_ instance_id number;_ instance_name varchar2(100);_ server_name varchar2(100);_ team_coding_schema varchar2(30);_ team_coding_table varchar2(30);_ team_coding_synonym varchar2(30);_ team_coding_table_selectable number;_ has_nav_tc number;_Begin_ -- Put Toad data into v$session columns_ SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, null);_ -- _ -- _ -- Retrieve specific system privileges_ select_ sum(decode(Privilege, 'DEBUG CONNECT SESSION', 1, 0)) debug_connect_session,_ sum(decode(Privilege, 'ALTER SESSION', 1, 0)) alter_session,_ sum(decode(Privilege, 'ALTER SYSTEM', 1, 0)) alter_system,_ sum(decode(Privilege, 'ALTER DATABASE', 1, 0)) alter_database,_ sum(decode(Privilege, 'SELECT ANY TABLE', 1, 0)) select_any_table,_ sum(decode(Privilege, 'UPDATE ANY TABLE', 1, 0)) update_any_table,_ sum(decode(Privilege, 'GRANT ANY OBJECT
2013/01/15 16:03:58INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD Freeware 11.6.0.43',ACTION='',CLIENT=''--
2013/01/15 16:03:58SELECTSELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1
2013/01/15 16:04:05PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._3333030911254347267574712854_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN va
2013/01/15 16:04:05PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._214295973011805921931604981065_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN
2013/01/15 16:04:28PL/SQL EXECUTEBEGIN SYS.DBMS_APPLICATION_INFO.SET_MODULE('TOAD Freeware 11.6.0.43', null);
END;
2013/01/15 16:04:28SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 16:04:18ERRORselect * user_tables
2013/01/15 16:04:34SELECTselect * from user_tables
2013/01/15 16:04:33ERRORselect * from user_tables
2013/01/15 16:04:52ERRORselect * from dba_tables where owner = ccapp
2013/01/15 16:05:08SELECTSELECT VALUE FROM V$OPTION WHERE PARAMETER='Objects'
2013/01/15 16:05:10SELECTSelect t.table_name,user as owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.user_all_tables t
where 1=1
2013/01/15 16:05:52SELECTSelect t.table_name,t.owner, t.cluster_name,
        t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
       , t.temporary, t.table_type, t.table_type_owner, t.nested 
       , decode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
       , t.dropped
        , t.initial_extent
from sys.DBA_ALL_TABLES t
where 1=1
and t.owner = :own
2013/01/15 16:05:53SELECTSelect owner, table_name
from sys.DBA_SNAPSHOTS
where owner = :own
2013/01/15 16:05:53SELECTSelect owner, object_name, created, last_ddl_time
from sys.DBA_OBJECTS
where object_type = 'TABLE'
and owner = :own
2013/01/15 16:05:57SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:05:58SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:05:58SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS.OBJ$ O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:05:58SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:05:58SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:06:10SELECTSelect cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
                   'VARCHAR', char_length,
                   'VARCHAR2', char_length,
                   'NCHAR', char_length,
                   'NVARCHAR', char_length,
                   'NVARCHAR2', char_length,
                   null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length,
  data_precision Precision, data_scale Scale, data_length dlength, data_default  
  ,' ' comments 
  , DATA_TYPE_MOD 
  ,cols.CHAR_USED
  ,cols.hidden_column, cols.internal_column_id
  , qualified_col_name
  ,InitCap(histogram) histogram
  ,num_distinct, num_nulls, round(density, 5) density
FROM
  sys.DBA_TAB_COLS cols
where 1=1
and cols.table_name = :TABNAME
and cols.owner = :OWNNAME
order by internal_column_id
2013/01/15 16:06:10SELECTselect column_name, encryption_alg, salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
2013/01/15 16:06:10SELECTSELECT CN.NAME
FROM   SYS.CDEF$ C, SYS.CON$ CN, SYS.OBJ$ O, SYS.USER$ U
WHERE  C.Type# = 2
AND    C.CON# = CN.CON#
AND    C.OBJ# = O.OBJ#
AND    O.OWNER# = U.USER#
AND    U.NAME = :uname
AND    O.NAME = :tname
2013/01/15 16:06:10SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:06:10SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:06:11SELECTSelect t.trigger_name, t.trigger_type, t.triggering_event,
        t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.DBA_OBJECTS o, sys.DBA_TRIGGERS t
where t.table_owner = :own
and   t.table_name = :obj
and   o.object_type = 'TRIGGER'
and   o.object_name = t.trigger_name
and   o.owner = t.owner
2013/01/15 16:06:11SELECTSelect owner, index_name, uniqueness, status
       ,INDEX_TYPE, TEMPORARY, PARTITIONED, LOGGING, DEGREE, funcidx_status, join_index
from   sys.DBA_INDEXES
where  table_owner = :town
and    table_name  = :tname
order by index_name
2013/01/15 16:06:43SELECTSelect * from SYS.DBA_ALL_TABLES t
where owner =:own
and ((iot_type is null) or (iot_type <> 'IOT_MAPPING'))
and ((TABLE_NAME = :OneObjectName) or
    (table_name like 'SYS_IOT_OVER%'and iot_name = :OneObjectName))
2013/01/15 16:06:47SELECTSelect * from SYS.DBA_QUEUE_TABLES where owner = :own and SUBSTRB(queue_table, 1, 4) <> 'AQ$_'
and queue_table = :OneObjectName
2013/01/15 16:06:47SELECTselect name, table_comment from system.aq$_queue_tables where schema = :own and table_comment is not null
and name = :OneObjectName
2013/01/15 16:06:47SELECTSelect table_name, column_name, data_type, data_type_mod, data_type_owner,
       decode(data_type, 'CHAR', char_length,
                         'VARCHAR', char_length,
                         'VARCHAR2', char_length,
                         'NCHAR', char_length,
                         'NVARCHAR', char_length,
                         'NVARCHAR2', char_length,
                         data_length) data_length,
       data_precision, data_scale, nullable, char_used
FROM SYS.DBA_TAB_COLUMNS c
WHERE OWNER = :own
and TABLE_NAME = :OneObjectName
order by table_name, column_id
2013/01/15 16:06:47SELECTSelect TABLE_NAME, COLUMN_NAME, DEFAULT_LENGTH, DATA_DEFAULT
FROM SYS.DBA_TAB_COLUMNS C WHERE OWNER = :own
And default_length is not null
2013/01/15 16:06:48SELECTSELECT table_name, column_name,
       DECODE(encryption_alg, '3 Key Triple DES 168 bits key', '3DES168',
                              'AES 128 bits key', 'AES128',
                              'AES 192 bits key', 'AES192',
                              'AES 256 bits key', 'AES256',
                              'Internal Error') encryption_alg,
       salt
from sys.DBA_ENCRYPTED_COLUMNS
where owner =:own
and TABLE_NAME = :OneObjectName
2013/01/15 16:06:48SELECTSelect * from SYS.DBA_REFS where owner = :own
and TABLE_NAME = :OneObjectName
2013/01/15 16:06:48SELECTSelect l.TABLE_NAME, l.LOG_GROUP_NAME, c.COLUMN_NAME, l.ALWAYS
      , c.logging_property, l.log_group_type, l.generated
from   SYS.DBA_LOG_GROUPS l, SYS.DBA_LOG_GROUP_COLUMNS c
where  l.OWNER = c.OWNER (+)
and    l.owner = :own
and    l.LOG_GROUP_NAME = c.LOG_GROUP_NAME (+)
and    l.TABLE_NAME = c.TABLE_NAME (+)
and l.table_name = :OneObjectName
order by l.TABLE_NAME, l.LOG_GROUP_NAME, c.POSITION
2013/01/15 16:06:48SELECTSelect c.TABLE_NAME, NULL COLUMN_NAME, c.COMMENTS
FROM   SYS.DBA_TAB_COMMENTS c
WHERE  c.OWNER = :own
and C.TABLE_NAME = :OneObjectName
2013/01/15 16:06:48SELECTSelect c.TABLE_NAME, c.COLUMN_NAME, c.COMMENTS
FROM   SYS.DBA_COL_COMMENTS c
WHERE  c.OWNER = :own
and C.TABLE_NAME = :OneObjectName
2013/01/15 16:06:48SELECTSelect count (*)
from SYS.DBA_CONSTRAINTS
where owner = :own
and constraint_type in ('C', '?')
and TABLE_NAME = :OneObjectName
2013/01/15 16:06:49SELECTSelect CONSTRAINT_NAME, OWNER, TABLE_NAME, CONSTRAINT_TYPE, SUBSTRB(STATUS, 1, 1) STATUS
, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated
, VALIDATED
, RELY
, VIEW_RELATED
, INDEX_NAME, INDEX_OWNER
FROM SYS.DBA_CONSTRAINTS
WHERE OWNER = :pOwner
AND CONSTRAINT_TYPE = :ct
and TABLE_NAME = :OneObjectName
2013/01/15 16:06:49SELECTSelect CONSTRAINT_NAME, OWNER, TABLE_NAME, CONSTRAINT_TYPE, SUBSTRB(STATUS, 1, 1) STATUS
, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated
, VALIDATED
, RELY
, VIEW_RELATED
, INDEX_NAME, INDEX_OWNER
FROM SYS.DBA_CONSTRAINTS
WHERE OWNER = :pOwner
AND CONSTRAINT_TYPE = :ct
and TABLE_NAME = :OneObjectName
2013/01/15 16:06:49SELECTSelect CONSTRAINT_NAME, OWNER, TABLE_NAME, CONSTRAINT_TYPE, SUBSTRB(STATUS, 1, 1) STATUS
, R_OWNER, R_CONSTRAINT_NAME, SUBSTRB(DELETE_RULE, 1, 1) delete_rule
, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated
, VALIDATED
, RELY
, VIEW_RELATED
FROM SYS.DBA_CONSTRAINTS
WHERE OWNER = :pOwner
AND CONSTRAINT_TYPE = :ct
and TABLE_NAME = :OneObjectName
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:06:57SELECTSelect last_ddl_time
from   sys.DBA_OBJECTS
where  owner = :own
and    object_name = :nam
and    object_type = :typ
2013/01/15 16:06:57SELECTSelect count(*)
FROM   DBA_CONSTRAINTS
WHERE  OWNER = :town
AND    TABLE_NAME = :tname
AND    CONSTRAINT_TYPE = 'R'
2013/01/15 16:07:25SELECTselect * from ccapp.cards
2013/01/15 16:08:19SELECTselect 'x' from dual
2013/01/15 16:07:25ERRORselect * from ccapp.cards
2013/01/15 16:08:19PL/SQL EXECUTEbegin :id := sys.dbms_transaction.local_transaction_id; end;
000741TOMToad.exeWORKGROUP\BLUECORE2172.16.0.1095
2013/01/15 16:04:07PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 16:04:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='Toad.exe',ACTION='',CLIENT=''--
2013/01/15 16:04:07PL/SQL EXECUTEbegin sys.dbms_application_info.set_module('TOAD background query session', null); end;
2013/01/15 16:04:07INTERNAL--DBMS_APPLICATION_INFO: MODULE='TOAD background query session',ACTION='',CLIENT=''--
2013/01/15 16:04:08SELECTselect object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from   sys.user_objects
where  object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
000781TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10912
2013/01/15 16:31:35SELECTSELECT USER FROM DUAL
2013/01/15 16:31:35INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 16:31:35PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:31:36SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:31:36SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:31:36PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:31:36INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:31:36SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:31:36ALTER SESSIONalter session set recyclebin=off
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;
2013/01/15 16:31:36SELECTselect * from mycopy
2013/01/15 16:31:36INTERNALdrop table mycopy
000784TOMsqlplus@steel (TNS V1-V3)steellocal12
2013/01/15 16:33:44SELECTSELECT USER FROM DUAL
2013/01/15 16:33:44INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@steel (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 16:33:44PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:33:44SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
2013/01/15 16:33:44SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:33:44PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:33:44INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 16:33:44SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:36:45ALTER SESSIONalter session set recyclebin=off
2013/01/15 16:36:45PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'cre'||'ate ta'||'ble myc'||'opy as s';
  s := s || 'elect * fr'||'om c'||'ca'||'pp.ca'||'rd'||'s';
  execute immediate(s);
end;
2013/01/15 16:36:46SELECTselect * from mycopy
2013/01/15 16:36:46INTERNALdrop table mycopy
000822SYSsqlplus@steel (TNS V1-V3)steellocal7
2013/01/15 17:04:16ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:04:16INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@steel (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 17:04:16INTERNALcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:08:03PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1eeqhh3eqkrl'); END;
2013/01/15 17:08:07SELECTselect * from mycopy
2013/01/15 17:08:12INTERNALdrop table mycopy
2013/01/15 17:08:20INTERNALdrop procedure myproc
000834TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10914
2013/01/15 17:11:47SELECTSELECT USER FROM DUAL
2013/01/15 17:11:47INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:11:47PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:11:48SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:11:48SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:11:48PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:11:48INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:11:48SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:11:48ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:11:48GRANT OBJECTgrant select any table to tom
2013/01/15 17:11:48INTERNALcreate or replace view myview as select * from ccapp.cards
2013/01/15 17:11:48SELECTselect * from myview
2013/01/15 17:11:48REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:11:48INTERNALdrop view myview
000837TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10911
2013/01/15 17:13:40SELECTSELECT USER FROM DUAL
2013/01/15 17:13:40INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:13:40PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:13:40SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:13:40SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:13:40PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:13:40INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:13:40SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:13:40ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:13:40ERRORcreate materialized view myview as select * from ccapp.cards
2013/01/15 17:13:40ERRORselect * from myview
000842TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10913
2013/01/15 17:17:16SELECTSELECT USER FROM DUAL
2013/01/15 17:17:16INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:17:16PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:17:16SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:17:16SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:17:16PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:17:16INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:17:16SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:17:16ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:17:16INTERNALcreate synonym mysyn for ccapp.cards
2013/01/15 17:17:16SELECTselect * from mysyn
2013/01/15 17:13:40ERRORdrop materialized view myview
2013/01/15 17:17:16INTERNALdrop synonym mysyn
000864TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:31:02SELECTSELECT USER FROM DUAL
2013/01/15 17:31:02INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:31:02PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:31:02SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:31:02SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:31:02PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:31:02INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:31:02SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:31:02ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:31:02CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:31:02GRANT OBJECTgrant select any table to tom
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;
2013/01/15 17:31:03DELETEdelete from mycopy
2013/01/15 17:31:03REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:31:03SELECTselect * from mycopy
2013/01/15 17:31:03INTERNALdrop trigger mytrig
2013/01/15 17:31:05INTERNALdrop table mycopy
000889TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10917
2013/01/15 17:50:11SELECTSELECT USER FROM DUAL
2013/01/15 17:50:11INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus.exe',ACTION='',CLIENT=''--
2013/01/15 17:50:12PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:50:12SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:50:12SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:50:12PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:50:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:50:12SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:50:12ALTER SESSIONalter session set recyclebin=off
2013/01/15 17:50:12CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:50:12GRANT OBJECTgrant insert any table to ccapp
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;
2013/01/15 17:50:13PL/SQL EXECUTEBEGIN dbms_lock.sleep(60); END;
2013/01/15 17:51:13SELECTselect * from mycopy
2013/01/15 17:51:13REVOKE OBJECTrevoke insert any table from ccapp
2013/01/15 17:51:13INTERNALdrop trigger card_processing
2013/01/15 17:51:15INTERNALdrop table mycopy
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001539TOMsqlplus.exeWORKGROUP\BLUECORE26
2013/01/15 11:28:00SELECTSELECT USER FROM DUAL
2013/01/15 11:28:00PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 11:28:00SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 11:28:00SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 11:28:00PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 11:28:00SELECTSELECT DECODE('A','A','1','2') FROM DUAL
001710SYSoradim.exeWORKGROUP\BLUECORE22
2013/01/15 13:14:31ALTER DATABASEalter database close normal
2013/01/15 13:14:38ALTER DATABASEalter database dismount
001713SYSoradim.exeWORKGROUP\BLUECORE22
2013/01/15 13:15:28ALTER DATABASEalter database mount exclusive
2013/01/15 13:15:40ALTER DATABASEalter database open
001784TOMsqlplus.exeWORKGROUP\BLUECORE29
2013/01/15 13:54:30SELECTSELECT USER FROM DUAL
2013/01/15 13:54:30PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 13:54:30SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 13:54:30SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 13:54:30PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 13:54:30SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 13:54:40SELECTselect * from v$version
2013/01/15 13:54:45SELECTselect * from v$version
2013/01/15 13:55:09SELECTselect name from v$database
001978TOMToad.exeWORKGROUP\BLUECORE235
2013/01/15 15:50:44PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 15:50:45SELECTSELECT version, product, sysdate FROM sys.PRODUCT_COMPONENT_VERSION WHERE UPPER(PRODUCT) LIKE '%ORACLE%'
2013/01/15 15:50:45ERRORselect * from toad.toad_freeware
2013/01/15 15:50:45SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
2013/01/15 15:50:45PL/SQL EXECUTEDeclare debug_connect_session number;_ alter_session number;_ alter_system number;_ alter_database number;_ select_any_table number;_ grant_any_object_priv number;_ select_any_dictionary number;_ update_any_table number;_ create_public_syn number;_ has_dba_synonyms number;_ has_dba_objects number;_ select_catalog_role number;_ db_charset nls_database_parameters.value%type;_ compatible_version varchar2(60);_ sid number;_ local_trans_id varchar2(60);_ qry_str varchar2(4000);_ has_dbms_java number;_ has_dbms_debug number;_ qu_version_owner varchar2(30);_ CTRepositoryVersion number;_ is_RAC number;_ instance_id number;_ instance_name varchar2(100);_ server_name varchar2(100);_ team_coding_schema varchar2(30);_ team_coding_table varchar2(30);_ team_coding_synonym varchar2(30);_ team_coding_table_selectable number;_ has_nav_tc number;_ AmazonRDSPackage varchar2(30);_Begin_ -- Put Toad data into v$session columns_ SYS.DBMS_APPLICATION_INFO.SET_MODULE(:IN_MDL, null);_ -- _ -- _ -- Retrieve specific system privileges_ select_ sum(decode(Privilege, 'DEBUG CONNECT SESSION', 1, 0)) debug_connect_session,_ sum(decode(Privilege, 'ALTER SESSION', 1, 0)) alter_session,_ sum(decode(Privilege, 'ALTER SYSTEM', 1, 0)) alter_system,_ sum(decode(Privilege, 'ALTER DATABASE', 1, 0)) alter_database,_ sum(decode(Privilege, 'SELECT ANY TABLE', 1, 0)) select_any_table,_ sum(decode(Privilege, 'UPDATE ANY TABLE', 1, 0)) update_any_table,_ sum(dec
2013/01/15 15:50:47SELECTSELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1
2013/01/15 15:50:57PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._12245266611009273981970304581_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN v
2013/01/15 15:50:58PL/SQL EXECUTEDECLARE TYPE table_names IS VARRAY (3) OF VARCHAR2 (30);_ currval_not_defined EXCEPTION;_ PRAGMA EXCEPTION_INIT (currval_not_defined, -8002);_ sys_prof_valid NUMBER;_ toad_prof_valid NUMBER;_ rst NUMBER;_ sys_pack VARCHAR2 (17);_ prof_seq VARCHAR2 (24);_ tables table_names;_ dbms_prof_tables CONSTANT table_names_ := table_names ('plsql_profiler_data',_ 'plsql_profiler_runs',_ 'plsql_profiler_units') ;_ dbms_hprof_tables CONSTANT table_names_ := table_names ('dbmshp_runs',_ 'dbmshp_function_info',_ 'dbmshp_parent_child_info') ;_ /*---------------------------------------------------------------------------_ -- Verify that the specified package exists_ ---------------------------------------------------------------------------*/_ FUNCTION CheckPackage (ObjectName IN VARCHAR2)_ RETURN NUMBER_ AS_ valid NUMBER;_ err_msg VARCHAR2 (2000);_ BEGIN_ valid := 1;_ BEGIN_ EXECUTE IMMEDIATE 'BEGIN ' || ObjectName || '._7108299188069280881907072572_; END;';_ EXCEPTION_ WHEN OTHERS_ THEN_ err_msg := SQLERRM;_ -- If error is for missing package member then we are OK_ IF INSTR (err_msg, 'PLS-00302') _ 0_ THEN_ valid := 1;_ ELSE_ valid := 0;_ END IF;_ END;_ RETURN va
2013/01/15 15:51:26SELECTselect * from hrapp.salaries
2013/01/15 15:51:26ERRORselect * from hrapp.salaries
2013/01/15 15:52:57SELECTSelect DISTINCT username FROM SYS.DBA_USERS ORDER BY 1
2013/01/15 15:52:57SELECTSelect owner owner, synonym_name, table_owner, table_name
    FROM SYS.DBA_SYNONYMS
   WHERE synonym_name IS NOT NULL
     AND owner = :owner
ORDER BY 1
2013/01/15 15:53:01SELECTSelect object_name, object_type
    FROM SYS.user_objects
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
ORDER BY 1
2013/01/15 15:53:02SELECTSelect object_name, object_type
    FROM SYS.DBA_OBJECTS
   WHERE object_type IN
            ('TABLE', 'VIEW', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'JAVA SOURCE', 'SEQUENCE')
     AND owner = :owner
ORDER BY 1
2013/01/15 15:53:04SELECTSelect column_name, data_type, column_id
    FROM SYS.DBA_TAB_COLUMNS
   WHERE owner = :owner AND  table_name = :name
ORDER BY 3
2013/01/15 15:53:10SELECTselect * from HRAPP.EMPLOYEES
2013/01/15 15:54:10SELECTselect * from hrapp.salaries
2013/01/15 15:53:10ERRORselect * from HRAPP.EMPLOYEES
2013/01/15 15:54:10ERRORselect * from hrapp.salaries
2013/01/15 15:54:31PL/SQL EXECUTEBEGIN SYS.DBMS_APPLICATION_INFO.SET_MODULE('TOAD Freeware 11.6.0.43', null);
END;
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:31SELECTSelect count(*)
from   v$session
where  (upper(module) = 'TOAD?') or (instr(upper(module), 'TOAD FREEWARE') > 0)
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:56:47INTERNALCommit
2013/01/15 15:55:00ERRORselect * from hpapp.salaries s, hrapp.employees e where e.id = s.emp
2013/01/15 15:56:48INTERNALCommit
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:58:32INTERNALCommit
2013/01/15 15:58:44SELECTselect 'x' from dual
2013/01/15 15:58:44PL/SQL EXECUTEbegin :id := sys.dbms_transaction.local_transaction_id; end;
2013/01/15 15:56:54ERRORselect * from hrapp.salaries s, hrapp.employees e where e.id = s.emp
001980TOMToad.exeWORKGROUP\BLUECORE23
2013/01/15 15:50:59PL/SQL EXECUTEdeclare cursor NlsParamsCursor is    SELECT * FROM nls_session_parameters;begin  SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1)    INTO :MaxCharLength, :MinCharLength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :NlsNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
2013/01/15 15:50:59PL/SQL EXECUTEbegin sys.dbms_application_info.set_module('TOAD background query session', null); end;
2013/01/15 15:51:00SELECTselect object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from   sys.user_objects
where  object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
002034TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 16:24:46SELECTSELECT USER FROM DUAL
2013/01/15 16:24:46PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:24:46SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:24:46SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:24:46PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:24:46SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:24:46INTERNALalter session set recyclebin=off
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;
2013/01/15 16:24:49SELECTselect * from mycopy
2013/01/15 16:24:49DROP TABLEdrop table mycopy
002041TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 16:27:56SELECTSELECT USER FROM DUAL
2013/01/15 16:27:56PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 16:27:56SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 16:27:56SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 16:27:56PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 16:27:56SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 16:28:13INTERNALalter session set recyclebin=off
2013/01/15 16:28:13PL/SQL EXECUTEdeclare s varchar2(100);
begin
  s := 'cre'||'ate ta'||'ble myc'||'opy as s';
  s := s || 'elect * fr'||'om h'||'ra'||'pp.sa'||'la'||'ri'||'es';
  execute immediate(s);
end;
2013/01/15 16:28:13SELECTselect * from mycopy
2013/01/15 16:28:13DROP TABLEdrop table mycopy
002070SYSsqlplus.exeWORKGROUP\BLUECORE26
2013/01/15 16:54:04INTERNALalter session set recyclebin=off
2013/01/15 16:54:06CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 16:54:46PL/SQL EXECUTEBEGIN myproc('xhrqzt1ikqhh3lqsqkotl1ltz1lqsqkn4lqsqkn251vitkt1tdh45'); END;
2013/01/15 16:55:30PL/SQL EXECUTEBEGIN myproc('ektqzt1zqwst1dneghn1ql1ltstez121ykgd1ikqhh3lqsqkotl'); END;
2013/01/15 16:55:36SELECTselect * from mycopy
2013/01/15 16:55:44DROP TABLEdrop table mycopy
002081SYSsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 16:59:12DROP PROCEDUREdrop procedure myproc
002092TOMsqlplus.exeWORKGROUP\BLUECORE212
2013/01/15 17:05:48SELECTSELECT USER FROM DUAL
2013/01/15 17:05:48PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:05:48SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:05:48SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:05:48PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:05:48SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:05:48INTERNALalter session set recyclebin=off
2013/01/15 17:05:48GRANT OBJECTgrant select any table to tom
2013/01/15 17:05:48CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:05:49SELECTselect * from myview
2013/01/15 17:05:49REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:05:49DROP VIEWdrop view myview
002096TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 17:07:45SELECTSELECT USER FROM DUAL
2013/01/15 17:07:45PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:07:45SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:07:45SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:07:45PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:07:45SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:07:45INTERNALalter session set recyclebin=off
2013/01/15 17:07:46CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:07:49SELECTselect * from myview
2013/01/15 17:07:49DROP MATERIALIZED VIEWdrop materialized view myview
002104TOMsqlplus.exeWORKGROUP\BLUECORE212
2013/01/15 17:11:00SELECTSELECT USER FROM DUAL
2013/01/15 17:11:00PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:11:00SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:11:00SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:11:00PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:11:00SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:11:00INTERNALalter session set recyclebin=off
2013/01/15 17:11:00CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
2013/01/15 17:11:00SELECTselect * from mysyn
2013/01/15 17:11:00UPDATEupdate mysyn set bonus=bonus*2 where emp=2
2013/01/15 17:11:00SELECTselect * from mysyn
2013/01/15 17:11:00DROP SYNONYMdrop synonym mysyn
002110TOMsqlplus.exeWORKGROUP\BLUECORE215
2013/01/15 17:15:41SELECTSELECT USER FROM DUAL
2013/01/15 17:15:41PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:15:41SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:15:41SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:15:41PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:15:41SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:15:41INTERNALalter session set recyclebin=off
2013/01/15 17:15:41CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:15:41GRANT OBJECTgrant select any table to tom
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;
2013/01/15 17:15:42ERRORdelete from mycopy
2013/01/15 17:15:42REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:15:43SELECTselect * from mycopy
2013/01/15 17:15:43DROP TRIGGERdrop trigger mytrig
2013/01/15 17:15:43DROP TABLEdrop table mycopy
002115TOMsqlplus.exeWORKGROUP\BLUECORE224
2013/01/15 17:17:09SELECTSELECT USER FROM DUAL
2013/01/15 17:17:09PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:17:09SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:17:09SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:17:09PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:17:09SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:17:25INTERNALalter session set recyclebin=off
2013/01/15 17:17:26CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:17:44GRANT OBJECTgrant select any table to tom
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:19:31ERRORalter mytrig compile debug
2013/01/15 17:19:40ALTER TRIGGERalter trigger mytrig compile debug
2013/01/15 17:20:59SELECTSELECT TO_CHAR(LINE)||'/'||TO_CHAR(POSITION) "LINE/COL", TEXT "ERROR" FROM ALL_ERRORS A WHERE A.NAME = UPPER(:NMBIND_SHOW_OBJ) AND A.TYPE = 'TRIGGER' AND A.OWNER = (SELECT (SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')) FROM DUAL) ORDER BY LINE, POSITION, ATTRIBUTE, MESSAGE_NUMBER
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;
2013/01/15 17:23:31DELETEdelete from mycopy
2013/01/15 17:23:31REVOKE OBJECTrevoke select any table from tom
2013/01/15 17:23:34SELECTselect * from mycopy
2013/01/15 17:23:39DROP TABLEdrop table mycopy
2013/01/15 17:23:46ERRORdrop trigger mytrig
2013/01/15 17:24:39ERRORdrop trigger mytrig
2013/01/15 17:24:53ERRORdrop trigger mytrig
2013/01/15 17:25:05SELECTselect object_name from user_objects
2013/01/15 17:25:07SELECTselect object_name from user_objects
002144TOMsqlplus.exeWORKGROUP\BLUECORE215
2013/01/15 17:38:15SELECTSELECT USER FROM DUAL
2013/01/15 17:38:15PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:38:15SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:38:15SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:38:15PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:38:15SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:38:15INTERNALalter session set recyclebin=off
2013/01/15 17:38:15CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:38:15GRANT OBJECTgrant insert any table to hrapp
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;
2013/01/15 17:38:15PL/SQL EXECUTEBEGIN dbms_lock.sleep(60); END;
2013/01/15 17:39:15SELECTselect * from mycopy
2013/01/15 17:39:15REVOKE OBJECTrevoke insert any table from hrapp
2013/01/15 17:39:15DROP TRIGGERdrop trigger salary_processing
2013/01/15 17:39:16DROP TABLEdrop table mycopy