Core Dba Scripts

/*FINDING BUFFER CACHE CONSUMPTION OF OBJECTS*/

SELECT o.OBJECT_NAME, COUNT(*) NUMBER_OF_BLOCKS
FROM DBA_OBJECTS o, V$BH bh
WHERE o.DATA_OBJECT_ID = bh.OBJD
AND o.OWNER != 'SYS'
GROUP BY o.OBJECT_NAME
ORDER BY COUNT(*);
------------------------------------------------------------------------------------------------------------

/*FINDING CORRUPT OBJECT*/
select owner,segment_name,segment_type from dba_extents
 where file_id=&file_id and &BLOCK_ID between block_id and block_id + blocks - 1;

------------------------------------------------------------------------------------------------------------

/*FINDING SCHEMA SIZE*/

SELECT sum(bytes)/1024/1024/1024 as "Size in GB"
  FROM dba_segments
 WHERE owner = 'SCHEMA_NAME';
------------------------------------------------------------------------------------------------------------

/*TABLESPACE USAGE SCRIPT*/

SELECT /* + RULE */ df.tablespace_name "Tablespace",
df.bytes / (1024 * 1024) "Size (MB)",
SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"
FROM dba_free_space fs,
(SELECT tablespace_name,SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) df
WHERE fs.tablespace_name (+) = df.tablespace_name
GROUP BY df.tablespace_name,df.bytes
UNION ALL
SELECT /* + RULE */ df.tablespace_name tspace,
fs.bytes / (1024 * 1024),
SUM(df.bytes_free) / (1024 * 1024),
Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),
Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)
FROM dba_temp_files fs,
(SELECT tablespace_name,bytes_free,bytes_used
FROM v$temp_space_header
GROUP BY tablespace_name,bytes_free,bytes_used) df
WHERE fs.tablespace_name (+) = df.tablespace_name
GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used
ORDER BY 4 DESC;

------------------------------------------------------------------------------------------------------------

/*FINDING WHICH DATAFILE IS IN BACKUP MODE*/

select a.file#,b.name,decode(a.status,'ACTIVE','In backup mode','NOT ACTIVE','Not in backup mode') as "backup mode?"  from v$backup a , v$datafile b where a.file#=b.file#

------------------------------------------------------------------------------------------------------------

/*FINDING THE OBJECT A BLOCK BELONGS TO*/

SELECT relative_fno, owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = &file
AND &block BETWEEN block_id AND block_id + blocks - 1;

------------------------------------------------------------------------------------------------------------

/*FINDING BLOCK NO FROM ROWID*/

select  dbms_rowid.rowid_block_number(rowid)
      from TABLE_NAME;

------------------------------------------------------------------------------------------------------------

/*FINDING BIG TABLES BY BLOCKS-- in this example top 30*/

select t.owner, t.table_name, t.occupied_blocks
from
(select owner, table_name, blocks-empty_blocks occupied_blocks
from dba_tables
order by 3 desc nulls last) t
where rownum <=30

------------------------------------------------------------------------------------------------------------

/*FINDING BIG TABLES BY ROWS -- in this example top 30*/


select t.owner, t.table_name, t.num_rows
from
(select owner, table_name, num_rows
from dba_tables
order by 3 desc nulls last) t
where rownum <=30


------------------------------------------------------------------------------------------------------------

/*FINDING TABLES WITH LOB, LONG and LONG RAW*/


SELECT '------ Tables With CLOB, BLOB, LONG, NCLOB or LONG RAW Columns in the Schema: '||:b0
FROM dual;
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM dba_tab_columns
WHERE OWNER = :b0
AND data_type in ('CLOB', 'BLOB', 'LONG', 'LONG RAW', 'NCLOB')

------------------------------------------------------------------------------------------------------------

/*FINDING CONTINUOUS FREE SPACE*/


CREATE TABLE t_contig_space (
tablespace_name VARCHAR2(30),
file_id NUMBER,
block_id NUMBER,
starting_file_id NUMBER,
starting_block_id NUMBER,
blocks NUMBER,
bytes NUMBER)
tablespace uwdata;

CREATE OR REPLACE VIEW v_contig_space AS
SELECT SUBSTR(tablespace_name,1,20) TABLESPACE_NAME,
starting_file_id, starting_block_id, SUM(blocks) sum_blocks,
COUNT(blocks) count_blocks, MAX(blocks) max_blocks,
SUM(bytes)/1024/1024 SUM_MB
FROM tl_contig_space
GROUP BY tablespace_name, starting_file_id, starting_block_id;

DECLARE
 CURSOR query IS
 SELECT *
 FROM dba_free_space
 ORDER BY tablespace_name, file_id, block_id;

 this_row     query%ROWTYPE;
 previous_row query%ROWTYPE;
 old_file_id  PLS_INTEGER;
 old_block_id PLS_INTEGER;
BEGIN
  OPEN query;
  FETCH query INTO this_row;
  previous_row := this_row;
  old_file_id := previous_row.file_id;
  old_block_id := previous_row.block_id;

  WHILE query%FOUND LOOP
    IF this_row.file_id = previous_row.file_id AND
      this_row.block_id = previous_row.block_id+previous_row.blocks
    THEN
      INSERT INTO tl_contig_space
      (tablespace_name, file_id, block_id, starting_file_id,
       starting_block_id, blocks, bytes)
      VALUES
      (previous_row.tablespace_name, previous_row.file_id,
       this_row.block_id, old_file_id, old_block_id, this_row.blocks,
       this_row.bytes);
    ELSE
      INSERT INTO tl_contig_space
      (tablespace_name, file_id, block_id, starting_file_id,
       starting_block_id, blocks, bytes)
      VALUES
      (this_row.tablespace_name, this_row.file_id,
       this_row.block_id, this_row.file_id, this_row.block_id,
       this_row.blocks, this_row.bytes);

      old_file_id := this_row.file_id;
      old_block_id := this_row.block_id;
    END IF;
    previous_row := this_row;
    FETCH query INTO this_row;
  END LOOP;
  COMMIT;
END;
/
col tablespace_name format a20
col sum_mb format 999.999
SELECT * FROM v_contig_space;

------------------------------------------------------------------------------------------------------------

/*FINDING PARAMETER FILE USED PFILE OR SPFILE?*/

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';

or

select decode(count(*), 1, 'spfile', 'pfile' ) from v$spparameter where rownum=1 and isspecified='TRUE';

------------------------------------------------------------------------------------------------------------

/*DIRECT DB LINK CREATION*/


create  database link oracle11
connect to ljcatt identified by ljcatt
using ‘(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.103)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl11g)
)
)’;

------------------------------------------------------------------------------------------------------------

/*CLOSING A DB LINK*/

/*To be able to close the dblink, all the cursor related to that dblink should be closed. In addition all the transactions that use this dblink should be completed by commit or rollback.*/


exec DBMS_SESSION.CLOSE_DATABASE_LINK ('DBLINK_ISMI.WORLD');


------------------------------------------------------------------------------------------------------------


/*DBWR -- BUFFER INFORMATION*, how many dirty buffer are present?*/

select dirty, count(*) from v$bh group by dirty;

------------------------------------------------------------------------------------------------------------

/*TO DUMP FILE HEADERS*/

alter session set events 'immediate trace name FILE_HDRS level 10';

------------------------------------------------------------------------------------------------------------

/*FINDING RECENTLY EXECUTED SQLs FOR A SESSION and some statistics about them */


select s.username curr_user, s.machine, sql_text, executions,
round(decode(executions,0,0,(disk_reads/executions))) reads_per,
round(decode(executions,0,0,(buffer_gets/executions))) buff_per,
round(decode(executions,0,0,(rows_processed/executions))) rows_per,
first_load_time
from v$sqlarea v, dba_users d, v$session s
where d.user_id = v.parsing_user_id
and s.sql_address=v.address and s.sql_hash_value=v.hash_value
and s.sid=&session_id
order by decode(executions,0,0,(rows_processed/executions)) desc;

------------------------------------------------------------------------------------------------------------

/*FINDING HIDDEN PARAMETER values*/

select a.ksppinm name,
b.ksppstvl value,
b.ksppstdf deflt,
decode
(a.ksppity, 1,
'boolean', 2,
'string', 3,
'number', 4,
'file', a.ksppity) type,
a.ksppdesc description
from
sys.x$ksppi a,
sys.x$ksppcv b
where
a.indx = b.indx
and
a.ksppinm like '\_%' escape '\'
order by
name

------------------------------------------------------------------------------------------------------------

/*IDLE SESSIONS FOR MORE THAN 1 HOUR*/


select sid,serial#,username,trunc
(last_call_et/3600,2)||' hr'
last_call_et
from V$session where
last_call_et > 3600 and username is not null

------------------------------------------------------------------------------------------------------------

/*FINDING TABLE FRAGMENTATION*/


SQL> select table_name,round((blocks*8),2)||'kb' "size"
 from user_tables
 where table_name = 'BIG1';

TABLE_NAME size
------------------------------ ------------------------------------------
BIG1 72952kb

Actual data in table:


SQL> select table_name,round((num_rows*avg_row_len/1024),2)||'kb' "size"
 from user_tables
 where table_name = 'BIG1';
TABLE_NAME                     size
------------------------------ ------------------------------------------
BIG1                           30604.2kb

