'1. IT Story/Scripts' 카테고리의 글 목록 (8 Page)

Oracle 테이블스페이스 용량확인 스크립트

1. IT Story/Scripts 2019. 2. 4. 12:30

Oracle 테이블스페이스 용량확인 스크립트

SELECT TABLESPACE_NAME,

TOTAL_BYTES,

USED_BYTES,

FREE_BYTES,

USED_RATE

FROM (SELECT X.TABLESPACE_NAME,

X.TOTAL_BYTES,

X.USED_BYTES,

X.FREE_BYTES,

X.USED_RATE

FROM (SELECT A.TABLESPACE_NAME TABLESPACE_NAME,

SUBSTR(To_Char(Round(A.TOTAL_BYTES/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round(A.TOTAL_BYTES/1024000000, 2), '990.99'),2,6) ||' GB)' TOTAL_BYTES,

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/1024000000,2), '990.99'),2,6) ||' GB)' USED_BYTES,

SUBSTR(To_Char(Round(B.FREE_BYTES/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round(B.FREE_BYTES/1024000000, 2), '990.99'),2,6) ||' GB)' FREE_BYTES,

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/A.TOTAL_BYTES*100,2), '90.99'),2,5)||'%' USED_RATE

FROM (SELECT TABLESPACE_NAME, Sum(BYTES) TOTAL_BYTES

FROM DBA_DATA_FILES

WHERE TABLESPACE_NAME LIKE UPPER(DECODE('%','','%', '%'))

GROUP BY TABLESPACE_NAME

) A,

(SELECT TABLESPACE_NAME, Sum(BYTES) FREE_BYTES

FROM USER_FREE_SPACE

WHERE TABLESPACE_NAME LIKE UPPER(DECODE('%','','%', '%'))

GROUP BY TABLESPACE_NAME

) B

WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME

) X

ORDER BY DECODE('&TS_ORDER_BASE', '1', X.TABLESPACE_NAME, '', X.TABLESPACE_NAME, '2', X.USED_RATE) DESC

)

UNION ALL

SELECT '------------------------------ ' TABLESPACE_NAME,

'-------------------------- ' TOTAL_BYTES,

'-------------------------- ' USED_BYTES,

'-------------------------- ' FREE_BYTES,

'----------' USED_RATE

FROM DUAL

UNION ALL

SELECT '전체' TABLESPACE_NAME,

SUBSTR(To_Char(Round(A.TOTAL_BYTES/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round(A.TOTAL_BYTES/1024000000, 2), '990.99'),2,6) ||' GB)' TOTAL_BYTES,

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/1024000000,2), '990.99'),2,6) ||' GB)' USED_BYTES,

SUBSTR(To_Char(Round(B.FREE_BYTES/1024000), '999,999,999'),2,11)||' MB ('||

SUBSTR(To_Char(Round(B.FREE_BYTES/1024000000, 2), '990.99'),2,6) ||' GB)' FREE_BYTES,

SUBSTR(To_Char(Round((A.TOTAL_BYTES-B.FREE_BYTES)/A.TOTAL_BYTES*100,2), '90.99'),2,5)||'%' USED_RATE

FROM (SELECT Sum(BYTES) TOTAL_BYTES

FROM DBA_DATA_FILES

WHERE TABLESPACE_NAME LIKE UPPER(DECODE('%','','%', '%'))

) A,

(SELECT Sum(BYTES) FREE_BYTES

FROM USER_FREE_SPACE

WHERE TABLESPACE_NAME LIKE UPPER(DECODE('%','','%', '%'))

) B

;

Select ts.tablespace_name, ts.status, ts.contents, ts.extent_management, ts.bigfile,

size_info.megs_alloc, size_info.megs_free, size_info.megs_used,

size_info.pct_free, size_info.pct_used, size_info.max

From

(

select a.tablespace_name,

round(a.bytes_alloc / 1024 / 1024) megs_alloc,

round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,

round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,

round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_Free,

100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,

round(maxbytes/1048576) Max

from ( select f.tablespace_name,

sum(f.bytes) bytes_alloc,

sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO', f.bytes)) maxbytes

from dba_data_files f

group by tablespace_name) a,

( select f.tablespace_name,

sum(f.bytes) bytes_free

from dba_free_space f

group by tablespace_name) b

where a.tablespace_name = b.tablespace_name (+)

union all

select h.tablespace_name,

round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,

round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / 1048576) megs_free,

