--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:08 AM

select table_name from sys.all_tables
where owner='AUX_PORTAL' and table_name not like 'BIN$%' and partitioned='NO' and ((iot_type <> 'IOT_OVERFLOW' or iot_type IS NULL) AND nested <> 'YES') and table_name like '%'


owner=['AUX_PORTAL']


Elapsed time: 0.049

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:17 AM

select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary
from sys.user_objects a,sys.user_tables b
where b.table_name like '%'
and a.object_name=b.table_name
and a.object_type='TABLE'
and b.dropped='NO'


object_name=['%']


Elapsed time: 0.009

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:17 AM

select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary
from sys.user_objects a,sys.user_object_tables b
where b.table_name like '%'
and a.object_name=b.table_name
and a.object_type='TABLE'


object_name=['%']


Elapsed time: 0.007

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:18 AM

select /*+ QCO9i QCOALL */ USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary 
from sys.user_objects a,sys.user_external_tables b
where b.table_name like '%'
and a.object_name=b.table_name
and a.object_type='TABLE'


object_name=['%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:20 AM

select count(rownum) from SYS.V_$PARAMETER

Error occurred: [942] (ORA-00942: table or view does not exist
)

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:20 AM

select a.column_name,decode(a.data_type,'VARCHAR2',0,'NUMBER',1,'FLOAT',2,'LONG',3,'VARCHAR',4,'DATE',5,'RAW',6,'LONG RAW',7,'ROWID',8,'CHAR',9,'MLSLABEL',11,'NVARCHAR2',12,'NCHAR VARYING',13,'NCHAR',14,'NCLOB',16,'CLOB',17,'BLOB',18,'BFILE',19,'CFILE',20,'UROWID',30,'BINARY_FLOAT',32,'BINARY_DOUBLE',33,decode(a.data_type_mod,'REF',15,decode(instr(a.data_type,'INTERVAL DAY'),1,29,decode(instr(a.data_type,'INTERVAL YEAR'),1,28,decode(instr(a.data_type,'TIMESTAMP'),1,decode(instr(a.data_type,'TIME ZONE'),0,26,decode(instr(a.data_type,'LOCAL TIME ZONE'),0,27,31)),decode(instr(a.data_type,'TIME'),1,decode(instr(a.data_type,'TIME ZONE'),0,24,25),decode(a.data_type_owner,null,32,21))))))) data_type,decode(a.data_type_owner,null,decode(instr(a.data_type,'INTERVAL'),1,a.data_type,decode(instr(a.data_type,'TIME'),1,a.data_type,'')),a.data_type) type_name,a.data_type_owner type_owner,a.data_length,a.char_used,a.data_precision,a.data_scale,a.nullable,a.column_id,a.data_default,a.num_distinct,cast(a.low_value as varchar2(500)) low_value, cast(a.high_value as varchar2(500)) high_value,a.char_length,USER object_owner,a.table_name object_name
from sys.user_tab_columns a
where a.table_name='MV_EMPLOYEES'
order by a.column_id


object_name=['MV_EMPLOYEES']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:20 AM

BEGIN                                
  SELECT   debuginfo                 
    INTO   :result                   
    FROM   sys.all_probe_objects     
   WHERE       owner = :owner        
          AND object_name = :name    
          AND object_type = :type    
          AND status = 'VALID';    
END;


result=[NULL]
owner=['AUX_PORTAL']
name=[NULL]
TYPE=[NULL]


Elapsed time: 0.023

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:20 AM

SELECT a.employee_id, a.userid, a.last_name, a.first_name, a.init,
       a.suffix, a.nickname, a.salutation, a.date_of_birth,
       a.date_of_hire_rehire, a.job_title, a.job_code, a.department,
       a.department_aux_1, a.location, a.work_phone, a.work_email,
       a.employee_status_type, a.mgr_employee_id, a.mgr_last_name,
       a.mgr_first_name, a.mgr_init
  FROM mv_employees a


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:20 AM

begin dbms_output.get_lines(:lines,:num); end;


num=[0]


Elapsed time: 0.007

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

BEGIN                                
  SELECT   debuginfo                 
    INTO   :result                   
    FROM   sys.all_probe_objects     
   WHERE       owner = :owner        
          AND object_name = :name    
          AND object_type = :type    
          AND status = 'VALID';    
END;


result=[NULL]
owner=['AUX_PORTAL']
name=[NULL]
TYPE=[NULL]


Elapsed time: 0.009

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'S%' escape '\'


owner=['AUX_PORTAL']
name_mask=['S%']


Elapsed time: 0.011

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'S%' escape '\'


owner=['PUBLIC']
name_mask=['S%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'SE%' escape '\'


owner=['AUX_PORTAL']
name_mask=['SE%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'SE%' escape '\'


owner=['PUBLIC']
name_mask=['SE%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:37 AM

select count(rownum) from SYS.DBA_USERS

Error occurred: [942] (ORA-00942: table or view does not exist
)

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'SELE%' escape '\'


owner=['AUX_PORTAL']
name_mask=['SELE%']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'SELE%' escape '\'


owner=['PUBLIC']
name_mask=['SELE%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'SELEC%' escape '\'


owner=['AUX_PORTAL']
name_mask=['SELEC%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'SELEC%' escape '\'


owner=['PUBLIC']
name_mask=['SELEC%']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'SELECT%' escape '\'


owner=['AUX_PORTAL']
name_mask=['SELECT%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'SELECT%' escape '\'


owner=['PUBLIC']
name_mask=['SELECT%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:38 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.003

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'F%' escape '\'


owner=['AUX_PORTAL']
name_mask=['F%']


Elapsed time: 0.015

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'F%' escape '\'


owner=['PUBLIC']
name_mask=['F%']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'FR%' escape '\'


owner=['AUX_PORTAL']
name_mask=['FR%']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'FR%' escape '\'


owner=['PUBLIC']
name_mask=['FR%']


Elapsed time: 0.008

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'FRO%' escape '\'


owner=['AUX_PORTAL']
name_mask=['FRO%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:40 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'FRO%' escape '\'


owner=['PUBLIC']
name_mask=['FRO%']


Elapsed time: 0.004

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:41 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.003

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:41 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'AUX_PORTAL' 
   AND object_name like 'FROM%' escape '\'


owner=['AUX_PORTAL']
name_mask=['FROM%']


Elapsed time: 0.003

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:41 AM

select /*+ ALL_ROWS */ object_name, 
       object_type, 
       decode(object_type, 'PROCEDURE', 0, 'FUNCTION', 1, 'PACKAGE', 2, 'PACKAGE BODY', 3, 'TYPE', 4, 'TYPE BODY', 5, 'TRIGGER', 6, 'VIEW', 7, 'TABLE', 9, 'INDEX', 10, 'SYNONYM', 25, 'SEQUENCE', 19, 16) image_index 
  from sys.all_objects
 where owner = 'PUBLIC' 
   AND object_name like 'FROM%' escape '\'


owner=['PUBLIC']
name_mask=['FROM%']


Elapsed time: 0.005

--------------------------------------------------------------------------------
Timestamp: 6/22/2011 11:51:41 AM

SELECT u.username                         
  FROM sys.all_users u              
 WHERE EXISTS                             
         (SELECT 'x'                    
            FROM sys.all_objects o  
           WHERE o.owner = u.username)


Elapsed time: 0.005