729952 - 30604 = table fragmentation (in kb)

OR

select table_name,round((blocks*8),2) "size (kb)" , round((num_rows*avg_row_len/1024),2) "actual_data (kb)", (round((blocks*8),2) - round((num_rows*avg_row_len/1024),2)) "wasted_space (kb)" from dba_tables where (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2)) order by 4 desc;

-------------------------------------------------------------------------------------------------------------


/*FINDING THE SESSION -- CAUSE OF LIBRARY CACHE PIN WAIT*/


select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
                      4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
                      7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
                      11, 'PACKAGE BODY', 12, 'TRIGGER',
                      13, 'TYPE', 14, 'TYPE BODY',
                      19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB',
                      22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
                      28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE',
                      32, 'INDEXTYPE', 33, 'OPERATOR',
                      34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
                      40, 'LOB PARTITION', 41, 'LOB SUBPARTITION',
                      42, 'MATERIALIZED VIEW',
                      43, 'DIMENSION',
                      44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN',
                      48, 'CONSUMER GROUP',
                      51, 'SUBSCRIPTION', 52, 'LOCATION',
                      55, 'XML SCHEMA', 56, 'JAVA DATA',
                      57, 'SECURITY PROFILE', 59, 'RULE',
                      62, 'EVALUATION CONTEXT',
                     'UNDEFINED') object_type,
       lob.KGLNAOBJ object_name,
       pn.KGLPNMOD lock_mode_held,
       pn.KGLPNREQ lock_mode_requested,
       ses.sid,
       ses.serial#,
       ses.username
  FROM
       x$kglpn pn,
       v$session ses,
       x$kglob lob,
       v$session_wait vsw
  WHERE
   pn.KGLPNUSE = ses.saddr and
   pn.KGLPNHDL = lob.KGLHDADR
   and lob.kglhdadr = vsw.p1raw
   and vsw.event = 'library cache pin'
order by lock_mode_held desc

-------------------------------------------------------------------------------------------------------------

/*FINDING THE LOCKS DISPLAYED WITH ACTUAL LOCK NAME */

select sid,
  DECODE(TYPE, 
  'BL','Buffer hash table', 
  'CF','Control File Transaction', 
  'CI','Cross Instance Call', 
  'CS','Control File Schema', 
  'CU','Bind Enqueue', 
  'DF','Data File', 
  'DL','Direct-loader index-creation', 
  'DM','Mount/startup db primary/secondary instance', 
  'DR','Distributed Recovery Process', 
  'DX','Distributed Transaction Entry', 
  'FI','SGA Open-File Information', 
  'FS','File Set', 
  'IN','Instance Number', 
  'IR','Instance Recovery Serialization', 
  'IS','Instance State', 
  'IV','Library Cache InValidation', 
  'JQ','Job Queue', 
  'KK','Redo Log "Kick"', 
  'LS','Log Start/Log Switch', 
  'MB','Master Buffer hash table', 
  'MM','Mount Definition', 
  'MR','Media Recovery', 
  'PF','Password File', 
  'PI','Parallel Slaves', 
  'PR','Process Startup', 
  'PS','Parallel Slaves Synchronization', 
  'RE','USE_ROW_ENQUEUE Enforcement', 
  'RT','Redo Thread', 
  'RW','Row Wait', 
  'SC','System Commit Number', 
  'SH','System Commit Number HWM', 
  'SM','SMON', 
  'SQ','Sequence Number', 
  'SR','Synchronized Replication', 
  'SS','Sort Segment', 
  'ST','Space Transaction', 
  'SV','Sequence Number Value', 
  'TA','Transaction Recovery', 
  'TD','DDL enqueue', 
  'TE','Extend-segment enqueue', 
  'TM','DML enqueue', 
  'TS','Temporary Segment', 
  'TT','Temporary Table', 
  'TX','Transaction', 
  'UL','User-defined Lock', 
  'UN','User Name', 
  'US','Undo Segment Serialization', 
  'WL','Being-written redo log instance', 
  'WS','Write-atomic-log-switch global enqueue', 
  'XA','Instance Attribute', 
  'XI','Instance Registration', 
decode(substr(TYPE,1,1), 
  'L','Library Cache ('||substr(TYPE,2,1)||')', 
  'N','Library Cache Pin ('||substr(TYPE,2,1)||')', 
  'Q','Row Cache ('||substr(TYPE,2,1)||')', 
  '????')) TYPE, 
id1,id2,
decode(lmode,
  0,'None(0)',
  1,'Null(1)',
  2,'Row Share(2)',
  3,'Row Exclu(3)',
  4,'Share(4)',
  5,'Share Row Ex(5)',
  6,'Exclusive(6)') lmode,
decode(request,
  0,'None(0)',
  1,'Null(1)',
  2,'Row Share(2)',
  3,'Row Exclu(3)',
  4,'Share(4)',
  5,'Share Row Ex(5)',
  6,'Exclusive(6)') request1,
ctime, block
from 
  v$lock 
where sid>5
and type not in ('MR','RT')
order by decode(request,0,0,2),block,5
/

-------------------------------------------------------------------------------------------------------------

/*FINDING THE ARCHIVELOGS GENERATED FOR LAST 7  DAYS */

select to_char(first_time, 'mm/dd') ArchiveDate,
       sum(BLOCKS*BLOCK_SIZE/1024/1024) LOGMB
from v$archived_log
where first_time > sysdate - 7
group by to_char(first_time, 'mm/dd')
order by to_char(first_time, 'mm/dd');

-------------------------------------------------------------------------------------------------------------

/*LOG SWITCH FREQUENCY */

SELECT SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),1,5) DAY, 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'00',1,0)),'99') "00", 
TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'01',1,0)),'99') "01", 
  TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'02',1,0)),'99') "02", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'03',1,0)),'99') "03", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'04',1,0)),'99') "04", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'05',1,0)),'99') "05", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'06',1,0)),'99') "06", 
  TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'07',1,0)),'99') "07", 
TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'08',1,0)),'99') "08", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'09',1,0)),'99') "09", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'10',1,0)),'99') "10", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'11',1,0)),'99') "11", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'12',1,0)),'99') "12", 
  TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'13',1,0)),'99') "13", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'14',1,0)),'99') "14", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'15',1,0)),'99') "15", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'16',1,0)),'99') "16", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'17',1,0)),'99') "17", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'18',1,0)),'99') "18", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'19',1,0)),'99') "19", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'20',1,0)),'99') "20", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'21',1,0)),'99') "21", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'22',1,0)),'99') "22", 
    TO_CHAR(SUM(DECODE(SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),10,2),'23',1,0)),'99') "23" 
FROM V$LOG_HISTORY 
where first_time > sysdate - 30
GROUP  BY SUBSTR(TO_CHAR(FIRST_TIME, 'MM-DD-YY HH:MI:SS'),1,5) ;

-------------------------------------------------------------------------------------------------------------

/*PLATFORM ENDIAN INFORMATION */

select * from v$transportable_platform; 

PLATFORM_ID   PLATFORM_NAME                      ENDIAN_FORMAT 
-----------   ------------------------------     -------------- 
1             Solaris[tm] OE (32-bit)            Big 
2             Solaris[tm] OE (64-bit)            Big 
7             Microsoft Windows NT           Little 
10            Linux IA (32-bit)                    Little 
6             AIX-Based Systems (64-bit)      Big 
3             HP-UX (64-bit)                        Big 
5             HP Tru64 UNIX                      Little 
4             HP-UX IA (64-bit)                    Big 
11            Linux IA (64-bit)                     Little 
15            HP Open VMS                        Little 
8             Microsoft Windows IA (64-bit)      Little 
9             IBM zSeries Based Linux            Big 
13            Linux 64-bit for AMD               Little 
16            Apple Mac OS                       Big 
12            Microsoft Windows 64-bit for AMD   Little

-------------------------------------------------------------------------------------------------------------

/* READ BY OTHER SESSION WAIT -- > FINDING  HOT OBJECT */

To find the contetion;

SELECT p1 "file#", p2 "block#", p3 "class#"
FROM v$session_wait
WHERE event = 'read by other session';

To find the hot segment; take input from the output of the above query and run the following sql;


SELECT relative_fno, owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = &file
AND &block BETWEEN block_id AND block_id + blocks - 1;

-------------------------------------------------------------------------------------------------------------

/* FILE HEADER INFORMATION FROM x$kcvfh  FOR RECOVERY */

select hxfil FILENUMBER,fhsta STATUS,fhscn SCN,fhrba_Seq SEQUENCE from x$kcvfh


4 -> fuzzy (backup problem)
1-> need recovery (apply more redo)
0 -> Recovery complete (ok ready to open)
8192 -> system datafile status when db is mounted
8916 -> system datafile status when db is opened.
..etc...

-------------------------------------------------------------------------------------------------------------

/* RMAN BACKUP TIMED STATS*/

Backup job history ordered by session key, which is the primary key for the RMAN session:

SELECT SESSION_KEY, INPUT_TYPE, STATUS,
       TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
       TO_CHAR(END_TIME,'mm/dd/yy hh24:mi')   end_time,
       ELAPSED_SECONDS/3600                   hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;
The following sample output sh