round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,

round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,

100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,

round(sum(f.maxbytes) / 1048576) max

from sys.v_$TEMP_SPACE_HEADER h, sys.v_$Temp_extent_pool p, dba_temp_files f

where p.file_id(+) = h.file_id

and p.tablespace_name(+) = h.tablespace_name

and f.file_id = h.file_id

and f.tablespace_name = h.tablespace_name

group by h.tablespace_name

) size_info,

sys.dba_tablespaces ts

where ts.tablespace_name = size_info.tablespace_name

;

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

ORACLE SCN HELTH CHECK (0)	2019.02.17
Mysql DB 기본 점검 스크립트 (0)	2019.02.09
Oracle DBMS_SCHEDULER 백업 설정 스크립트 (0)	2019.02.06
Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle 권한확인 스크립트

1. IT Story/Scripts 2019. 2. 3. 11:26

Oracle 권한확인 스크립트

set verify off

set linesize 120

set pagesize 60

column sort_id noprint

column priv_type format a35

column priv format a60

column grantable heading "ADM" format a3

column default_role heading "DEF" format a3

spool showAllPrivs.txt

select

1 as sort_id,

'ROLE' as priv_type,

a.granted_role as priv,

a.admin_option as grantable,

a.default_role as default_role

from

DBA_ROLE_PRIVS a

where

grantee = '&&enter_username'

union

select

2 as sort_id,

'SYS PRIV' as priv_type,

b.privilege as priv,

b.admin_option as grantable,

null as default_role

from

DBA_SYS_PRIVS b

where

grantee = '&&enter_username'

union

select

5 as sort_id,

'TAB PRIV (ROLE "' || c.granted_role || '")' as priv_type,

d.privilege || ' on "' || d.owner ||

'"."' || d.table_name || '"'

as priv,

d.grantable as grantable,

c.default_role as default_role

from

DBA_ROLE_PRIVS c,

DBA_TAB_PRIVS d

where

c.grantee = '&&enter_username'

and d.grantee = c.granted_role

union

select

7 as sort_id,

'COL PRIV (ROLE "' || e.granted_role || '")' as priv_type,

f.privilege || ' on "' || f.owner ||

'"."' || f.table_name || '" ("' || f.column_name || '"

;)'

as priv,

f.grantable as grantable,

e.default_role as default_role

from

DBA_ROLE_PRIVS e,

DBA_COL_PRIVS f

where

e.grantee = '&&enter_username'

and f.grantee = e.granted_role

union

select

4 as sort_id,

'TAB PRIV' as priv_type,

g.privilege || ' on "' || g.owner ||

'"."' || g.table_name || '"'

as priv,

g.grantable as grantable,

null as default_role

from

DBA_TAB_PRIVS g

where

g.grantee = '&&enter_username'

union

select

6 as sort_id,

'COL PRIV' as priv_type,

h.privilege || ' on "' || h.owner ||

'"."' || h.table_name || '" ("' || h.column_name || '"

;)'

as priv,

h.grantable as grantable,

null as default_role

from

DBA_COL_PRIVS h

where

h.grantee = '&&enter_username'

union

select

3 as sort_id,

'SYS PRIV (ROLE "' || i.granted_role || '")' as priv_type,

j.privilege as priv,

j.admin_option as grantable,

i.default_role as default_role

from

DBA_ROLE_PRIVS i,

DBA_SYS_PRIVS j

where

i.grantee = '&&enter_username'

and j.grantee = i.granted_role

order by 1, 2, 3 ;

undefine enter_username

clear columns

spool off

set linesize 80

set verify on

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Mysql DB 기본 점검 스크립트 (0)	2019.02.09
Oracle DBMS_SCHEDULER 백업 설정 스크립트 (0)	2019.02.06
Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle SEGMENT STAT 조회 스크립트

1. IT Story/Scripts 2019. 1. 29. 23:23

SEGMENT STAT 조회 스크립트

