/*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
------------------------------------------------------------------------------------------------------------
/*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;
alter session set events 'immediate trace name FILE_HDRS level 10';
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"
------------------------------------------------------------------------------------------------------------
/*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;
/*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';
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*/
------------------------------------------------------------------------------------------------------------
/*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
/*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
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
/*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
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;
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*/
--------------------------------------
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 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;
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 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';
/* 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'
/
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
/*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;
-------------------------------------------------------------------------------------------------------------
/*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;
-------------------------------------------------------------------------------------------------------------
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