Backup job speed ordered by session key, which the primary key for the RMAN session. in_sec and out_sec columns display the data input and output per second.

SELECT SESSION_KEY, 
       OPTIMIZED, 
       COMPRESSION_RATIO, 
       INPUT_BYTES_PER_SEC_DISPLAY in_sec,
       OUTPUT_BYTES_PER_SEC_DISPLAY out_sec, 
       TIME_TAKEN_DISPLAY
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

Backup job speed ordered by session key, which the primary key for the RMAN session. in_sec , out_sec columns display the data input and output per second.

SELECT SESSION_KEY, 
       INPUT_TYPE,
       COMPRESSION_RATIO, 
       INPUT_BYTES_DISPLAY in_size,
       OUTPUT_BYTES_DISPLAY out_size
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

-------------------------------------------------------------------------------------------------------------

/* FINDING PRIVILEGES  GRANTED TO A ROLE*/

select role, 'ROL' type, granted_role pv 
from role_role_privs where role like '%&rolecheck%' union 
select role, 'PRV' type, privilege pv 
from role_sys_privs where role like '%&rolecheck%' union
select role, 'OBJ' type, 
max(decode(privilege,'WRITE','WRITE,'))||max(decode(privilege,'READ','READ'))||
max(decode(privilege,'EXECUTE','EXECUTE'))||max(decode(privilege,'SELECT','SELECT'))||
max(decode(privilege,'DELETE',',DELETE'))||max(decode(privilege,'UPDATE',',UPDATE'))||
max(decode(privilege,'INSERT',',INSERT'))||' ON '||object_type||' "'||a.owner||'.'||table_name||'"' pv 
from role_tab_privs a, dba_objects b 
where role like '%&rolecheck%' and a.owner=b.owner and a.table_name=b.object_name
group by a.owner,table_name,object_type,role union
select role, '---' type, 'this is an empty role ---' pv from dba_roles 
where not role in (select distinct role from role_role_privs) and
not role in (select distinct role from role_sys_privs) and 
not role in (select distinct role from role_tab_privs) and role like '%&rolecheck%'
group by role order by role, type, pv;

-------------------------------------------------------------------------------------------------------------

/* FINDING OBJECT ID , FILE NUMBER, BLOCK NUMBER FROM ROWID*/

ROWID=AAAGoeAAAHAAAAAXAAA

select rowid as therowid, id,
  to_number(utl_encode.base64_decode(utl_raw.cast_to_raw(lpad(substr(rowid,1, 6), 8, 'A'))), 'XXXXXXXXXXXX') as objid,
  to_number(utl_encode.base64_decode(utl_raw.cast_to_raw(lpad(substr(rowid, 7, 3), 4, 'A'))), 'XXXXXX') as filenum,
  to_number(utl_encode.base64_decode(utl_raw.cast_to_raw(lpad(substr(rowid, 10, 6), 8, 'A'))), 'XXXXXXXXXXXX') as blocknum,
  to_number(utl_encode.base64_decode(utl_raw.cast_to_raw(lpad(substr(rowid, 16, 3), 4, 'A'))), 'XXXXXX') as rowslot
  from t where id <= 2

-------------------------------------------------------------------------------------------------------------

/* FINDING LAST ACTIVE TIME OF SESSIONS*/

set lines 100 pages 999
select username
,      floor(last_call_et / 60) "Minutes"
,      status
from   v$session
where  username is not null
order by last_call_et
/

-------------------------------------------------------------------------------------------------------------

/* FINDING SHARED POOL/POORLY TUNED SQL INFORMATION*/

SQL WITH HIGH VERSION COUNT
--------------------------------------

SELECT address, hash_value,
version_count ,
users_opening ,
users_executing,
substr(sql_text,1,40) "SQL"
FROM v$sqlarea
WHERE version_count > 10
;


SQL WITH HIGH SHARED POOL MEMORY USAGE
--------------------------------------------------------

SELECT substr(sql_text,1,40) "Stmt", count(*),
sum(sharable_mem) "Mem",
sum(users_opening) "Open",
sum(executions) "Exec"
FROM v$sql
GROUP BY substr(sql_text,1,40)
HAVING sum(sharable_mem) > <MEMSIZE>


SQL CAUSES UNLOAD OF OTHER OBJECTS FROM SHAREDPOOL
-_------------------------------------------------------
SELECT *
FROM x$ksmlru
WHERE ksmlrnum>0




LITERAL SQLS
----------------------------------------------------------
SELECT substr(sql_text,1,40) "SQL",
count(*) ,
sum(executions) "TotExecs"
FROM v$sqlarea
WHERE executions < 5
GROUP BY substr(sql_text,1,40)
HAVING count(*) > 30
ORDER BY 2


LIBRARY CACHE HIT RATIO
--------------------------------------------------------
SELECT SUM(PINS) "EXECUTIONS",
SUM(RELOADS) "CACHE MISSES WHILE EXECUTING"
FROM V$LIBRARYCACHE;

HASH CHAIN LENGTH
-----------------------------------------------------------
SELECT hash_value, count(*)
FROM v$sqlarea
GROUP BY hash_value
HAVING count(*) > 5;

-------------------------------------------------------------------------------------------------------------

/* FIND OS PROCESS ID FROM SID */

select a.sid,a.serial#,c.spid,a.osuser,a.machine,a.program,b.sql_text
from v$session a,v$sqlarea b,v$process c
where a.sql_hash_value=b.hash_value and
a.sid=&sid
and a.paddr=c.addr

-------------------------------------------------------------------------------------------------------------

/* STANDBY TRANSFER GAP CONTROL -- executed in Primary*/