WITH A

AS ( SELECT DBID,

OBJ#,

SUM (LOGICAL_READS_DELTA) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS_DELTA) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES_DELTA) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS_DELTA) PHYSICAL_READS,

SUM (PHYSICAL_WRITES_DELTA) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT_DELTA) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT_DELTA) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS_DELTA) ITL_WAITS,

SUM (ROW_LOCK_WAITS_DELTA) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED_DELTA) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED_DELTA) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED_DELTA) SPACE_USED,

SUM (SPACE_ALLOCATED_DELTA) SPACE_ALLOCATED,

SUM (TABLE_SCANS_DELTA) TABLE_SCANS

FROM DBA_HIST_SEG_STAT

WHERE DBID = (select dbid from v$database) --변경

AND INSTANCE_NUMBER = (select INSTANCE_NUMBER from v$instance) --변경

AND SNAP_ID BETWEEN :3 AND :4

GROUP BY DBID, OBJ#),

A_TOT

AS (SELECT NULL DBID,

NULL OBJ#,

SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS,

COUNT (DISTINCT OBJ#) OBJ_CNT

FROM A),

A_LR

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'LOGICAL READS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

LOGICAL_READS DESC, PHYSICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :5 AND ROWNUM <= :6),

A_BBW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'BUFFER BUSY WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

BUFFER_BUSY_WAITS DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :7 AND ROWNUM <= :8),

A_DBC

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'DB_BLOCK CHANGES' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

DB_BLOCK_CHANGES DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :9 AND ROWNUM <= :10),

A_PR

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL READS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_READS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :11 AND ROWNUM <= :12),

A_PW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL WRITES' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_WRITES DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :13 AND ROWNUM <= :14),

A_PRD

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL READS DIRECT' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_READS_DIRECT DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :15 AND ROWNUM <= :16),

A_IW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'ITL WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

ITL_WAITS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :17 AND ROWNUM <= :18),

A_RLW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'ROW LOCK WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

ROW_LOCK_WAITS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :19 AND ROWNUM <= :20),

A_GCRBS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'GC CR BLOCKS SERVED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

GC_CR_BLOCKS_SERVED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :21 AND ROWNUM <= :22),

A_GCUBS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'GC CU BLOCKS SERVED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

GC_CU_BLOCKS_SERVED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :23 AND ROWNUM <= :24),

A_SU

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'SPACE USED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

SPACE_USED DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :25 AND ROWNUM <= :26),

A_SA

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'SPACE ALLOCATED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

SPACE_ALLOCATED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :27 AND ROWNUM <= :28),

A_TS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'TABLE SCANS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

TABLE_SCANS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :29 AND ROWNUM <= :30)

SELECT /*+ OPT_PARAM('_gby_hash_aggregation_enabled','TRUE') OPT_PARAM('_optimizer_distinct_agg_transform','FALSE') BUG_9002336 */

A.VIEWTYPE,

A.TOR,

A.RNUM,

A.OWNER,

DECODE (A.SUBOBJECT_NAME,

NULL, A.OBJECT_NAME,

A.OBJECT_NAME || '(' || A.SUBOBJECT_NAME || ')')

OBJECT_NAME,

A.OBJECT_TYPE,

TO_CHAR (A.LOGICAL_READS,

'FM999,999,999,999,999,999,999,999,999,999,999')

LOGICAL_READS,

TO_CHAR (A.BUFFER_BUSY_WAITS,

'FM999,999,999,999,999,999,999,999,999,999,999')

BUFFER_BUSY_WAITS,

TO_CHAR (A.DB_BLOCK_CHANGES,

'FM999,999,999,999,999,999,999,999,999,999,999')

DB_BLOCK_CHANGES,