select (CASE WHEN to_char(count(sequence#)) = '0'
THEN 'no problems/no gap in transfer' ELSE 'There are '||to_char(count(sequence#))|| ' archives, still not transffered to standby' END ) as "TRANSFER GAP CONTROL"
from
(select sequence#
from v$archived_log
where standby_dest='NO' and sequence# > 81302
minus
select sequence#
from v$archived_log
where standby_dest='YES'
minus
select min(sequence#) from v$archived_log);

-------------------------------------------------------------------------------------------------------------

/* STANDBY TRANSFER APPLY CONTROL -- executed in Primary*/

SELECT
(CASE WHEN to_char(a.ARCHIVED_SEQ#-APPLIED_SEQ#)='0'
THEN 'no problems/no gap in apply' ELSE 'There are '||to_char(a.ARCHIVED_SEQ#-a.APPLIED_SEQ#)|| ' archives, still not applied to standby' END) as "APPLIED GAP COUNT"
FROM V$ARCHIVE_DEST_STATUS a where dest_name='LOG_ARCHIVE_DEST_2';

Note: dest_name depends on your configuration.

-------------------------------------------------------------------------------------------------------------

/* STANDBY PROCESS CONTROL -- executed in standby*/

select process ,block#,sequence#,status from v$managed_standby;


PROCESS       BLOCK#  SEQUENCE# STATUS
--------- ---------- ---------- ------------
ARCH               0          0 CONNECTED
ARCH               0          0 CONNECTED
MRP0               0       9008 WAIT_FOR_LOG
RFS           102398       8999 RECEIVING
RFS           102397       9007 ATTACHED

-------------------------------------------------------------------------------------------------------------

/*GENERATING TABLE STATS SCRIPT FOR MULTIPLE TABLES*/ 

declare
sql_string varchar2(2000);
CURSOR C1 IS
select owner,table_name
from dba_tables
where last_analyzed is null 
and table_name like '%ERMAN%';
begin
for REC1 IN C1 LOOP
DBMS_OUTPUT.PUT_LINE('EXEC DBMS_STATS.GATHER_TABLE_STATS ('''||REC1.owner||''','''||REC1.table_name||''');');
END LOOP;
END;
/

-------------------------------------------------------------------------------------------------------------

/* TRIM FUNCTION USAGE EXAMPLE */

--TRIM SS and _ characters
select 'create public synonym '|| trim('_' from trim('S' from object_name) )||' for ' ||owner||'.'||object_name|| ';' from dba_objects where object_type='TABLE' and object_name like '%SS_%' and owner in ('SNAP') 


-------------------------------------------------------------------------------------------------------------

/* UNDO INFORMATION -- DIAGNOSIS */


/*Sql with high elapsed time -- undo retention should be set according to this queries*/

select s.sql_text "Sql",u.maxquerylen
from v$undostat u , v$sql s
where s.sql_id=u.maxqueryid
order by maxquerylen desc

/*Are there any Snapshot too old erros ?  -- configure undo retention higher or maybe increase the size of undo tbs.*/

select s.sql_text "Sql",u.ssolderrcnt "ORA-01555 count"
from v$undostat u , v$sql s
where s.sql_id=u.maxqueryid
order by ssolderrcnt desc


/* Queries with error because of insufficient undo  */

select begin_time "start", end_time "end", undoblks "total used undo #undoBlock "
, txncount "Transaction count", maxconcurrency as "concurrent sqls"
,nospaceerrcnt "errors insufficient undo", s.sql_text "sql" from V$UNDOSTAT u , v$sql s
where s.sql_id=u.maxqueryid order by undoblks desc ;


/*undo db parameters */
select * from v$parameter where name like 'undo%'


/*Find corrupt block */

select * from dba_rollback_segs  where status like '%RECOVERY'; ile bak

If there are corrupt undos that prevent you to open the database;

you can ingore it by setting the following in parameter file
_corrupted_rollback_segments =('_SYSSMU38$')
After that you can open the database , and then drop that undo segment;
drop rollback segment "_SYSSMU20$";

/* Sessions using undo */

SELECT  a.sid, a.username, b.used_urec, b.used_ublkFROM v$session a, v$transaction bWHERE a.saddr = b.ses_addrORDER BY b.used_ublk DESC

*/ Finding the optimal value for undo retention*/


SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]",
       SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]",
       (TO_NUMBER(e.value) * TO_NUMBER(f.value) *
       g.undo_block_per_sec) / (1024*1024)
       "NEEDED UNDO SIZE [MByte]"
  FROM (
       SELECT SUM(a.bytes) undo_size
         FROM v$datafile a,
              v$tablespace b,
              dba_tablespaces c
        WHERE c.contents = 'UNDO'
          AND c.status = 'ONLINE'
          AND b.name = c.tablespace_name
          AND a.ts# = b.ts#
       ) d,
       v$parameter e,
       v$parameter f,
       (
       SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
          undo_block_per_sec
         FROM v$undostat
       ) g
 WHERE e.name = 'undo_retention'
  AND f.name = 'db_block_size'
/



-------------------------------------------------------------------------------------------------------------

/* UTL TCP CONNECTION EXAMPLE */



Making tcp connection using utl_tcp ;

DECLARE
           c utl_tcp.connection;
            n number;
    BEGIN
            c := utl_tcp.open_connection('10.5.0.241',
                                    25);
                                 

           utl_tcp.close_connection(c);
   END;


*/Tcp ping function for diagnosing the tcp connection; */

create or replace function tcpPing( ipAddress varchar2, portNum number)  return varchar2  is
           socket  utl_tcp.connection;
            t1      timestamp with local time zone;
    begin
            t1 := systimestamp;
           socket := utl_tcp.Open_Connection(
                           remote_host     => ipAddress,
                           remote_port     => portNum,
                           tx_timeout      => 5
                  );
          utl_tcp.Close_Connection( socket );

          return( ipAddress||':'||TO_CHAR(portNum)||' reached the server.. ('|| TO_CHAR(systimestamp-t1) ||')' );

  exception when OTHERS then
          return( ipAddress||':'||TO_CHAR(portNum)||' server could not be reached. ('||SQLERRM(SQLCODE)||')' );
   end;
   /


Usage:  select tcpPing( '10.5.0.241', 25 ) as STATUS from dual;


-------------------------------------------------------------------------------------------------------------

/* FINDING HIDDEN PARAMETERS VALUES  */


select a.ksppinm name,
b.ksppstvl value,
b.ksppstdf deflt,
decode
(a.ksppity, 1,
'boolean', 2,
'string', 3,
'number', 4,
'file', a.ksppity) type,
a.ksppdesc description
from
sys.x$ksppi a,
sys.x$ksppcv b
where
a.indx = b.indx
and
a.ksppinm like '\_%' escape '\'
order by
name


-------------------------------------------------------------------------------------------------------------

/*STANDBY SEQUENCE CONTROL */ 

select sequence#
from v$archived_log
where standby_dest='NO'
minus
select sequence#
from v$archived_log
where standby_dest='YES'
minus
select min(sequence#) from v$archived_log

-------------------------------------------------------------------------------------------------------------

/*STANDBY PROCESS CONTROL */ 
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

-------------------------------------------------------------------------------------------------------------

*/CHECK FOR DEFAULT PASSWORDS*/

SELECT
  username "Account Name", account_status "Account Status"
FROM sys.dba_users
WHERE (username, password) IN (
  ('AASH',  '9B52488370BB3D77'),
  ('ABA1',  '30FD307004F350DE'),
  ('ABM',  'D0F2982F121C7840'),
  ('AD_MONITOR',  '54F0C83F51B03F49'),
  ('ADAMS',  '72CDEF4A3483F60D'),
  ('ADS',  'D23F0F5D871EB69F'),
  ('ADSEUL_US',  '4953B2EB6FCB4339'),
  ('AHL',  '7910AE63C9F7EEEE'),
  ('AHM',  '33C2E27CF5E401A4'),
  ('AK',  '8FCB78BBA8A59515'),
  ('AL',  '384B2C568DE4C2B5'),
  ('ALA1',  '90AAC5BD7981A3BA'),
  ('ALLUSERS',  '42F7CD03B7D2CA0F'),
  ('ALR',  'BE89B24F9F8231A9'),
  ('AMA1',  '585565C23AB68F71'),
  ('AMA2',  '37E458EE1688E463'),
  ('AMA3',  '81A66D026DC5E2ED'),
  ('AMA4',  '194CCC94A481DCDE'),
  ('AMF',  'EC9419F55CDC666B'),
  ('AMS',  'BD821F59270E5F34'),
  ('AMS1',  'DB8573759A76394B'),
  ('AMS2',  'EF611999C6AD1FD7'),
  ('AMS3',  '41D1084F3F966440'),
  ('AMS4',  '5F5903367FFFB3A3'),
  ('AMSYS',  '4C1EF14ECE13B5DE'),
  ('AMV',  '38BC87EB334A1AC4'),
  ('AMW',  '0E123471AACA2A62'),
  ('ANNE',  '1EEA3E6F588599A6'),
  ('ANONYMOUS',  '94C33111FD9C66F3'),
  ('AOLDEMO',  'D04BBDD5E643C436'),
  ('AP',  'EED09A552944B6AD'),
  ('APA1',  'D00197BF551B2A79'),
  ('APA2',  '121C6F5BD4674A33'),
  ('APA3',  '5F843C0692560518'),
  ('APA4',  'BF21227532D2794A'),
  ('APPLEAD',  '5331DB9C240E093B'),
  ('APPLSYS',  '0F886772980B8C79'),
  ('APPLSYS',  'E153FFF4DAE6C9F7'),
  ('APPLSYSPUB',  'D2E3EF40EE87221E'),
  ('APPS',  'D728438E8A5925E0'),
  ('APS1',  'F65751C55EA079E6'),
  ('APS2',  '5CACE7B928382C8B'),
  ('APS3',  'C786695324D7FB3B'),
  ('APS4',  'F86074C4F4F82D2C'),
  ('AQDEMO',  '5140E342712061DD'),
  ('AQJAVA',  '8765D2543274B42E'),
  ('AQUSER',  '4CF13BDAC1D7511C'),
  ('AR',  'BBBFE175688DED7E'),
  ('ARA1',  '4B9F4E0667857EB8'),
  ('ARA2',  'F4E52BFBED4652CD'),
  ('ARA3',  'E3D8D73AE399F7FE'),
  ('ARA4',  '758FD31D826E9143'),
  ('ARS1',  '433263ED08C7A4FD'),
  ('ARS2',  'F3AF9F26D0213538'),
  ('ARS3',  'F6755F08CC1E7831'),
  ('ARS4',  '452B5A381CABB241'),
  ('ART',  '665168849666C4F3'),
  ('ASF',  'B6FD427D08619EEE'),
  ('ASG',  '1EF8D8BD87CF16BE'),
  ('ASL',  '03B20D2C323D0BFE'),
  ('ASN',  '1EE6AEBD9A23D4E0'),
  ('ASO',  'F712D80109E3C9D8'),
  ('ASP',  'CF95D2C6C85FF513'),
  ('AST',  'F13FF949563EAB3C'),
  ('AUC_GUEST',  '8A59D349DAEC26F7'),
  ('AURORA$ORB$UNAUTHENTICATED',  '80C099F0EADF877E'),
  ('AUTHORIA',  'CC78120E79B57093'),
  ('AX',  '0A8303530E86FCDD'),
  ('AZ',  'AAA18B5D51B0D5AC'),
  ('B2B',  'CC387B24E013C616'),
  ('BAM',  '031091A1D1A30061'),
  ('BCA1',  '398A69209360BD9D'),
  ('BCA2',  '801D9C90EBC89371'),
  ('BEN',  '9671866348E03616'),
  ('BIC',  'E84CC95CBBAC1B67'),
  ('BIL',  'BF24BCE2409BE1F7'),
  ('BIM',  '6026F9A8A54B9468'),
  ('BIS',  '7E9901882E5F3565'),
  ('BIV',  '2564B34BE50C2524'),
  ('BIX',  '3DD36935EAEDE2E3'),
  ('BLAKE',  '9435F2E60569158E'),
  ('BMEADOWS',  '2882BA3D3EE1F65A'),
  ('BNE',  '080B5C7EE819BF78'),
  ('BOM',  '56DB3E89EAE5788E'),
  ('BP01',  '612D669D2833FACD'),
  ('BP02',  'FCE0C089A3ECECEE'),
  ('BP03',  '0723FFEEFBA61545'),
  ('BP04',  'E5797698E0F8934E'),
  ('BP05',  '58FFC821F778D7E9'),
  ('BP06',  '2F358909A4AA6059'),
  ('BSC',  'EC481FD7DCE6366A'),
  ('BUYACCT',  'D6B388366ECF2F61'),
  ('BUYAPPR1',  'CB04931693309228'),
  ('BUYAPPR2',  '3F98A3ADC037F49C'),
  ('BUYAPPR3',  'E65D8AD3ACC23DA3'),
  ('BUYER',  '547BDA4286A2ECAE'),
  ('BUYMTCH',  '0DA5E3B504CC7497'),
  ('CAMRON',  '4384E3F9C9C9B8F1'),
  ('CANDICE',  'CF458B3230215199'),
  ('CARL',  '99ECCC664FFDFEA2'),
  ('CARLY',  'F7D90C099F9097F1'),
  ('CARMEN',  '46E23E1FD86A4277'),
  ('CARRIECONYERS',  '9BA83B1E43A5885B'),
  ('CATADMIN',  'AF9AB905347E004F'),
  ('CE',  'E7FDFE26A524FE39'),
  ('CEASAR',  'E69833B8205D5DD7'),
  ('CENTRA',  '63BF5FFE5E3EA16D'),
  ('CFD',  '667B018D4703C739'),
  ('CHANDRA',  '184503FA7786C82D'),
  ('CHARLEY',  'E500DAA705382E8D'),
  ('CHRISBAKER',  '52AFB6B3BE485F81'),
  ('CHRISTIE',  'C08B79CCEC43E798'),
  ('CINDY',  '3AB2C717D1BD0887'),
  ('CLARK',  '74DF527800B6D713'),
  ('CLARK',  '7AAFE7D01511D73F'),
  ('CLAUDE',  'C6082BCBD0B69D20'),
  ('CLINT',  '163FF8CCB7F11691'),
  ('CLN',  'A18899D42066BFCA'),
  ('CN',  '73F284637A54777D'),
  ('CNCADMIN',  'C7C8933C678F7BF9'),
  ('CONNIE',  '982F4C420DD38307'),
  ('CONNOR',  '52875AEB74008D78'),
  ('CORY',  '93CE4CCE632ADCD2'),
  ('CRM1',  '6966EA64B0DFC44E'),
  ('CRM2',  'B041F3BEEDA87F72'),
  ('CRP',  'F165BDE5462AD557'),
  ('CRPB733',  '2C9AB93FF2999125'),
  ('CRPCTL',  '4C7A200FB33A531D'),
  ('CRPDTA',  '6665270166D613BC'),
  ('CS',  'DB78866145D4E1C3'),
  ('CSADMIN',  '94327195EF560924'),
  ('CSAPPR1',  '47D841B5A01168FF'),
  ('CSC',  'EDECA9762A8C79CD'),
  ('CSD',  '144441CEBAFC91CF'),
  ('CSDUMMY',  '7A587C459B93ACE4'),
  ('CSE',  'D8CC61E8F42537DA'),
  ('CSF',  '684E28B3C899D42C'),
  ('CSI',  '71C2B12C28B79294'),
  ('CSL',  'C4D7FE062EFB85AB'),
  ('CSM',  '94C24FC0BE22F77F'),
  ('CSMIG',  '09B4BB013FBD0D65'),
  ('CSP',  '5746C5E077719DB4'),
  ('CSR',  '0E0F7C1B1FE3FA32'),
  ('CSS',  '3C6B8C73DDC6B04F'),
  ('CTXDEMO',  'CB6B5E9D9672FE89'),
  ('CTXSYS',  '24ABAB8B06281B4C'),
  ('CTXSYS',  '71E687F036AD56E5'),
  ('CTXTEST',  '064717C317B551B6'),
  ('CUA',  'CB7B2E6FFDD7976F'),
  ('CUE',  'A219FE4CA25023AA'),
  ('CUF',  '82959A9BD2D51297'),
  ('CUG',  '21FBCADAEAFCC489'),
  ('CUI',  'AD7862E01FA80912'),
  ('CUN',  '41C2D31F3C85A79D'),
  ('CUP',  'C03082CD3B13EC42'),
  ('CUS',  '00A12CC6EBF8EDB8'),
  ('CZ',  '9B667E9C5A0D21A6'),
  ('DAVIDMORGAN',  'B717BAB262B7A070'),
  ('DBSNMP',  'E066D214D5421CCC'),
  ('DCM',  '45CCF86E1058D3A5'),
  ('DD7333',  '44886308CF32B5D4'),
  ('DD7334',  'D7511E19D9BD0F90'),
  ('DD810',  '0F9473D8D8105590'),
  ('DD811',  'D8084AE609C9A2FD'),
  ('DD812',  'AB71915CF21E849E'),
  ('DD9',  'E81821D03070818C'),
  ('DDB733',  '7D11619CEE99DE12'),
  ('DDD',  '6CB03AF4F6DD133D'),
  ('DEMO8',  '0E7260738FDFD678'),
  ('DES',  'ABFEC5AC2274E54D'),
  ('DES2K',  '611E7A73EC4B425A'),
  ('DEV2000_DEMOS',  '18A0C8BD6B13BEE2'),
  ('DEVB733',  '7500DF89DC99C057'),
  ('DEVUSER',  'C10B4A80D00CA7A5'),
  ('DGRAY',  '5B76A1EB8F212B85'),
  ('DIP',  'CE4A36B8E06CA59C'),
  ('DISCOVERER5',  'AF0EDB66D914B731'),
  ('DKING',  '255C2B0E1F0912EA'),
  ('DLD',  '4454B932A1E0E320'),
  ('DMADMIN',  'E6681A8926B40826'),
  ('DMATS',  '8C692701A4531286'),
  ('DMS',  '1351DC7ED400BD59'),
  ('DMSYS',  'BFBA5A553FD9E28A'),
  ('DOM',  '51C9F2BECA78AE0E'),
  ('DPOND',  '79D6A52960EEC216'),
  ('DSGATEWAY',  '6869F3CFD027983A'),
  ('DV7333',  '36AFA5CD674BA841'),
  ('DV7334',  '473B568021BDB428'),
  ('DV810',  '52C38F48C99A0352'),
  ('DV811',  'B6DC5AAB55ECB66C'),
  ('DV812',  '7359E6E060B945BA'),
  ('DV9',  '07A1D03FD26E5820'),
  ('DVP1',  '0559A0D3DE0759A6'),
  ('EAA',  'A410B2C5A0958CDF'),
  ('EAM',  'CE8234D92FCFB563'),
  ('EC',  '6A066C462B62DD46'),
  ('ECX',  '0A30645183812087'),
  ('EDR',  '5FEC29516474BB3A'),
  ('EDWEUL_US',  '5922BA2E72C49787'),
  ('EDWREP',  '79372B4AB748501F'),
  ('EGC1',  'D78E0F2BE306450D'),
  ('EGD1',  'DA6D6F2089885BA6'),
  ('EGM1',  'FB949D5E4B5255C0'),
  ('EGO',  'B9D919E5F5A9DA71'),
  ('EGR1',  'BB636336ADC5824A'),
  ('END1',  '688499930C210B75'),
  ('ENG',  '4553A3B443FB3207'),
  ('ENI',  '05A92C0958AFBCBC'),
  ('ENM1',  '3BDABFD1246BFEA2'),
  ('ENS1',  'F68A5D0D6D2BB25B'),
  ('ENTMGR_CUST',  '45812601EAA2B8BD'),
  ('ENTMGR_PRO',  '20002682991470B3'),
  ('ENTMGR_TRAIN',  'BE40A3BE306DD857'),
  ('EOPP_PORTALADM',  'B60557FD8C45005A'),
  ('EOPP_PORTALMGR',  '9BB3CF93F7DE25F1'),
  ('EOPP_USER',  '13709991FC4800A1'),
  ('EUL_US',  '28AEC22561414B29'),
  ('EVM',  '137CEDC20DE69F71'),
  ('EXA1',  '091BCD95EE112EE3'),
  ('EXA2',  'E4C0A21DBD06B890'),
  ('EXA3',  '40DC4FA801A73560'),
  ('EXA4',  '953885D52BDF5C86'),
  ('EXFSYS',  '66F4EF5650C20355'),
  ('EXS1',  'C5572BAB195817F0'),
  ('EXS2',  '8FAA3AC645793562'),
  ('EXS3',  'E3050174EE1844BA'),
  ('EXS4',  'E963BFE157475F7D'),
  ('FA',  '21A837D0AED8F8E5'),
  ('FEM',  'BD63D79ADF5262E7'),
  ('FIA1',  '2EB76E07D3E094EC'),
  ('FII',  'CF39DE29C08F71B9'),
  ('FLM',  'CEE2C4B59E7567A3'),
  ('FNI1',  '308839029D04F80C'),
  ('FNI2',  '05C69C8FEAB4F0B9'),
  ('FPA',  '9FD6074B9FD3754C'),
  ('FPT',  '73E3EC9C0D1FAECF'),
  ('FRM',  '9A2A7E2EBE6E4F71'),
  ('FTA1',  '65FF9AB3A49E8A13'),
  ('FTE',  '2FB4D2C9BAE2CCCA'),
  ('FUN',  '8A7055CA462DB219'),
  ('FV',  '907D70C0891A85B1'),
  ('FVP1',  '6CC7825EADF994E8'),
  ('GALLEN',  'F8E8ED9F15842428'),
  ('GCA1',  '47DA9864E018539B'),
  ('GCA2',  'FD6E06F7DD50E868'),
  ('GCA3',  '4A4B9C2E9624C410'),
  ('GCA9',  '48A7205A4C52D6B5'),
  ('GCMGR1',  '14A1C1A08EA915D6'),
  ('GCMGR2',  'F4F11339A4221A4D'),
  ('GCMGR3',  '320F0D4258B9D190'),
  ('GCS',  '7AE34CA7F597EBF7'),
  ('GCS1',  '2AE8E84D2400E61D'),
  ('GCS2',  'C242D2B83162FF3D'),
  ('GCS3',  'DCCB4B49C68D77E2'),
  ('GEORGIAWINE',  'F05B1C50A1C926DE'),
  ('GL',  'CD6E99DACE4EA3A6'),
  ('GLA1',  '86C88007729EB36F'),
  ('GLA2',  '807622529F170C02'),
  ('GLA3',  '863A20A4EFF7386B'),
  ('GLA4',  'DB882CF89A758377'),
  ('GLS1',  '7485C6BD564E75D1'),
  ('GLS2',  '319E08C55B04C672'),
  ('GLS3',  'A7699C43BB136229'),
  ('GLS4',  '7C171E6980BE2DB9'),
  ('GM_AWDA',  '4A06A107E7A3BB10'),
  ('GM_COPI',  '03929AE296BAAFF2'),
  ('GM_DPHD',  '0519252EDF68FA86'),
  ('GM_MLCT',  '24E8B569E8D1E93E'),
  ('GM_PLADMA',  '2946218A27B554D8'),
  ('GM_PLADMH',  '2F6EDE96313AF1B7'),
  ('GM_PLCCA',  '7A99244B545A038D'),
  ('GM_PLCCH',  '770D9045741499E6'),
  ('GM_PLCOMA',  '91524D7DE2B789A8'),
  ('GM_PLCOMH',  'FC1C6E0864BF0AF2'),
  ('GM_PLCONA',  '1F531397B19B1E05'),
  ('GM_PLCONH',  'C5FE216EB8FCD023'),
  ('GM_PLNSCA',  'DB9DD2361D011A30'),
  ('GM_PLNSCH',  'C80D557351110D51'),
  ('GM_PLSCTA',  '3A778986229BA20C'),
  ('GM_PLSCTH',  '9E50865473B63347'),
  ('GM_PLVET',  '674885FDB93D34B9'),
  ('GM_SPO',  'E57D4BD77DAF92F0'),
  ('GM_STKH',  'C498A86BE2663899'),
  ('GMA',  'DC7948E807DFE242'),
  ('GMD',  'E269165256F22F01'),
  ('GME',  'B2F0E221F45A228F'),
  ('GMF',  'A07F1956E3E468E1'),
  ('GMI',  '82542940B0CF9C16'),
  ('GML',  '5F1869AD455BBA73'),
  ('GMP',  '450793ACFCC7B58E'),
  ('GMS',  'E654261035504804'),
  ('GR',  'F5AB0AA3197AEE42'),
  ('GUEST',  '1C0A090E404CECD0'),
  ('HCC',  '25A25A7FEFAC17B6'),
  ('HHCFO',  '62DF37933FB35E9F'),
  ('HR',  '4C6D73C3E8B0F0DA'),
  ('HRI',  '49A3A09B8FC291D0'),
  ('HXC',  '4CEA0BF02214DA55'),
  ('HXT',  '169018EB8E2C4A77'),
  ('IA',  '42C7EAFBCEEC09CC'),
  ('IBA',  '0BD475D5BF449C63'),
  ('IBC',  '9FB08604A30A4951'),
  ('IBE',  '9D41D2B3DD095227'),
  ('IBP',  '840267B7BD30C82E'),
  ('IBU',  '0AD9ABABC74B3057'),
  ('IBY',  'F483A48F6A8C51EC'),
  ('ICX',  '7766E887AF4DCC46'),
  ('IEB',  'A695699F0F71C300'),
  ('IEC',  'CA39F929AF0A2DEC'),
  ('IEM',  '37EF7B2DD17279B5'),
  ('IEO',  'E93196E9196653F1'),
  ('IES',  '30802533ADACFE14'),
  ('IEU',  '5D0E790B9E882230'),
  ('IEX',  '6CC978F56D21258D'),
  ('IGC',  'D33CEB8277F25346'),
  ('IGF',  '1740079EFF46AB81'),
  ('IGI',  '8C69D50E9D92B9D0'),
  ('IGS',  'DAF602231281B5AC'),
  ('IGW',  'B39565F4E3CF744B'),
  ('IMC',  'C7D0B9CDE0B42C73'),
  ('IMT',  'E4AAF998653C9A72'),
  ('INS1',  '2ADC32A0B154F897'),
  ('INS2',  'EA372A684B790E2A'),
  ('INTERNET_APPSERVER_REGISTRY',  'A1F98A977FFD73CD'),
  ('INV',  'ACEAB015589CF4BC'),
  ('IP',  'D29012C144B58A40'),
  ('IPA',  'EB265A08759A15B4'),
  ('IPD',  '066A2E3072C1F2F3'),
  ('ISC',  '373F527DC0CFAE98'),
  ('ISTEWARD',  '8735CA4085DE3EEA'),
  ('ITG',  'D90F98746B68E6CA'),
  ('JA',  '9AC2B58153C23F3D'),
  ('JD7333',  'FB5B8A12AE623D52'),
  ('JD7334',  '322810FCE43285D9'),
  ('JD9',  '9BFAEC92526D027B'),
  ('JDE',  '7566DC952E73E869'),
  ('JDEDBA',  'B239DD5313303B1D'),
  ('JE',  'FBB3209FD6280E69'),
  ('JG',  '37A99698752A1CF1'),
  ('JL',  '489B61E488094A8D'),
  ('JOHNINARI',  'B3AD4DA00F9120CE'),
  ('JONES',  'B9E99443032F059D'),
  ('JTF',  '5C5F6FC2EBB94124'),
  ('JTI',  'B8F03D3E72C96F71'),
  ('JTM',  '6D79A2259D5B4B5A'),
  ('JTR',  'B4E2BE38B556048F'),
  ('JTS',  '4087EE6EB7F9CD7C'),
  ('JUNK_PS',  'BBC38DB05D2D3A7A'),
  ('JUSTOSHUM',  '53369CD63902FAAA'),
  ('KELLYJONES',  'DD4A3FF809D2A6CF'),
  ('KEVINDONS',  '7C6D9540B45BBC39'),
  ('KPN',  'DF0AED05DE318728'),
  ('LADAMS',  'AE542B99505CDCD2'),
  ('LBA',  '18E5E15A436E7157'),
  ('LBACSYS',  'AC9700FD3F1410EB'),
  ('LDQUAL',  '1274872AB40D4FCD'),
  ('LHILL',  'E70CA2CA0ED555F5'),
  ('LNS',  'F8D2BC61C10941B2'),
  ('LQUINCY',  '13F9B9C1372A41B6'),
  ('LSA',  '2D5E6036E3127B7E'),
  ('MDDATA',  'DF02A496267DEE66'),
  ('MDSYS',  '72979A94BAD2AF80'),
  ('MDSYS',  '9AAEB2214DCC9A31'),
  ('ME',  'E5436F7169B29E4D'),
  ('MFG',  'FC1B0DD35E790847'),
  ('MGR1',  'E013305AB0185A97'),
  ('MGR2',  '5ADE358F8ACE73E8'),
  ('MGR3',  '05C365C883F1251A'),
  ('MGR4',  'E229E942E8542565'),
  ('MIKEIKEGAMI',  'AAF7A168C83D5C47'),
  ('MJONES',  'EE7BB3FEA50A21C5'),
  ('MLAKE',  '7EC40274AC1609CA'),
  ('MM1',  '4418294570E152E7'),
  ('MM2',  'C06B5B28222E1E62'),
  ('MM3',  'A975B1BD0C093DA3'),
  ('MM4',  '88256901EB03A012'),
  ('MM5',  '4CEA62CBE776DCEC'),
  ('MMARTIN',  'D52F60115FE87AA4'),
  ('MOBILEADMIN',  '253922686A4A45CC'),
  ('MRP',  'B45D4DF02D4E0C85'),
  ('MSC',  '89A8C104725367B2'),
  ('MSD',  '6A29482069E23675'),
  ('MSO',  '3BAA3289DB35813C'),
  ('MSR',  'C9D53D00FE77D813'),
  ('MST',  'A96D2408F62BE1BC'),
  ('MWA',  '1E2F06BE2A1D41A6'),
  ('NEILKATSU',  '1F625BB9FEBC7617'),
  ('OBJ7333',  'D7BDC9748AFEDB52'),
  ('OBJ7334',  'EB6C5E9DB4643CAC'),
  ('OBJB733',  '61737A9F7D54EF5F'),
  ('OCA',  '9BC450E4C6569492'),
  ('ODM',  'C252E8FA117AF049'),
  ('ODM_MTR',  'A7A32CD03D3CE8D5'),
  ('ODS',  '89804494ADFC71BC'),
  ('ODSCOMMON',  '59BBED977430C1A8'),
  ('OE',  'D1A2DFC623FDA40A'),
  ('OKB',  'A01A5F0698FC9E31'),
  ('OKC',  '31C1DDF4D5D63FE6'),
  ('OKE',  'B7C1BB95646C16FE'),
  ('OKI',  '991C817E5FD0F35A'),
  ('OKL',  'DE058868E3D2B966'),
  ('OKO',  '6E204632EC7CA65D'),
  ('OKR',  'BB0E28666845FCDC'),
  ('OKS',  'C2B4C76AB8257DF5'),
  ('OKX',  'F9FDEB0DE52F5D6B'),
  ('OL810',  'E2DA59561CBD0296'),
  ('OL811',  'B3E88767A01403F8'),
  ('OL812',  'AE8C7989346785BA'),
  ('OL9',  '17EC83E44FB7DB5B'),
  ('OLAPSYS',  '3FB8EF9DB538647C'),
  ('ONT',  '9E3C81574654100A'),
  ('OPI',  '1BF23812A0AEEDA0'),
  ('ORABAM',  'D0A4EA93EF21CE25'),
  ('ORABAMSAMPLES',  '507F11063496F222'),
  ('ORABPEL',  '26EFDE0C9C051988'),
  ('ORAESB',  'CC7FCCB3A1719EDA'),
  ('ORAOCA_PUBLIC',  'FA99021634DDC111'),
  ('ORASAGENT',  '234B6F4505AD8F25'),
  ('ORASSO',  'F3701A008AA578CF'),
  ('ORASSO_DS',  '17DC8E02BC75C141'),
  ('ORASSO_PA',  '133F8D161296CB8F'),
  ('ORASSO_PS',  '63BB534256053305'),
  ('ORASSO_PUBLIC',  'C6EED68A8F75F5D3'),
  ('ORDPLUGINS',  '88A2B2C183431F00'),
  ('ORDSYS',  '7EFA02EC7EA6B86F'),
  ('OSM',  '106AE118841A5D8C'),
  ('OTA',  'F5E498AC7009A217'),
  ('OUTLN',  '4A3BA55E08595C81'),
  ('OWAPUB',  '6696361B64F9E0A9'),
  ('OWF_MGR',  '3CBED37697EB01D1'),
  ('OZF',  '970B962D942D0C75'),
  ('OZP',  'B650B1BB35E86863'),
  ('OZS',  '0DABFF67E0D33623'),
  ('PA',  '8CE2703752DB36D8'),
  ('PABLO',  '5E309CB43FE2C2FF'),
  ('PAIGE',  '02B6B704DFDCE620'),
  ('PAM',  '1383324A0068757C'),
  ('PARRISH',  '79193FDACFCE46F6'),
  ('PARSON',  'AE28B2BD64720CD7'),
  ('PAT',  'DD20769D59F4F7BF'),
  ('PATORILY',  '46B7664BD15859F9'),
  ('PATRICKSANCHEZ',  '47F74BD3AD4B5F0A'),
  ('PATSY',  '4A63F91FEC7980B7'),
  ('PAUL',  '35EC0362643ADD3F'),
  ('PAULA',  'BB0DC58A94C17805'),
  ('PAXTON',  '4EB5D8FAD3434CCC'),
  ('PCA1',  '8B2E303DEEEEA0C0'),
  ('PCA2',  '7AD6CE22462A5781'),
  ('PCA3',  'B8194D12FD4F537D'),
  ('PCA4',  '83AD05F1D0B0C603'),
  ('PCS1',  '2BE6DD3D1DEA4A16'),
  ('PCS2',  '78117145145592B1'),
  ('PCS3',  'F48449F028A065B1'),
  ('PCS4',  'E1385509C0B16BED'),
  ('PD7333',  '5FFAD8604D9DC00F'),
  ('PD7334',  'CDCF262B5EE254E1'),
  ('PD810',  'EB04A177A74C6BCB'),
  ('PD811',  '3B3C0EFA4F20AC37'),
  ('PD812',  'E73A81DB32776026'),
  ('PD9',  'CACEB3F9EA16B9B7'),
  ('PDA1',  'C7703B70B573D20F'),
  ('PEARL',  'E0AFD95B9EBD0261'),
  ('PEG',  '20577ED9A8DB8D22'),
  ('PENNY',  'BB6103E073D7B811'),
  ('PEOPLE',  '613459773123B38A'),
  ('PERCY',  'EB9E8B33A2DDFD11'),
  ('PERRY',  'D62B14B93EE176B6'),
  ('PETE',  '4040619819A9C76E'),
  ('PEYTON',  'B7127140004677FC'),
  ('PHIL',  '181446AE258EE2F6'),
  ('PJI',  '5024B1B412CD4AB9'),
  ('PJM',  '021B05DBB892D11F'),
  ('PMI',  'A7F7978B21A6F65E'),
  ('PN',  'D40D0FEF9C8DC624'),
  ('PO',  '355CBEC355C10FEF'),
  ('POA',  '2AB40F104D8517A0'),
  ('POLLY',  'ABC770C112D23DBE'),
  ('POM',  '123CF56E05D4EF3C'),
  ('PON',  '582090FD3CC44DA3'),
  ('PORTAL',  'A96255A27EC33614'),
  ('PORTAL_APP',  '831A79AFB0BD29EC'),
  ('PORTAL_DEMO',  'A0A3A6A577A931A3'),
  ('PORTAL_PUBLIC',  '70A9169655669CE8'),
  ('PORTAL30',  '969F9C3839672C6D'),
  ('PORTAL30_DEMO',  'CFD1302A7F832068'),
  ('PORTAL30_PUBLIC',  '42068201613CA6E2'),
  ('PORTAL30_SSO',  '882B80B587FCDBC8'),
  ('PORTAL30_SSO_PS',  'F2C3DC8003BC90F8'),
  ('PORTAL30_SSO_PUBLIC',  '98741BDA2AC7FFB2'),
  ('POS',  '6F6675F272217CF7'),
  ('PPM1',  'AA4AE24987D0E84B'),
  ('PPM2',  '4023F995FF78077C'),
  ('PPM3',  '12F56FADDA87BBF9'),
  ('PPM4',  '84E17CB7A3B0E769'),
  ('PPM5',  '804C159C660F902C'),
  ('PRISTB733',  '1D1BCF8E03151EF5'),
  ('PRISTCTL',  '78562A983A2F78FB'),
  ('PRISTDTA',  '3FCBC379C8FE079C'),
  ('PRODB733',  '9CCD49EB30CB80C4'),
  ('PRODCTL',  'E5DE2F01529AE93C'),
  ('PRODDTA',  '2A97CD2281B256BA'),
  ('PRODUSER',  '752E503EFBF2C2CA'),
  ('PROJMFG',  '34D61E5C9BC7147E'),
  ('PRP',  'C1C4328F8862BC16'),
  ('PS',  '0AE52ADF439D30BD'),
  ('PS810',  '90C0BEC7CA10777E'),
  ('PS810CTL',  'D32CCE5BDCD8B9F9'),
  ('PS810DTA',  'AC0B7353A58FC778'),
  ('PS811',  'B5A174184403822F'),
  ('PS811CTL',  '18EDE0C5CCAE4C5A'),
  ('PS811DTA',  '7961547C7FB96920'),
  ('PS812',  '39F0304F007D92C8'),
  ('PS812CTL',  'E39B1CE3456ECBE5'),
  ('PS812DTA',  '3780281C933FE164'),
  ('PSA',  'FF4B266F9E61F911'),
  ('PSB',  '28EE1E024FC55E66'),
  ('PSBASS',  'F739804B718D4406'),
  ('PSEM',  '40ACD8C0F1466A57'),
  ('PSFT',  '7B07F6F3EC08E30D'),
  ('PSFTDBA',  'E1ECD83073C4E134'),
  ('PSP',  '4FE07360D435E2F0'),
  ('PTADMIN',  '4C35813E45705EBA'),
  ('PTCNE',  '463AEFECBA55BEE8'),
  ('PTDMO',  '251D71390034576A'),
  ('PTE',  '380FDDB696F0F266'),
  ('PTESP',  '5553404C13601916'),
  ('PTFRA',  'A360DAD317F583E3'),
  ('PTG',  '7AB0D62E485C9A3D'),
  ('PTGER',  'C8D1296B4DF96518'),
  ('PTJPN',  '2159C2EAF20011BF'),
  ('PTUKE',  'D0EF510BCB2992A3'),
  ('PTUPG',  '2C27080C7CC57D06'),
  ('PTWEB',  '8F7F509D4DC01DF6'),
  ('PTWEBSERVER',  '3C8050536003278B'),
  ('PV',  '76224BCC80895D3D'),
  ('PY7333',  '2A9C53FE066B852F'),
  ('PY7334',  'F3BBFAE0DDC5F7AC'),
  ('PY810',  '95082D35E94B88C2'),
  ('PY811',  'DC548D6438E4D6B7'),
  ('PY812',  '99C575A55E9FDA63'),
  ('PY9',  'B8D4E503D0C4FCFD'),
  ('QA',  'C7AEAA2D59EB1EAE'),
  ('QOT',  'B27D0E5BA4DC8DEA'),
  ('QP',  '10A40A72991DCA15'),
  ('QRM',  '098286E4200B22DE'),
  ('QS',  '4603BCD2744BDE4F'),
  ('QS_ADM',  '3990FB418162F2A0'),
  ('QS_CB',  '870C36D8E6CD7CF5'),
  ('QS_CBADM',  '20E788F9D4F1D92C'),
  ('QS_CS',  '2CA6D0FC25128CF3'),
  ('QS_ES',  '9A5F2D9F5D1A9EF4'),
  ('QS_OS',  '0EF5997DC2638A61'),
  ('QS_WS',  '0447F2F756B4F460'),
  ('RENE',  '9AAD141AB0954CF0'),
  ('REPADMIN',  '915C93F34954F5F8'),
  ('REPORTS',  '0D9D14FE6653CF69'),
  ('REPORTS_USER',  '635074B4416CD3AC'),
  ('RESTRICTED_US',  'E7E67B60CFAFBB2D'),
  ('RG',  '0FAA06DA0F42F21F'),
  ('RHX',  'FFDF6A0C8C96E676'),
  ('RLA',  'C1959B03F36C9BB2'),
  ('RLM',  '4B16ACDA351B557D'),
  ('RM1',  'CD43500DAB99F447'),
  ('RM2',  '2D8EE7F8857D477E'),
  ('RM3',  '1A95960A95AC2E1D'),
  ('RM4',  '651BFD4E1DE4B040'),
  ('RM5',  'FDCC34D74A22517C'),
  ('RMAN',  'E7B5D92911C831E1'),
  ('ROB',  '94405F516486CA24'),
  ('RPARKER',  'CEBFE4C41BBCC306'),
  ('RWA1',  'B07E53895E37DBBB'),
  ('SALLYH',  '21457C94616F5716'),
  ('SAM',  '4B95138CB6A4DB94'),
  ('SARAHMANDY',  '60BE21D8711EE7D9'),
  ('SCM1',  '507306749131B393'),
  ('SCM2',  'CBE8D6FAC7821E85'),
  ('SCM3',  '2B311B9CDC70F056'),
  ('SCM4',  '1FDF372790D5A016'),
  ('SCOTT',  'F894844C34402B67'),
  ('SDAVIS',  'A9A3B88C6A550559'),
  ('SECDEMO',  '009BBE8142502E10'),
  ('SEDWARDS',  '00A2EDFD7835BC43'),
  ('SELLCM',  '8318F67F72276445'),
  ('SELLER',  'B7F439E172D5C3D0'),
  ('SELLTREAS',  '6EE7BA85E9F84560'),
  ('SERVICES',  'B2BE254B514118A5'),
  ('SETUP',  '9EA55682C163B9A3'),
  ('SH',  '54B253CBBAAA8C48'),
  ('SI_INFORMTN_SCHEMA',  '84B8CBCA4D477FA3'),
  ('SID',  'CFA11E6EBA79D33E'),
  ('SKAYE',  'ED671B63BDDB6B50'),
  ('SKYTETSUKA',  'EB5DA777D1F756EC'),
  ('SLSAA',  '99064FC6A2E4BBE8'),
  ('SLSMGR',  '0ED44093917BE294'),
  ('SLSREP',  '847B6AAB9471B0A5'),
  ('SRABBITT',  '85F734E71E391DF5'),
  ('SRALPHS',  '975601AA57CBD61A'),
  ('SRAY',  'C233B26CFC5DC643'),
  ('SRIVERS',  '95FE94ADC2B39E08'),
  ('SSA1',  'DEE6E1BEB962AA8B'),
  ('SSA2',  '96CA278B20579E34'),
  ('SSA3',  'C3E8C3B002690CD4'),
  ('SSC1',  '4F7AC652CC728980'),
  ('SSC2',  'A1350B328E74AE87'),
  ('SSC3',  'EE3906EC2DA586D8'),
  ('SSOSDK',  '7C48B6FF3D54D006'),
  ('SSP',  '87470D6CE203FB4D'),
  ('SSS1',  'E78C515C31E83848'),
  ('SUPPLIER',  '2B45928C2FE77279'),
  ('SVM7333',  '04B731B0EE953972'),
  ('SVM7334',  '62E2A2E886945CC8'),
  ('SVM810',  '0A3DCD8CA3B6ABD9'),
  ('SVM811',  '2B0CD57B1091C936'),
  ('SVM812',  '778632974E3947C9'),
  ('SVM9',  '552A60D8F84441F1'),
  ('SVMB733',  'DD2BFB14346146FE'),
  ('SVP1',  'F7BF1FFECE27A834'),
  ('SY810',  'D56934CED7019318'),
  ('SY811',  '2FDC83B401477628'),
  ('SY812',  '812B8D7211E7DEF1'),
  ('SY9',  '3991E64C4BC2EC5D'),
  ('SYS',  '43CA255A7916ECFE'),
  ('SYS',  '5638228DAF52805F'),
  ('SYS',  'D4C5016086B2DC6A'),
  ('SYS7333',  'D7CDB3124F91351E'),
  ('SYS7334',  '06959F7C9850F1E3'),
  ('SYSADMIN',  'DC86E8DEAA619C1A'),
  ('SYSB733',  '7A7F5C90BEC02F0E'),
  ('SYSMAN',  'EB258E708132DD2D'),
  ('SYSTEM',  '4D27CA6E3E3066E6'),
  ('SYSTEM',  'D4DF7931AB130E37'),
  ('TDEMARCO',  'CAB71A14FA426FAE'),
  ('TDOS_ICSAP',  '7C0900F751723768'),
  ('TESTCTL',  '205FA8DF03A1B0A6'),
  ('TESTDTA',  'EEAF97B5F20A3FA3'),
  ('TRA1',  'BE8EDAE6464BA413'),
  ('TRACESVR',  'F9DA8977092B7B81'),
  ('TRBM1',  'B10ED16CD76DBB60'),
  ('TRCM1',  '530E1F53715105D0'),
  ('TRDM1',  'FB1B8EF14CF3DEE7'),
  ('TRRM1',  '4F29D85290E62EBE'),
  ('TWILLIAMS',  '6BF819CE663B8499'),
  ('UDDISYS',  'BF5E56915C3E1C64'),
  ('VEA',  'D38D161C22345902'),
  ('VEH',  '72A90A786AAE2914'),
  ('VIDEO31',  '2FA72981199F9B97'),
  ('VIDEO4',  '9E9B1524C454EEDE'),
  ('VIDEO5',  '748481CFF7BE98BB'),
  ('VP1',  '3CE03CD65316DBC7'),
  ('VP2',  'FCCEFD28824DFEC5'),
  ('VP3',  'DEA4D8290AA247B2'),
  ('VP4',  'F4730B0FA4F701DC'),
  ('VP5',  '7DD67A696734AE29'),
  ('VP6',  '45660DEE49534ADB'),
  ('WAA1',  'CF013DC80A9CBEE3'),
  ('WAA2',  '6160E7A17091741A'),
  ('WCRSYS',  '090263F40B744BD8'),
  ('WEBDB',  'D4C4DCDD41B05A5D'),
  ('WEBSYS',  '54BA0A1CB5994D64'),
  ('WENDYCHO',  '7E628CDDF051633A'),
  ('WH',  '91792EFFCB2464F9'),
  ('WIP',  'D326D25AE0A0355C'),
  ('WIRELESS',  '1495D279640E6C3A'),
  ('WIRELESS',  'EB9615631433603E'),
  ('WK_TEST',  '29802572EB547DBF'),
  ('WKPROXY',  'AA3CB2A4D9188DDB'),
  ('WKSYS',  '545E13456B7DDEA0'),
  ('WMS',  'D7837F182995E381'),
  ('WMSYS',  '7C9BA362F8314299'),
  ('WPS',  '50D22B9D18547CF7'),
  ('WSH',  'D4D76D217B02BD7A'),
  ('WSM',  '750F2B109F49CC13'),
  ('XDB',  '88D8364765FCE6AF'),
  ('XDO',  'E9DDE8ACFA7FE8E4'),
  ('XDP',  'F05E53C662835FA2'),
  ('XLA',  '2A8ED59E27D86D41'),
  ('XLE',  'CEEBE966CC6A3E39'),
  ('XNB',  '03935918FA35C993'),
  ('XNC',  'BD8EA41168F6C664'),
  ('XNI',  'F55561567EF71890'),
  ('XNM',  '92776EA17B8B5555'),
  ('XNP',  '3D1FB783F96D1F5E'),
  ('XNS',  'FABA49C38150455E'),
  ('XTR',  'A43EE9629FA90CAE'),
  ('YCAMPOS',  'C3BBC657F099A10F'),
  ('YSANCHEZ',  'E0C033C4C8CC9D84'),
  ('ZFA',  '742E092A27DDFB77'),
  ('ZPB',  'CAF58375B6D06513'),
  ('ZSA',  'AFD3BD3C7987CBB6'),
  ('ZX',  '7B06550956254585'))
AND account_status NOT IN ('EXPIRED \& LOCKED' , 'LOCKED')
ORDER BY username;

-------------------------------------------------------------------------------------------------------------


1 comment :

  1. Thanks for sharing this information. I have found it to be very educative and although I am not a programming guru, I have been able to learn some programming basics and I will be visiting this site occasionally to read other programming articles especially after delegating my assignments to professional online writers who are specialists in Removing Mistakes from a Case Study.

    ReplyDelete

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html

Register and create an issue in the related category.
I will support you from there.