TO_CHAR (A.PHYSICAL_READS,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_READS,

TO_CHAR (A.PHYSICAL_WRITES,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_WRITES,

TO_CHAR (A.PHYSICAL_READS_DIRECT,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_READS_DIRECT,

TO_CHAR (A.PHYSICAL_WRITES_DIRECT,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_WRITES_DIRECT,

TO_CHAR (A.ITL_WAITS, 'FM999,999,999,999,999,999,999,999,999,999,999')

ITL_WAITS,

TO_CHAR (A.ROW_LOCK_WAITS,

'FM999,999,999,999,999,999,999,999,999,999,999')

ROW_LOCK_WAITS,

TO_CHAR (A.GC_CR_BLOCKS_SERVED,

'FM999,999,999,999,999,999,999,999,999,999,999')

GC_CR_BLOCKS_SERVED,

TO_CHAR (A.GC_CU_BLOCKS_SERVED,

'FM999,999,999,999,999,999,999,999,999,999,999')

GC_CU_BLOCKS_SERVED,

TO_CHAR (A.SPACE_USED,

'FM999,999,999,999,999,999,999,999,999,999,999')

SPACE_USED,

TO_CHAR (A.SPACE_ALLOCATED,

'FM999,999,999,999,999,999,999,999,999,999,999')

SPACE_ALLOCATED,

TO_CHAR (A.TABLE_SCANS,

'FM999,999,999,999,999,999,999,999,999,999,999')

TABLE_SCANS

FROM (SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

1 TOR

FROM A_LR

UNION ALL

SELECT 'LOGICAL READS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

1 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_LR) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

3 TOR

FROM A_BBW

UNION ALL

SELECT 'BUFFER BUSY WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

3 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_BBW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

4 TOR

FROM A_DBC

UNION ALL

SELECT 'DB_BLOCK CHANGES' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

4 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_DBC) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

2 TOR

FROM A_PR

UNION ALL

SELECT 'PHYSICAL READS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

2 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PR) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

5 TOR

FROM A_PW

UNION ALL

SELECT 'PHYSICAL WRITES' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

5 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

6 TOR

FROM A_PRD

UNION ALL

SELECT 'PHYSICAL READS DIRECT' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

6 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PRD) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

7 TOR

FROM A_IW

UNION ALL

SELECT 'ITL WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

7 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_IW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

8 TOR

FROM A_RLW

UNION ALL

SELECT 'ROW LOCK WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

8 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_RLW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

9 TOR

FROM A_GCRBS

UNION ALL

SELECT 'GC CR BLOCKS SERVED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

9 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_GCRBS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

10 TOR

FROM A_GCUBS

UNION ALL

SELECT 'GC CU BLOCKS SERVED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

10 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_GCUBS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

11 TOR

FROM A_SU

UNION ALL

SELECT 'SPACE USED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

11 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_SU) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

12 TOR

FROM A_SA

UNION ALL

SELECT 'SPACE ALLOCATED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

12 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_SA) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

13 TOR

FROM A_TS

UNION ALL

SELECT 'TABLE SCANS' VIEWTYPE,

NULL RNUM,

0 DBID,

TO_CHAR (V2.OBJ_CNT) OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

13 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS,

SUM (OBJ_CNT) OBJ_CNT

FROM A_TOT) V2) A

ORDER BY TOR, VIEWTYPE, RNUM

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle DBMS_SCHEDULER 백업 설정 스크립트 (0)	2019.02.06
Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle 인덱스 정리 대상 추출 스크립트

1. IT Story/Scripts 2019. 1. 28. 22:20

Oracle 인덱스 정리 대상 추출 스크립트

set linesize 130

set pagesize 10000

col "OWNER" form a8

col table_name form a30

col "삭제대상 INDEX" form a35

col "삭제원인 INDEX" form a51

select

di.table_owner "OWNER"

,di.table_name

,dic1.index_name || chr(10) || '>' || replace(dic1.index_cols,' ',',') || decode(sign(dic1.cnt-6),1,'...') "삭제대상 INDEX"

,dic2.index_name || chr(10) || '>' || replace(dic2.index_cols,' ',',') || decode(sign(dic1.cnt-7),1,'...') "삭제원인 INDEX"

from

dba_indexes di

,(

select

table_owner,table_name,index_owner,index_name,

TRIM(MAX(DECODE(column_position, 1, column_name)) || ' ' ||

MAX(DECODE(column_position, 2, column_name)) || ' ' ||

MAX(DECODE(column_position, 3, column_name)) || ' ' ||

MAX(DECODE(column_position, 4, column_name)) || ' ' ||

MAX(DECODE(column_position, 5, column_name)) || ' ' ||

MAX(DECODE(column_position, 6, column_name))) INDEX_COLS,count(*) cnt

from dba_ind_columns dic

where table_owner not in ('SYS','SYSTEM')

group by

table_owner,table_name,index_owner,index_name

) dic1

,(

select

table_owner,table_name,index_owner,index_name,

TRIM(MAX(DECODE(column_position, 1, column_name)) || ' ' ||

MAX(DECODE(column_position, 2, column_name)) || ' ' ||

MAX(DECODE(column_position, 3, column_name)) || ' ' ||

MAX(DECODE(column_position, 4, column_name)) || ' ' ||

MAX(DECODE(column_position, 5, column_name)) || ' ' ||

MAX(DECODE(column_position, 6, column_name)) || ' ' ||

MAX(DECODE(column_position, 7, column_name))) INDEX_COLS,count(*) cnt

from dba_ind_columns dic

where table_owner not in ('SYS','SYSTEM')

group by

table_owner,table_name,index_owner,index_name

) dic2

where

di.table_owner not in ('SYS','SYSTEM')

and di.owner=dic1.index_owner

and di.index_name=dic1.index_name

and di.table_owner=dic1.table_owner

and di.table_name=dic1.table_name

and dic1.table_owner=dic2.table_owner

and dic1.table_name=dic2.table_name

and dic1.index_name<>dic2.index_name

and dic2.index_cols like dic1.index_cols || '%'

and dic2.cnt>dic1.cnt

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19
Oracle Wait Event 조회 스크립트 (0)	2019.01.16

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle DB의 OS 상태 조회 스크립트

1. IT Story/Scripts 2019. 1. 27. 12:15

Oracle DB의 OS 상태 조회 스크립트

SELECT SNAP_TIME,

SUM (CASE STAT_NAME WHEN 'USER_TIME' THEN VALUE END) USER_TIME,

SUM (CASE STAT_NAME WHEN 'SYS_TIME' THEN VALUE END) SYS_TIME,

SUM (CASE STAT_NAME WHEN 'BUSY_TIME' THEN VALUE END) BUSY_TIME,

SUM (CASE STAT_NAME WHEN 'IOWAIT_TIME' THEN VALUE END) IOWAIT_TIME,

SUM (CASE STAT_NAME WHEN 'IDLE_TIME' THEN VALUE END) IDLE_TIME,

SUM (CASE STAT_NAME WHEN 'AVG_USER_TIME' THEN VALUE END) AVG_USER_TIME,

SUM (CASE STAT_NAME WHEN 'AVG_SYS_TIME' THEN VALUE END) AVG_SYS_TIME,

SUM (CASE STAT_NAME WHEN 'AVG_BUSY_TIME' THEN VALUE END) AVG_BUSY_TIME,

SUM (CASE STAT_NAME WHEN 'AVG_IOWAIT_TIME' THEN VALUE END)

AVG_IOWAIT_TIME,

SUM (CASE STAT_NAME WHEN 'AVG_IDLE_TIME' THEN VALUE END) AVG_IDLE_TIME,

SUM (CASE STAT_NAME WHEN 'LOAD' THEN VALUE END) LOAD,

SUM (CASE STAT_NAME WHEN 'NUM_CPUS' THEN VALUE END) NUM_CPUS,

SUM (CASE STAT_NAME WHEN 'NUM_CPU_SOCKETS' THEN VALUE END)

NUM_CPU_SOCKETS,

SUM (CASE STAT_NAME WHEN 'OS_CPU_WAIT_TIME' THEN VALUE END)

OS_CPU_WAIT_TIME,

SUM (CASE STAT_NAME WHEN 'PHYSICAL_MEMORY_BYTES' THEN VALUE END)

PHYSICAL_MEMORY_BYTES,

SUM (CASE STAT_NAME WHEN 'RSRC_MGR_CPU_WAIT_TIME' THEN VALUE END)

RSRC_MGR_CPU_WAIT_TIME,

SUM (CASE STAT_NAME WHEN 'VM_IN_BYTES' THEN VALUE END) VM_IN_BYTES,

SUM (CASE STAT_NAME WHEN 'VM_OUT_BYTES' THEN VALUE END) VM_OUT_BYTES

FROM (SELECT STAT_NAME,

START_TIME SNAP_TIME,

VALUE,

VALUE_DIFF

FROM (SELECT STAT_NAME,

TO_CHAR (SNAP_TIME_C1, 'MM.DD HH24:MI') START_TIME,

TO_CHAR (SNAP_TIME_C2, 'MM.DD HH24:MI') END_TIME,

DECODE (

SNAP_TIME_C2,

NULL, 0,

ROUND (

(CASE

WHEN VALUE_2 < VALUE_1 THEN 0

ELSE VALUE_2 - VALUE_1

END)

/ (EXTRACT (

DAY FROM SNAP_TIME_C2 - SNAP_TIME_C1)

* 86400

+ EXTRACT (

HOUR FROM SNAP_TIME_C2 - SNAP_TIME_C1)

* 3600

+ EXTRACT (

MINUTE FROM SNAP_TIME_C2 - SNAP_TIME_C1)

* 60

+ EXTRACT (

SECOND FROM SNAP_TIME_C2 - SNAP_TIME_C1)),

1))

VALUE,

(CASE

WHEN VALUE_2 < VALUE_1 THEN 0

ELSE VALUE_2 - VALUE_1

END)

VALUE_DIFF,

ROW_NUMBER ()

OVER (PARTITION BY INSTANCE_NUMBER, STAT_NAME

ORDER BY SNAP_ID)

RNUM,

SNAP_ID,

INSTANCE_NUMBER

FROM (SELECT END_TIME SNAP_TIME_C1,

LEAD (

END_TIME)

OVER (PARTITION BY INSTANCE_NUMBER, STAT_NAME

ORDER BY SNAP_ID)

SNAP_TIME_C2,

VALUE VALUE_1,

LEAD (

VALUE)

OVER (PARTITION BY INSTANCE_NUMBER, STAT_NAME

ORDER BY SNAP_ID)

VALUE_2,

STAT_NAME,

SNAP_ID,

INSTANCE_NUMBER

FROM (SELECT SNAP.END_INTERVAL_TIME END_TIME,

SNAP.SNAP_ID,

DHO.STAT_NAME,

DHO.VALUE,

DHO.INSTANCE_NUMBER

FROM DBA_HIST_OSSTAT DHO,

DBA_HIST_SNAPSHOT SNAP

WHERE DHO.SNAP_ID = SNAP.SNAP_ID

AND DHO.DBID = SNAP.DBID

AND DHO.INSTANCE_NUMBER =

SNAP.INSTANCE_NUMBER

AND DHO.DBID = (select dbid from v$database) --변경

AND DHO.INSTANCE_NUMBER = (select INSTANCE_NUMBER from v$instance) --변경

AND DHO.SNAP_ID >= :3

AND DHO.SNAP_ID <= :4))))

GROUP BY SNAP_TIME

ORDER BY SNAP_TIME

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19
Oracle Wait Event 조회 스크립트 (0)	2019.01.16
Oracle Rawdevice구성 RMAN Backup스크립트 (0)	2019.01.15

운명을바꾸는자

IT와 함께 살아가는 삶

,

OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트

1. IT Story/Scripts 2019. 1. 24. 11:35

OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트

1. OS VMSTAT 5초단위로 상태 출력

while true

do

cpu=`/usr/bin/vmstat 1 2 | sed 1,3d | awk '{u=100-$15;printf("%s %s %s %s %s %s %s %s",u,$1,$3,$4,$9,$10,$13,$14)}'`

wasmq=`netstat -na | grep EST | grep 70.121.238.221 | wc -l`

echo "$cpu" "$wasmq"

sleep 5

done

2. DB Session 5초 단위로 상태 출력

while true; do

sh /oracle/test/mon.sh

sleep 5

done

1) mon.sh

col sid for 9999

col waiting_on for a75

col serial# for 999999

col prg for a13

col OraPid for 9999

col command for a10

col aa Heading "DB-User" for a8

col bb Heading "OS-Pid" for a9

set pau off

select s.sid SID,s.serial#,

decode(s.command,

'0','NO',

'1','Create Tab',

'2','Insert',

'3','Select',

'6','Update',

'7','Delete',

'9','Create Idx',

'10','Drop Idx',

'15','Alter Tbl',

'24','Create Proc',

'32','Create Link',

'33','Drop Link',

'36','Create RBS',

'37','Alter RBS',

'38','Drop RBS',

'40','Alter TBS',

'41','Drop TBS',

'42','Alter Sess',

'45','Rollback',

'47','PL/SQL Exe',

'62','Anal Table',

'63','Anal Index',

'85','Truncate') Command,

substr(s.program, 1, 13) prg,

p.spid bb,

substr(

rtrim(w.event) || ': ' ||

rtrim(w.p1text,' ') || ' ' || to_char(w.p1) || ',' ||

rtrim(w.p2text,' ') || ' ' || to_char(w.p2) || ',' ||

rtrim(w.p3text,' ') || ' ' || to_char(w.p3),1,75) as waiting_on

from v$process p, v$session s, v$session_wait w

where

-- w.wait_time=0

w.sid = s.sid

and s.paddr = p.addr

and w.event not like '%pmon timer%'

and w.event not like '%rdbms ipc%'

and w.event not like '%smon timer%'

and w.event not like '%SQL*Net%'

and w.event not like '%lock manager wait for%'

and w.event not like '%slave wait%'

and w.event not like '%io done%'

and w.event not like '%pipe get%'

and w.event not like '%Streams AQ%'

order by 6,1

/

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19
Oracle Wait Event 조회 스크립트 (0)	2019.01.16
Oracle Rawdevice구성 RMAN Backup스크립트 (0)	2019.01.15
오라클 SQL TRACE 추출 스크립트 (0)	2019.01.13

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle Alert Log Viewer (11gR2)

1. IT Story/Scripts 2019. 1. 19. 20:31

Oracle Alert Log Viewer (11gR2)

SET SERVEROUTPUT ON

SPOOL ALERT.LOG

DECLARE

V_PERCENT NUMBER := .05;

V_BDUMP VARCHAR2 (1000);

V_NAME VARCHAR2 (20);

V_FILE VARCHAR2 (20);

V_LINE VARCHAR2 (8000);

V_HANDLE UTL_FILE.FILE_TYPE;

V_DIR_STMT VARCHAR2 (100);

V_SIZE INTEGER;

V_BSIZE INTEGER;

V_EXISTS BOOLEAN;

BEGIN

SELECT VALUE

INTO V_BDUMP

FROM V$PARAMETER

WHERE NAME = 'background_dump_dest';

DBMS_OUTPUT.PUT_LINE (

'**************************** INFO *************************');

DBMS_OUTPUT.PUT_LINE ('BDUMP: ' || V_BDUMP);

SELECT VALUE

INTO V_NAME

FROM V$PARAMETER

WHERE NAME = 'instance_name';

DBMS_OUTPUT.PUT_LINE ('DB NAME: ' || V_NAME);

V_FILE := 'alert_' || V_NAME || '.log';

DBMS_OUTPUT.PUT_LINE ('FILENAME: ' || V_FILE);

V_DIR_STMT := 'CREATE DIRECTORY ALERT AS ''' || V_BDUMP || '''';

DBMS_OUTPUT.PUT_LINE ('COMMAND: ' || V_DIR_STMT);

EXECUTE IMMEDIATE V_DIR_STMT;

V_HANDLE := UTL_FILE.FOPEN ('ALERT', V_FILE, 'r');

UTL_FILE.FGETATTR ('ALERT',

V_FILE,

V_EXISTS,

V_SIZE,

V_BSIZE);

DBMS_OUTPUT.PUT_LINE ('ALERT SIZE: ' || V_SIZE / 1024 / 1024 || ' MB');

UTL_FILE.FSEEK (V_HANDLE, NULL, V_SIZE * (1 - V_PERCENT));

DBMS_OUTPUT.PUT_LINE (

'FETCHED ALERT SIZE: ' || V_SIZE * (V_PERCENT / 1024 / 1024) || ' MB');

DBMS_OUTPUT.PUT_LINE (

'********************************************************');

LOOP

BEGIN

UTL_FILE.GET_LINE (V_HANDLE, V_LINE);

DBMS_OUTPUT.PUT_LINE (V_LINE);

EXCEPTION

WHEN NO_DATA_FOUND

THEN

EXIT;

END;

END LOOP;

UTL_FILE.FCLOSE (V_HANDLE);

EXECUTE IMMEDIATE 'DROP DIRECTORY ALERT';

END;

/

SPOOL OFF;

SELECT ORIGINATING_TIMESTAMP,

MODULE_ID,

PROCESS_ID,

MESSAGE_TEXT

FROM X$DBGALERTEXT

ORDER BY ORIGINATING_TIMESTAMP DESC;

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Wait Event 조회 스크립트 (0)	2019.01.16
Oracle Rawdevice구성 RMAN Backup스크립트 (0)	2019.01.15
오라클 SQL TRACE 추출 스크립트 (0)	2019.01.13
Oracle DB 기본 점검 스크립트 (0)	2019.01.10

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle Wait Event 조회 스크립트

1. IT Story/Scripts 2019. 1. 16. 19:52

Oracle Wait Event 조회 스크립트

select cast(min(sn.begin_interval_time) over (partition by sn.dbid,sn.snap_id) as date) snap_time, --workaround to uniform snap_time over all instances in RAC

--ss.dbid, --uncomment if you have multiple dbid in your AWR

sn.instance_number,

ss.event_name,

ss.wait_class,

ss.total_waits,

ss.time_waited_micro,

ss.total_waits - lag(ss.total_waits) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first) Delta_waits,

ss.time_waited_micro - lag(ss.time_waited_micro) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first) Delta_timewaited,

round((ss.total_waits - lag(ss.total_waits) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first)) /

(extract(hour from END_INTERVAL_TIME-begin_interval_time)*3600

-extract(hour from sn.snap_timezone - lag(sn.snap_timezone) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first) )*3600 --deals with daylight savings time change

+ extract(minute from END_INTERVAL_TIME-begin_interval_time)* 60

+ extract(second from END_INTERVAL_TIME-begin_interval_time)),2 ) Waits_per_sec,

round((ss.time_waited_micro - lag(ss.time_waited_micro) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first)) /

(extract(hour from END_INTERVAL_TIME-begin_interval_time)*3600

-extract(hour from sn.snap_timezone - lag(sn.snap_timezone) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first) )*3600 --deals with daylight savings time change

+ extract(minute from END_INTERVAL_TIME-begin_interval_time)* 60

+ extract(second from END_INTERVAL_TIME-begin_interval_time)),2 ) Rate_timewaited, -- time_waited_microsec/clock_time_sec

round((ss.time_waited_micro - lag(ss.time_waited_micro) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first)) /

nullif(ss.total_waits - lag(ss.total_waits) over (partition by ss.dbid,ss.instance_number,ss.event_id order by sn.snap_id nulls first),0),2) Avg_wait_time_micro

from dba_hist_system_event ss,

dba_hist_snapshot sn

where

sn.snap_id = ss.snap_id

and sn.dbid = ss.dbid

and sn.instance_number = ss.instance_number

and sn.begin_interval_time between sysdate-7 and sysdate

order by sn.snap_id

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19
Oracle Rawdevice구성 RMAN Backup스크립트 (0)	2019.01.15
오라클 SQL TRACE 추출 스크립트 (0)	2019.01.13
Oracle DB 기본 점검 스크립트 (0)	2019.01.10
Oracle RMAN FULL BACKUP 스크립트 (0)	2019.01.09

운명을바꾸는자

IT와 함께 살아가는 삶

,

'1. IT Story/Scripts'에 해당되는 글 75건

Oracle 테이블스페이스 용량확인 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 권한확인 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle SEGMENT STAT 조회 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 인덱스 정리 대상 추출 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle DB의 OS 상태 조회 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle Alert Log Viewer (11gR2)

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle Wait Event 조회 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

공지사항

카테고리

태그목록

글 보관함

달력

링크

운명을바꾸는자

LATEST FROM OUR BLOG

LATEST COMMENTS

티스토리툴바